SQLite OperationalError near "?"

2008-04-12 Thread Hexade 
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 ?

Thanks in advance,

Hexade
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: SQLite OperationalError near "?"

2008-04-13 Thread Hexade 
On 13 avr, 03:00, John Machin <[EMAIL PROTECTED]> wrote:
> On Apr 13, 8:45 am, Hexade <[EMAIL PROTECTED]> 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#
-- 
http://mail.python.org/mailman/listinfo/python-list