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's http://groups.google.com/group/web2py/browse_thread/thread/eb8ce28b34fd0aa0/48bf0788ba899158?lnk=gst&q=substring#48bf0788ba899158 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.