SQLite OperationalError near "?"

[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))
OperationalErro r: near "?": syntax error

key, self.table and self.name are standart strings.

Any idea about how to solve this problem ?

Thanks in advance,

Hexade

[John Machin]

Re: SQLite OperationalErro r near "?&quot ;

On Apr 13, 8:45 am, Hexade <hex...@gmail.c omwrote:

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))
OperationalErro r: 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.

[Hexade]

Re: SQLite OperationalErro r near &quot;?&quot ;

On 13 avr, 03:00, John Machin <sjmac...@lexic on.netwrote:

On Apr 13, 8:45 am, Hexade <hex...@gmail.c omwrote:
>

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))
OperationalErro r: 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#