Re: select statement for python-mysql

This question should be directed to the db-sig, not to the meta sig.

	[email protected]


On Monday 07 October 2002 05:41 am, roslyn jose wrote:
> hi,
>
> im facing a problem with the syntax in python-mysql. this is my code:
>
> 

The syntax for the string substitution needs to have a '%' instead of a ','

c.execute("""select vid from verses where
book,chapter,number=%s,%s,%s""" %(bk,chap,i))


>
> and i get the error as :"u have an error in your SQL syntax near
> chapter,number=1,21)
>
> someone pls help me here. thanks alot
>
> regards,
>
> roslyn
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Faith Hill - Exclusive Performances, Videos, & more
> faith.yahoo.com


_______________________________________________
Meta-sig maillist  -  [email protected]
http://mail.python.org/mailman/listinfo/meta-sig