Help: Omitting quotes from SQL Queries.

keithk 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
end.
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.

Keith

--
Posted via http://dbforums.com




More information about the Python-list mailing list