Python2.7 - SQLite3 library outputs error message "sqlite3.OperationalError: near "?": syntax error"

Question

Code is follow. How to get replaced ? by value of variables [table, url]?

Expected SQL command is select * from OTHER_URL where url="http://a.com/a.jpg"

This SQL command occurs no error on the sqlite3 command line interface.

import sqlite3
from contextlib import closing

dbname = "ng.db"

with closing(sqlite3.connect(dbname)) as conn:
    c = conn.cursor()
    c.execute("CREATE TABLE IF NOT EXISTS OTHER_URL (url TEXT)")
    conn.commit()

table = "OTHER_URL"
url = "http://a.com/a.jpg"

with closing(sqlite3.connect(dbname)) as conn:
    c = conn.cursor()
    c.execute('select * from ? where url="?"', [table, url])
    print c.fetchone()

Daniel Roseman · Accepted Answer · 2018-03-30 09:51:35Z

2

There are two errors here. Firstly, you can't use parameter substitution for table names (or column names), only for values. You need to use string interpolation for anything else.

Secondly, you don't need quotes around the value parameter; the substitution will take care of that.

So:

c.execute('select * from {} where url=?'.format(table), [url])

answered Mar 30, 2018 at 9:51

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python2.7 - SQLite3 library outputs error message "sqlite3.OperationalError: near "?": syntax error"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related