Why isn't this query working in python?

[Steve Holden]

Steve Howell wrote:
> --- 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?
> 
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 ----------------