Why isn't this query working in python?

[Steve Howell]

--- erikcw <erikwickstrom at gmail.com> wrote:
> >
> > > ('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)', (1608L,))
> > > ()
> >
> 
> Here is a copy of the table schema and the first 2
> rows.
> 

Does your table actually contain any rows that meet
the criteria that expire_date is in the future,
completed is 1, product id is between 11 and 21, etc.?

Have you tried debugging the SQL outside of Python?






       
____________________________________________________________________________________Ready for the edge of your seat? 
Check out tonight's top picks on Yahoo! TV. 
http://tv.yahoo.com/