Re: [web2py] Re: DAL - Selects

2011-10-08 Thread Chris Rowson
Sorry, left some cruff in from before. It should have belongs==(...) it should just be belongs(...) i.e. postcodelist=[] closepostcodes=ukpostcodes.closest_postcodes(session.postcode, str(session.distance)) for p in closepostcodes: postcodelist.append(p[1]) rows = db(db.data

Re: [web2py] Re: DAL - Selects

2011-10-08 Thread Chris Rowson
I finally used... postcodelist=[] closepostcodes=ukpostcodes.closest_postcodes(session.postcode, str(session.distance)) for p in closepostcodes: postcodelist.append(p[1]) rows = db(db.data.postcode.belongs==(p for p in postcodelist)).select(db.data.download, db.data.postcod

Re: [web2py] Re: DAL - Selects

2011-10-01 Thread Chris Rowson
Thanks Peter, I'll give that a try. Chris On Sep 30, 2011 8:01 PM, "Peter Etchells" wrote: > results=db(db.data.belongs([p[1] for p in postcodes).select()

[web2py] Re: DAL - Selects

2011-09-30 Thread Peter Etchells
results=db(db.data.belongs([p[1] for p in postcodes).select()