SQLite OperationalError near "?"

Hexade hexade at gmail.com
Sun Apr 13 06:13:09 EDT 2008


On 13 avr, 03:00, John Machin <sjmac... at lexicon.net> wrote:
> On Apr 13, 8:45 am, Hexade <hex... at gmail.com> wrote:
>
> > Hello
>
> > I would like to use the safe "?" placeholder in my SQLite requests but
> > I got the following error:
>
> > Traceback (most recent call last):
> >   (...)
> >   cursor.execute("SELECT ? FROM ? WHERE name = ? ", (key, self.table,
> > self.name))
> > OperationalError: near "?": syntax error
>
> > key, self.table and self.name are standart strings.
>
> > Any idea about how to solve this problem ?
>
> You may like to read the answer to the question on sqlite3 that was
> posted 45 minutes before yours.

Thank you.

I guess you are speaking about
http://groups.google.com/group/comp.lang.python/browse_thread/thread/50a8ad977ed31e2a#



More information about the Python-list mailing list