SQLite OperationalError near "?"

H

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
 
J

John Machin

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top