the format of the parameters youre sending to execute() is wrong, it
should be:
ret = r.execute(user_name = 'S%')
On Apr 7, 2006, at 8:49 AM, Sandro Dentella wrote:
hi all,
bind parameters with text() seem to work in postgresql but not in
sqlite,
is that normal/documented?
r = text("SELECT * FROM users WHERE user_name LIKE :user_name ",
engine=eng)
ret = r.execute({'user_name' : 'S%'})
TIA
sandro
*:-)
--
Sandro Dentella *:-)
e-mail: [EMAIL PROTECTED]
http://www.tksql.org TkSQL Home page - My GPL work
<sqlite.py>
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
