On Tue, 2008-07-08 at 17:17 -0700, AJ wrote: > Thanks for your quick reply. I have been searching for a long time > for good documentation on using IN and paramaters with no luck. When > it worked with a list I assumed that was correct. Could you clarify > an example of transforming a list of items into something mysqldb > would accept then executing it? I think you are saying that if I have > 2 items in the list I need to manually specify: > > zips = ['77777', '55544'] > sql = """ > SELECT id > FROM Event > WHERE zip_code IN %s, %s""" > cursor.execute(sql, (zips[0], zips[1]))
That's not valid SQL. The "IN" operator requires something in parentheses. Normal SQL rules apply. Yes, it's possibly an error or an oversight that all this isn't handled automatically in some fashion, but it's really hard, since some databases allow array-like operations and there's all sort of edge-cases. I can't blame Python's DB-API for pushings things back to the client code here. Here's how Django constructs the SQL piece for "IN" operators: http://code.djangoproject.com/browser/django/trunk/django/db/models/sql/where.py#L151 (that line number is only valid until the next time that file is changed, but it's the right file, so you can always just search for the word "IN"). Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
