[meta-sig] select statement for python-mysql

[roslyn jose]

--0-642801737-1033983673=:43611
Content-Type: text/plain; charset=us-ascii


hi,

im facing a problem with the syntax in python-mysql. this is my code:

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
--0-642801737-1033983673=:43611
Content-Type: text/html; charset=us-ascii

<P>hi,</P>
<P>im facing a problem with the syntax in python-mysql. this is my code:</P>
<P>c.execute("""select vid from verses where book,chapter,number=%s,%s,%s""",(bk,chap,i))</P>
<P>and i get the error as :"u have an error in your SQL syntax near chapter,number=1,21)</P>
<P>someone pls help me here. thanks alot</P>
<P>regards,</P>
<P>roslyn</P><p><br><hr size=1>Do you Yahoo!?<br>
<a href="http://faith.yahoo.com">Faith Hill</a> - Exclusive Performances, Videos, & more<br>
<a href="http://faith.yahoo.com">faith.yahoo.com</a>
--0-642801737-1033983673=:43611--