SQLite OperationalError near "?"

John Machin sjmachin at lexicon.net
Sat Apr 12 21:00:18 EDT 2008


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.



More information about the Python-list mailing list