Help: Omitting quotes from SQL Queries.
member21858 at dbforums.com
Tue Jan 7 15:45:14 CET 2003
I am using an mx.ODBC connection to MSSQL and am iterating through a
list to get data from the DB, for eg:
for fileName in fileNameList:
cursor.execute("SELECT fileSize FROM database where
database.filename = '%s'" % fileName)
fileSizes = cursor.fetchall()
However, when it iterates through the list and fileName equals something
like "Hello World's" with a single quote inside the query fails as the
string is ended prematurely, does anybody know how I can solve this?
Thanks in advance,
Posted via http://dbforums.com
More information about the Python-list