Re: [web2py] Re: web2py 2.0 DAL no longer usable for mysql stored procedures

Solution found: db._adapter.cursor.callproc(..) res = db._adapter.cursor.nextset() while res != None: print result res = db._adapter.cursor.nextset() In a nutshell you have data waiting to be fetched and DAL skrews it up.. 2015. november 21., szombat 18:32:14 UTC+1 időpontban Dániel Finta

Re: [web2py] Re: web2py 2.0 DAL no longer usable for mysql stored procedures

Hi! Just want to ask how long this still takes to fix? We like to use stored procedures for MySQL queries. After an executesql( "CALL... everything gives this error - even commit() and rollback(). This only happens if the procedure wants to give back a result. I have tried to fetch it manually