Help: Omitting quotes from SQL Queries.
member21858 at dbforums.com
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()
Posted via http://dbforums.com
More information about the Python-list