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/e43d24a7-2db8-44b3-ba29-e4a1f421809fo%40googlegroups.com.