[sqlalchemy] Re: BETWEEN in where clause?

2007-06-29 Thread voltron
aha, this works resultset = select([links] , links.c.lft.between(5,17), order_by=links.c.lft).execute() On Jun 29, 12:00 am, voltron <[EMAIL PROTECTED]> wrote: > Thanks for your reply,now I dont have errors, but the results are > unexpected, I have a list of booleans if I iterate through the res

[sqlalchemy] Re: BETWEEN in where clause?

2007-06-29 Thread svilen
the between should be in the where clause, NOT the columns that u fetch. Read about select() and how to specify columns and how to specify where's.. > Thanks for your reply,now I dont have errors, but the results are > unexpected, I have a list of booleans if I iterate through the > result ins

[sqlalchemy] Re: BETWEEN in where clause?

2007-06-28 Thread voltron
Thanks for your reply,now I dont have errors, but the results are unexpected, I have a list of booleans if I iterate through the result instead of the values: [(False,), (False,), (False,), (False,), (False,), (True,), (True,), (True,), (True,)] Could you tell me what I´ve done wrong? On Ju

[sqlalchemy] Re: BETWEEN in where clause?

2007-06-28 Thread sdobrev
between is a method of 2 args, min and max: table.c.between(x,y), in your case: select( links.c.lft.between(3,10) ) On Thursday 28 June 2007 23:55:26 voltron wrote: > This does not work either :-( > > resultset = select([links.c.lft.between(links.c.lft >3,links.c.lft > < 10) ]).execute() --~--~-

[sqlalchemy] Re: BETWEEN in where clause?

2007-06-28 Thread voltron
This does not work either :-( resultset = select([links.c.lft.between(links.c.lft >3,links.c.lft < 10) ]).execute() --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send em