I have exactly the same issue. Call a procedure once and works. Call another procedure again, returns None and from this point on, simple db(..).select() are broken.
Its definetly a DAL issue since using mysql connector does works well. This is an example: Download mysql connectors <http://dev.mysql.com/downloads/connector/python/> for python import mysql.connector as mysql cnn = mysql.connect(user="root", password ="root", database="metrily") cur = cnn.cursor() cur.callproc("grp_groups_checkin", ('2013-01-01', '2013-12-31')) for res in cur.stored_results(): rows = res.fetchall() cur.callproc("grp_subgroups_checkin", ('2013-01-01', '2013-12-31')) for res in cur.stored_results(): rows2 = res.fetchall() cur.close() cnn.close() Maybe advancing the cursor or creating a new DAL method for procedures might do the trick. -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
