--- erikcw <[EMAIL PROTECTED]> 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/ -- http://mail.python.org/mailman/listinfo/python-list