Help: Omitting quotes from SQL Queries.
Daniel Dittmar
daniel at dittmar.net
Wed Jan 8 07:28:07 EST 2003
keithk wrote:
> Daniel,
>
> Could you give me a little more detail about the
>
> execute ("SELECT ...",[fileName]) appraoch as I am not familiar with
> the syntax.
for fileName in fileNameList:
cursor.execute("""SELECT fileSize FROM database where
database.filename = ?""", [fileName])
fileSizes = cursor.fetchall()
The driver is responsible for replacing the ? with the actual value.
Python drivers differ in the kind of placeholders they accept, but
mxODBC should work fine with the question mark.
Daniel
More information about the Python-list
mailing list