SQL SELECT question...

Dmitry Rozmanov 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. 

So try: 
	"SELECT sf FROM st WHERE sf='ss'"
or
	"SELECT sf FROM st WHERE sf='%s'" % "ss"

Hope this helps.

	---Dmitry.

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?
> 
> TIA.
> 
> -r



More information about the Python-list mailing list