CODEWITHSUNDEEP
python-3.xsqlite
ios_mxe
ios_mxe

Reputation: 115

Not able to parameterize LIMIT and OFFSET in sqlite3

Why following code is giving syntax error "sqlite3.OperationalError: near "?": syntax error"

import sqlite3

connection = sqlite3.connect('data.db')

cursor = connection.cursor()

table = "device_store"
uuid = "bbebe39e-fe2e-4817-b022-a3ef13bd6283"
page = 1
POSTS_PER_PAGE = 10
query = "SELECT * FROM ? WHERE uuid=? LIMIT ? OFFSET ?"
result = cursor.execute(query, (table, uuid, POSTS_PER_PAGE, 0))
rows = result.fetchall()
connection.close()
print("==>> Printing rows <<==")
print(rows)

Upvotes: 0

Views: 906

Answers (1)

Shawn
Shawn

Reputation: 52354

The error is caused by the placeholder in FROM ?, not the others. Table names can't be passed as parameters, they have to be hardcoded in the statement.

Upvotes: 2

Related Questions