Try use mysqldb too. The default pymysql has some problems. We even have to monkeypatch it for security.
Massimo On Monday, 27 August 2012 14:20:00 UTC-5, Yarin wrote: > > 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) >>> >>> >>> --
