Re: Problems using custom sql in manager

2008-07-09 Thread AJ
Thanks for your assistance, I got it working properly now. On Jul 8, 9:55 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > 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

Re: Problems using custom sql in manager

2008-07-08 Thread Malcolm Tredinnick
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

Re: Problems using custom sql in manager

2008-07-08 Thread AJ
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

Re: Problems using custom sql in manager

2008-07-08 Thread Malcolm Tredinnick
On Tue, 2008-07-08 at 16:56 -0700, AJ wrote: > I've run into an issue using a manager for a model to run some custom > sql. > A dumbed down version of the code looks something like this: > > cursor = connection.cursor() > #

Problems using custom sql in manager

2008-07-08 Thread AJ
I've run into an issue using a manager for a model to run some custom sql. A dumbed down version of the code looks something like this: cursor = connection.cursor() # Get list of zipcodes zips = [zip.zipcode for zip in