Help: Omitting quotes from SQL Queries.

[keithk]

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