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