[sqlalchemy] Re: Bug in select/offset limit

2007-04-20 Thread sdobrev
On Friday 20 April 2007 16:59:55 Michael Bayer wrote: On Apr 20, 2007, at 5:00 AM, Ram Yalamanchili wrote: I have this piece of code which I came across accidentally: page = 0 limit = '1' # note that one of the above values is a string, and the other a 0 data =

[sqlalchemy] Re: Bug in select/offset limit

2007-04-20 Thread Michael Bayer
On Apr 20, 2007, at 5:00 AM, Ram Yalamanchili wrote: I have this piece of code which I came across accidentally: page = 0 limit = '1' # note that one of the above values is a string, and the other a 0 data = ATable.select(a_table.c.id.in_(*aIDs), limit=limit, offset= (page*limit))

[sqlalchemy] Re: Bug in select/offset limit

2007-04-20 Thread Ram Yalamanchili
On 4/20/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: On Friday 20 April 2007 16:59:55 Michael Bayer wrote: On Apr 20, 2007, at 5:00 AM, Ram Yalamanchili wrote: I have this piece of code which I came across accidentally: page = 0 limit = '1' # note that one of the above

[sqlalchemy] Re: Bug in select/offset limit

2007-04-20 Thread Michael Bayer
On Apr 20, 2007, at 5:21 PM, Ram Yalamanchili wrote: Passing a string in limit or offset does work (atoi done internally i think). Thats the reason I thought offset='' doesn't make sense. Shouldn't there atleast be a better error than trying to figure what is wrong with the sql statement?