Help: Omitting quotes from SQL Queries.

keithk member21858 at
Wed Jan 8 16:21:39 CET 2003

That worked a treat Daniel, thanks a million, I thought it was a dead
I had to tweak it a slight bit, the variable had to be in a tuple inside
of the list ie.

for fileName in fileNameList:
cursor.execute("""SELECT fileSize FROM database where
database.filename = ?""", [(fileName),])
fileSizes = cursor.fetchall()

Thanks again.


Posted via

More information about the Python-list mailing list