Are you thinking about this post?: http://groups.google.com/group/web2py/browse_frm/thread/4aaa3846a2e5e68a/
Does GAE support 'substring'? A bug in Field.__getslice__ was recently fixed so you may want to try the latest from mercurial. I think you want: query = db(db.table.string_field[-4:] == ".com") On Mar 19, 5:06 pm, howesc <how...@umich.edu> wrote: > Thadeus, > > i'm not mixing frameworks right now - web2py has been my exclusive > home for over a year now. :) It also looks like there is some sort of > substring tools with some (all?) of the relational > db'shttp://groups.google.com/group/web2py/browse_thread/thread/eb8ce28b34... > but i'm not using one of them today to test it out. it's not in GAE. > > thanks for the tips guys! i'm just going to bite the bullet and make > the database upgrade that is the correct answer anyway. fun with > updating code and testing! > > cfh > > On Mar 19, 1:33 pm, Thadeus Burgess <thade...@thadeusb.com> 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 > > > On Fri, Mar 19, 2010 at 2:49 PM, howesc <how...@umich.edu> wrote: > > > 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 it > > > but got an error: > > > > File "/home/cfhowes/clients/rockriver/source/web2py/gluon/sql.py", > > > line 2703, in __getslice__ > > > s = self._db._translator['substring'] % d > > > KeyError: 'substring' > > > > Thanks, > > > > Christian > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "web2py-users" group. > > > To post to this group, send email to web...@googlegroups.com. > > > To unsubscribe from this group, send email to > > > web2py+unsubscr...@googlegroups.com. > > > For more options, visit this group > > > athttp://groups.google.com/group/web2py?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
