On Mon, 2007-05-07 at 07:26 -0700, Daniele Varrazzo wrote:
> > >> >> > cur.execute("INSERT INTO datatable (data) VALUES (%s);",
> > >> >> > (pickled_data,))
>
> > %s is not a placeholder IMHO.
>
> > What happens when using %s is, that the string given will be inserted where
> > %s is; that is something python does as with every print or such.
>
> It is indeed. The behavior you describe would be true if i had used
> the "%" operator. Read better what i have written: There is no "%"
> operator.
This confusion is precisely why I think the (py)format paramstyles
should be deprecated in a future version of the DB-API spec. Question
marks make it immediately obvious that something other than string
formatting is happening, and if I'm not mistaken, question marks are SQL
standard.
--
Carsten Haese
http://informixdb.sourceforge.net
--
http://mail.python.org/mailman/listinfo/python-list
