This is MySQL using the default driver, whatever that is. I'm going to test on other drivers/dbs and will report back..
On Monday, August 27, 2012 3:03:15 PM UTC-4, Massimo Di Pierro wrote: > > I do not think this is a DAL issue. This looks database issue or a driver > issue. Web2py does not do another else but pass your SQL to the driver and > fetch responses. > > Is this SQLITE? In any case, I suggest you try the native driver APIs. > > On Monday, 27 August 2012 09:37:45 UTC-5, Yarin wrote: >> >> Once we call a stored procedure through the DAL, any subsequent DAL calls >> are returning None results. >> >> *Basic stored procedure:* >> BEGIN >> SELECT * FROM people; >> END >> >> *Works:* >> def test(): >> >> sql = "CALL GetPeople();" >> sproc_results = db_test.executesql(sql) >> >> return str(sproc_results) >> >> *Works:* >> def test(): >> >> sql = "SELECT * FROM people;" >> reg_results = db_test.executesql(sql) >> >> return str(reg_results) >> >> *Returns None:* >> def test(): >> >> sql = "CALL GetPeople();" >> sproc_results = db_test.executesql(sql) >> >> sql = "SELECT * FROM people;" >> reg_results = db_test.executesql(sql) >> >> return str(reg_results) >> >> *Returns None:* >> def test(): >> >> sql = "CALL GetPeople();" >> sproc_results = db_test.executesql(sql) >> >> sql = "CALL GetPeople();" >> sproc_results = db_test.executesql(sql) >> >> return str(sproc_results) >> >> >> --
