[DB-SIG] Re: [meta-sig] select statement for python-mysql
Mon, 7 Oct 2002 08:45:08 -0700 (PDT)
> > 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))
[redirected to db-sig]
The syntax of that select SQL statement itself looks funny to me; are you
sure you don't mean this instead?
select vid from verses
where book = %s
and chapter = %s
and number = %s