Why isn't this query working in python?

erikcw erikwickstrom at gmail.com
Fri May 25 11:02:49 EDT 2007


On May 25, 10:51 am, "Dave Borne" <dbo... at gmail.com> wrote:
> > I'm trying to run the following query:
> ...
> > member_id=%s AND expire_date > NOW() AND completed=1 AND (product_id
>
> Shouldn't you be using the bind variable '?' instead of '%s' ?
> (I'm asking because I'm not entirely sure how the execute command is
> doing the substitution)
>
> -Dave

Hi Dave,

I'm not sure.  I've been using this format for all of my other queries
without issue.  What would the query look like with the bind variable
instead?

Erik




More information about the Python-list mailing list