SQL SELECT question...
dima at xenon.spb.ru
Sat May 20 00:23:58 CEST 2000
I think your problem is that in SQL string literals are like 'string'
not "string", and 'str%' instead "str*" for LIKE. At least I had such a
problem at first.
"SELECT sf FROM st WHERE sf='ss'"
"SELECT sf FROM st WHERE sf='%s'" % "ss"
Hope this helps.
Rob Elder wrote:
> Hello, guys
> I'm struggling with using SQL with Python. One question please. How
> should I structure the following operation using odbc:
> cursor.execute('SELECT someField FROM someTable WHERE someField="someString"')
> This does not work for me. How is this supposed to be structured?
More information about the Python-list