erikcw wrote: > On May 28, 2:47 pm, "Gabriel Genellina" <[EMAIL PROTECTED]> > wrote: >> En Mon, 28 May 2007 14:53:57 -0300, Dennis Lee Bieber >> <[EMAIL PROTECTED]> escribió: >> >>> On Sun, 27 May 2007 20:35:28 -0400, Carsten Haese <[EMAIL PROTECTED]> >>> declaimed the following in comp.lang.python: >>>> On Sun, 2007-05-27 at 16:39 -0400, [EMAIL PROTECTED] 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) >>> It's confusing, as the example shown is not the common form for >>> parameter passing on the .execute() call -- without the .execute() it is >>> unclear. I presume the .execute() is using *sql to unpack the tuple... >> Yes, the original message said self.amember_cursor.execute(*sql) >> It IS confusing... >> >> -- >> Gabriel Genellina > > This is how I've always writing my queries. I learned it from some > tutorial I found on Google when I started - what is the preferred/ > pythonic way to write this query? > Use separate names for the SQL statement and the argument tuple, then pass them as two separate arguments to cursor.execute().
Apart from anything else this makes it somewhat easier to use the same statement with different arguments. But it is no different in principle than what you are doing now, so the change won't remove your bug, I'm afraid. Could you show us a query (with actual results, if you can publish them) that works manually but doesn't work in Python? There has to be something pretty simple wrong here. 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