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 at 
> http://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.

Reply via email to