Ok, I'm at a loss for what the problem could be. To further troubleshoot I'd probably open a web2py shell for your app and try different things with a good amcid and with 1910.
python web2py.py -S application_name (http://web2py.com/books/default/chapter/29/04/the-core#Command-line-options) I'd try -hard coding the stored procedure call with the id instead of using variable substitution -depending on how complex the stored procedure is, start issuing those sql statements and see if you can determine where something is going wrong -when you say the sp does return values for that id, are you testing via python (not using pydal) or in a database tool? If not in Python, can you test without using pydal and see what the results are? -Jim On Saturday, October 17, 2020 at 2:16:58 AM UTC-5, T.R.Rajkumar wrote: > > 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/0b6278d3-e3a6-438a-8f64-14f5398d63eco%40googlegroups.com.