Re: [web2py] substring comparison in GAE query

2010-03-19 Thread Wes James
yeh, I guess you can make some work arounds :) On Fri, Mar 19, 2010 at 2:59 PM, Thadeus Burgess wrote: > You *can*, but not natively. > > http://web2py.com/AlterEgo/default/show/248 > > rows = db(buyer.id>0).select().find(lambda row:row.name.startswith('C')) > > -Thadeus > > > > > > On Fri, Mar 1

Re: [web2py] substring comparison in GAE query

2010-03-19 Thread Thadeus Burgess
You *can*, but not natively. http://web2py.com/AlterEgo/default/show/248 rows = db(buyer.id>0).select().find(lambda row:row.name.startswith('C')) -Thadeus On Fri, Mar 19, 2010 at 3:53 PM, Wes James wrote: > You can't use "like" on gae. > > On Fri, Mar 19, 2010 at 2:33 PM, Thadeus Burgess

Re: [web2py] substring comparison in GAE query

2010-03-19 Thread Wes James
You can't use "like" on gae. On Fri, Mar 19, 2010 at 2:33 PM, Thadeus Burgess wrote: > You must be thinking of another framework and mixing the two? > > I read every post and have not seen that. > > Perhaps you mean db(db.table.string.like("%.com")).select() > > -Thadeus > > -- You received thi

Re: [web2py] substring comparison in GAE query

2010-03-19 Thread Thadeus Burgess
You must be thinking of another framework and mixing the two? I read every post and have not seen that. Perhaps you mean db(db.table.string.like("%.com")).select() -Thadeus On Fri, Mar 19, 2010 at 2:49 PM, howesc wrote: > Hello, > > I swear i saw a post in the last week about creating data

[web2py] substring comparison in GAE query

2010-03-19 Thread howesc
Hello, I swear i saw a post in the last week about creating database queries with substring syntax for filtering like: query = db(db.table.string_field[:4] == ".com") but i can't find the post about that. am i dreaming? and does something like this work on the Google App Engine? I was trying