On Sun, Aug 29, 2010 at 11:29 PM, Julia Jacobson
<julia.jacob...@arcor.de> wrote:
> Dear python users,
>
> For passing a variable to a SQL query for psycopg2, I use:
>
> >>> my_var = xyz
> >>> print cur.mogrify("SELECT my_values FROM my_table WHERE my_column =
> %s",(my_var,))
>
> This returns:
>
> >>> SELECT my_values FROM my_table WHERE my_column = E'xyz'
>
> Where does the "E" in front of 'xyz' come from?
> It's probably the reason, why my query doesn't work.
Quite doubtful, considering the example in the psycopg2 docs also has the E:
http://initd.org/psycopg/docs/cursor.html#cursor.mogrify
Cheers,
Chris
--
http://blog.rebertia.com
--
http://mail.python.org/mailman/listinfo/python-list
