Hey all,
I was trying to use executesql with placeholders, based on the
documentation in source and the mailing list [1]. The syntax on the
site seems to suggest using question marks, for example:
db.executesql("select * from auth_user where id = ?", [4])
I was banging my head against this for a while until I realized that
the syntax that works is actually:
db.executesql("select * from auth_user where id = %s", [4])
(not sure if this is in postgres or everywhere in general.) Is this
correct, and if so can it be added to the documentation?
Thanks!
[1]
http://groups.google.com/group/web2py/browse_thread/thread/dd01da67ca713421/baf2e0b206892be1?lnk=gst&q=postgresql+placeholders#baf2e0b206892be1
