Steve Howell wrote:
> --- 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?
>
This thread all started because a manual query was claimed to succeed
when a Python-based one was claimed not to.
regards
Steve
--
Steve Holden +1 571 484 6266 +1 800 494 3119
Holden Web LLC/Ltd http://www.holdenweb.com
Skype: holdenweb http://del.icio.us/steve.holden
------------------ Asciimercial ---------------------
Get on the web: Blog, lens and tag your way to fame!!
holdenweb.blogspot.com squidoo.com/pythonology
tagged items: del.icio.us/steve.holden/python
All these services currently offer free registration!
-------------- Thank You for Reading ----------------
--
http://mail.python.org/mailman/listinfo/python-list
