Why isn't this query working in python?

Carsten Haese carsten at uniqsys.com
Sun May 27 20:35:28 EDT 2007


On Sun, 2007-05-27 at 16:39 -0400, davelist at mac.com wrote:
> >              sql = """SELECT payment_id FROM amember_payments WHERE
> > member_id=%s AND expire_date > NOW() AND completed=1 AND (product_id
> >>> 11 AND product_id <21)""", (self.uid)
> >
> 
> 
> And doesn't the above comma, need to be a percent symbol?

No. The poster is using parameter passing, not string formatting.

-- 
Carsten Haese
http://informixdb.sourceforge.net





More information about the Python-list mailing list