this is the result of the sp for amcid = 1910 unitid amcno thsk tsk tssk tusk awg da vda pfamt sacamt esiamt ts2 AHO20DP052 9921.36600 8865.31945 8317.76000 31453.64245 8198133.44 0.00 1201554.58 5840151.72 532868.36 1460037.93
On Wednesday, October 14, 2020 at 10:40:53 AM UTC+5:30 T.R.Rajkumar wrote: > > I get this error for a particular amcid = 1910, for others it is working > ok. What might be the problem. The sp > > usr_getconlabqty_amc_new is indeed returning row from db when checked in the > backend. please elucidate. > > Error ticket for "web_ocms" Ticket ID > > 127.0.0.1.2020-10-14.10-26-27.939fd264-ebf8-4e08-aa76-2ca0d84a5703 > <type 'exceptions.TypeError'> 'NoneType' object is not iterable Version > web2py™ Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 > Python Python 2.7.5: D:\Python\python.exe (prefix: D:\Python) Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > > Traceback (most recent call last): > File "D:\web2py\gluon\restricted.py", line 227, in restricted > exec ccode in environment > File "D:/web2py/applications/web_ocms/controllers/amc.py" > <http://127.0.0.1:8000/admin/default/edit/web_ocms/controllers/amc.py>, line > 407, in <module> > File "D:\web2py\gluon\globals.py", line 417, in <lambda> > self._caller = lambda f: f() > File "D:/web2py/applications/web_ocms/controllers/amc.py" > <http://127.0.0.1:8000/admin/default/edit/web_ocms/controllers/amc.py>, line > 247, in schII > rowsconlab = db.executesql("exec usr_getconlabqty_amc_new > @amcid=?",placeholders=([amcid]),as_dict=True) > File "D:\web2py\gluon\packages\dal\pydal\base.py", line 1028, in executesql > fields = colnames or [f[0] for f in columns] > TypeError: 'NoneType' object is not iterable > > Error snapshot [image: help] > <http://127.0.0.1:8000/admin/default/ticket/web_ocms/127.0.0.1.2020-10-14.10-26-27.939fd264-ebf8-4e08-aa76-2ca0d84a5703#> > > > <type 'exceptions.TypeError'>('NoneType' object is not iterable) > > inspect attributes > Frames > > - > > *File D:\web2py\gluon\restricted.py in restricted at line 227* code > arguments variables > - > > *File D:\web2py\applications\web_ocms\controllers\amc.py in <module> > at line 407* code arguments variables > - > > *File D:\web2py\gluon\globals.py in <lambda> at line 417* code > arguments variables > - > > *File D:\web2py\applications\web_ocms\controllers\amc.py in schII at > line 247* code arguments variables > - > > *File D:\web2py\gluon\packages\dal\pydal\base.py in executesql at line > 1028* code arguments variables > Function argument list > > (self=<DAL uri="mssql2:******@172.16.164.60\SQL16S7INS1/ocms_nlc">, > query='exec usr_getconlabqty_amc_new @amcid=?', placeholders=['1910'], > as_dict=True, fields=None, colnames=None, as_ordered_dict=False) > Code listing > > 1023. > 1024. > 1025. > 1026. > 1027. > 1028. > > 1029. > 1030. > 1031. > 1032. > > # Non-DAL legacy db query, converts cursor results to dict. > # sequence of 7-item sequences. each sequence tells about a > column. > # first item is always the field name according to Python > Database API specs > columns = adapter.cursor.description > # reduce the column info down to just the field names > fields = colnames or [f[0] for f in columns] > > if len(fields) != len(set(fields)): > raise RuntimeError("Result set includes duplicate column > names. Specify unique column names using the 'colnames' argument") > #: avoid bytes strings in columns names (py3) > if columns and not PY2: > > Variables > fields None > colnames None > columns None > f undefined > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/df927438-f572-40ac-8db3-52ea122845cen%40googlegroups.com.
