Can you try
from gluon.sql import Query
print db(Query(" '%' || NEW.field_1 || '%' LIKE table_1.field_1
"))._select(db.table_1.field_1)
Do you get the query you want?
On May 7, 10:48 am, AsmanCom <d.as...@web.de> wrote:
> It returns nothing... even if I write in the exact value and it should
> work like a fuzzy logic..
> like that:
>
> find_value= request.vars.value
>
> db('%' + table_1.field_1 +
> '%').lower().like(find_value).select(db.table_1.field_1)
>
> or
>
> db('%' + table_1.field_1 + '%').lower().like('%' + find_value +
> '%').select(db.table_1.field_1)
>
> Any Idea?
>
> On 7 Mai, 17:03, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > This should work
>
> > db("'%' || NEW.field_1 || '%' LIKE
> > table_1.field_1").select(db.table_1.field_1)
>
> > On May 7, 9:35 am, AsmanCom <d.as...@web.de> wrote:
>
> > > Hi,
>
> > > here is the important Code from an Sqlite trigger i use very often, is
> > > this possible with web2py to?
>
> > > Sqlite:
> > > (SELECT table_1.field_1 FROM table_1 WHERE '%' || NEW.field_1 || '%'
> > > LIKE table_1.field_1 )
>
> > > or i can even do:
>
> > > (SELECT table_1.field_1 FROM table_1 WHERE '%' || NEW.field_1 || '%'
> > > LIKE '%' || table_1.field_1 || '%' )
>
> > > w2p:
> > > db.person.name.lower().like(‘m%’)
