good afternoon, I explain how to solve the problem in question, so that the method ".executesql" the DAL object fails with the message "'NoneType' object is not iterable" the problem is that when you run a stored procedure, the method attempts to obtain the return of the execution of the sentence sent to the database, then it is as simple as: A- if you want to return a set of rows to Deberas controller indicate that the return control it as an option "as_dict = True" dictionary, after that make sure that what you return to controlled from the execution is to iterate (cols/rows), bone containing rows and columns and use it to something that outcome. B- if your store procedure executes X DML statements, including update, insert, delete program and try them, takes control of execution in the stored procedure or function and do not send data to the controller, do the procedure marrow own your environment, if return data you require to control "ZZZ" reasons, then make a new call to the stored procedure or SELECT statement and controls conceptually the same as I explain in the clarification "A".
not mix execute a procedure to send data from a procedure. Then as conceptual recipe execution in the implementation of store procedures. 1- declare the file db.py the DAL object. 2- create layers / objects equiera your app, create a function that preferably standard form Therefore, allowing you to use the ".executesql" sentence and will complete missing only in the controller layer to call your new method parameters of the string SQL. 3- call your new function. 4- do not forget the bug tracking / exceptions 5- always test controllers individually, then proceeds to its implementation (using shell). 6- never stop trying and start with the basics and progressing to complex layered, solve it took me more than two weeks of trial and error and follow clues in the programs. -- 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. For more options, visit https://groups.google.com/d/optout.
