The print rowsconlab for id other than 1910 is web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2020 Version 2.14.6-stable+timestamp.2016.05.10.00.21.47 Database drivers available: sqlite3, imaplib, pyodbc, pymysql, pg8000 please visit: http://127.0.0.1:8000/ starting browser... [{'thsk': '0.00000', 'tsk': '0.00000', 'unitid': 'ts2', 'da': '0.00', 'vda': '0. 00', 'sacamt': '0.00', 'amcno': 'PLT17CS051', 'tusk': '0.00000', 'awg': '0.00', 'esiamt': '0.00', 'pfamt': '0.00', 'tssk': '0.00000'}]
for id 1910 there is nothing printed in the cmd window. but the sp does return result below for id 1910 unitid amcno thsk tsk tssk tusk awg da vda pfamt sacamt esiamt ts2 AHO20DP057 10.00000 0.00000 0.00000 10.00000 2800.00 0.00 460.00 2042.56 186.78 510.64 for reasons unknow to me web2py dal is not reading the result, resulting in None type object not iterable error. -- 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/b412c91d-090f-4048-8c69-4292e7978a33o%40googlegroups.com.