Re: [web2py] Posgresql-query -> DAL

2010-12-14 Thread Johann Spies
On 14 December 2010 23:02, Thadeus Burgess wrote: > db(db.gr02.service_provider.belongs([7,10])).select() > > Thanks. Johann -- May grace and peace be yours in abundance through the full knowledge of God and of Jesus our Lord! His divine power has given us everything we need for life and godl

Re: [web2py] Posgresql-query -> DAL

2010-12-14 Thread Thadeus Burgess
db(db.gr02.service_provider.belongs([7,10])).select() -- Thadeus On Tue, Dec 14, 2010 at 2:38 PM, Johann Spies wrote: > The postgresql equivalent is: select * from gr02 where service_provider in > (7, 10) > > I have tried: > > >>> isps = (7,10) > >>> tb = 'gr02' > >>> data = db('%s.service_p

[web2py] Posgresql-query -> DAL

2010-12-14 Thread Johann Spies
The postgresql equivalent is: select * from gr02 where service_provider in (7, 10) I have tried: >>> isps = (7,10) >>> tb = 'gr02' >>> data = db('%s.service_provider in (%s)' % (tb,isps)).select() Traceback (most recent call last): File "", line 1, in File "/Users/js/Programmeer/zenex/web2p