[sqlalchemy] Re: select

2009-05-20 Thread Tiago Becker
) WHERE ora_rn1 AND ora_rn=30 sorry about the mess, On Tue, May 19, 2009 at 2:21 PM, Michael Bayer mike...@zzzcomputing.comwrote: send along full reproducing test cases and that will reveal all. On May 19, 2009, at 11:36 AM, Tiago Becker wrote: this indicates a None is being sent

[sqlalchemy] select

2009-05-19 Thread Tiago Becker
Hi. Im still trying to use the select object from sqlalchemy, but i found a strange (bug or not) behavior: sql = select(columns=[self.fields], from_obj=self.tables, whereclause=self.where, bind=self.req.cfg.engine, order_by= ' 1 ') 1) without order by, i get an error: AttributeError:

[sqlalchemy] Re: select

2009-05-19 Thread Tiago Becker
the fields in the outer join by adding *, as it will select all the fields in the query... How do i solve this? On Tue, May 19, 2009 at 12:13 PM, Michael Bayer mike...@zzzcomputing.comwrote: On May 19, 2009, at 10:39 AM, Tiago Becker wrote: Hi. Im still trying to use the select object from

[sqlalchemy] limit

2009-05-05 Thread Tiago Becker
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

[sqlalchemy] Re: limit

2009-05-05 Thread Tiago Becker
, Michael Bayer mike...@zzzcomputing.comwrote: 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

[sqlalchemy] Re: limit

2009-05-05 Thread Tiago Becker
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

[sqlalchemy] Re: limit

2009-05-05 Thread Tiago Becker
? 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.comwrote: Thnx for the quick reply! :-) I dont think i

[sqlalchemy] Mod_python problem

2008-10-16 Thread Tiago Becker
= apache.import_module('sqlalchemy.orm') orm = apache.import_module('sqlalchemy.orm.session') Can someone please help me? Thanks a lot in advance! Tiago Becker --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group