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.

Reply via email to