Re: [SQLObject] AND syntax

[Ivo v. d. W. <vla...@gm...>]

On Sat, 3 Jul 2004 18:24:37 +1000, Gavin <bra...@ri...> wrote:
> How do you use AND and other such logical statements in query ie .select()
> ?

Check the SQLBuilder documentation. Basically, you'll get constructs such as:

Person.select(AND(Person.q.name=='foo', Person.q.companyID==Company.id))

  Ivo

-- 
Drs. I.R. van der Wijk                                      -=-
Korte Leidsedwarsstraat 12                                 Amaze
1017 RC Amsterdam, NL                                       -=-
T +31-20-4688336         F +31-20-4688337       Zope/Plone/Content Management
W http://www.amaze.nl    E in...@am...           Open Source Solutions
W http://vanderwijk.info E iv...@am...                 Consultancy
PGP http://vanderwijk.info/pgp