christhedonstar
Programmer
sqlToRun = '''SELECT TOP 1 * FROM ADDRESS WHERE ad_city = @city '''
curs.execute(sqlToRun, {'@city': 'NEW YORK' })
#sqlToRun = '''SELECT TOP 1 * FROM ADDRESS WHERE ad_city = 'NEW YORK' '''
#curs.execute(sqlToRun)
inlineSqlResults = curs.fetchall()
print inlineSqlResults
Any idea why the commented stuff returns a result but the uncommented does not?
Thanks in advance,
Chris
curs.execute(sqlToRun, {'@city': 'NEW YORK' })
#sqlToRun = '''SELECT TOP 1 * FROM ADDRESS WHERE ad_city = 'NEW YORK' '''
#curs.execute(sqlToRun)
inlineSqlResults = curs.fetchall()
print inlineSqlResults
Any idea why the commented stuff returns a result but the uncommented does not?
Thanks in advance,
Chris