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 instead of the values: > > [(False,), (False,), (False,), (False,), (False,), (True,), > (True,), (True,), (True,)] > > Could you tell me what I´ve done wrong? > > On Jun 28, 11:41 pm, [EMAIL PROTECTED] wrote: > > 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() > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---