Sorry for the mess, but now i have another problem ;-)
s = select(columns=' * ', from_obj=' pessoa ', limit=1)
or
s = select(columns=' * ', from_obj=' pessoa ').limit(1)
results in
SELECT , *
FROM pessoa
LIMIT 1
but limit 1 is not valid in oracle... is it a sqlalchemy error? Or it
shouldnt be possible to limit queries that way?
Thnx!
On Tue, May 5, 2009 at 3:20 PM, Tiago Becker <tiagobec...@gmail.com> wrote:
> Damn, my mistake, sorry, didn't see the [ ] :-)
>
>
> On Tue, May 5, 2009 at 3:15 PM, Tiago Becker <tiagobec...@gmail.com>wrote:
>
>> Thnx for the quick reply! :-)
>>
>> I dont think i got it..
>>
>> the output of:
>>
>> s = select('select * from table ').offset(1).limit(1)
>>
>> is...
>>
>> SELECT s, e, l, c, t, , *, f, r, o, m, a, b
>>
>> LIMIT 1 OFFSET 1
>>
>> ...
>>
>> Can you please explain what am i doing wrong?
>>
>> Thnx a lot!
>>
>>
>> On Tue, May 5, 2009 at 2:55 PM, Michael Bayer
>> <mike...@zzzcomputing.com>wrote:
>>
>>>
>>> see
>>>
>>> http://www.sqlalchemy.org/docs/05/sqlexpression.html#ordering-grouping-limiting-offset-ing
>>> .
>>>
>>>
>>> Tiago Becker wrote:
>>> > Hello.
>>> >
>>> > I'm trying to write some kind of framework web, but i would like to
>>> use
>>> > sqlalchemy, but i need to make a paged result, and every DB has a way
>>> to
>>> > limit the query...
>>> > Is there a way to do this in alchemy? Note: it's a query defined in
>>> xml,
>>> > so
>>> > i use pure sql (this part will just use the alchemy connection).
>>> >
>>> > Thanks in advance!
>>> >
>>> > >
>>> >
>>>
>>>
>>> >>>
>>>
>>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
