1 Answer
1

You cannot execute multiple statements in one executesql call I suspect; web2py uses the DBAPI 2.0.execute() call for sending these to the backend database and that usually supports only single statements:

thanks, but I just tried this with the same result- still returning None.
–
YarinAug 25 '12 at 16:28

I must say that I am very wary of web2py; for one, it'll do a fetchall() regardless of result set size. This will easily cause memory problems if your result set is large enough.
–
Martijn PietersAug 25 '12 at 16:34

Thanks for the update- the mulitiple execution may have been the problem, so I solved that by rolling it into a stored procedure.
–
YarinAug 25 '12 at 17:16

btw- as for being wary of web2py, not sure why- It's a great framework with a robust DAL. Your point about the fetchall() isn't something I know about, but seems a child-safety detail rather than something to dismiss a framework over.
–
YarinAug 25 '12 at 17:20

1

Yes, but you don't have to attach all the wheels on your own or get them each serviced at a different service station. And some of them run faster and handle better than existing wheels. :-)
–
AnthonyAug 25 '12 at 23:08