Re: [web2py] Re: Building a query from a form

Thanks. I see this error was caused by my original typo. Johann. -- "Every good gift and every perfect gift is from above, and cometh down from the Father of lights, with whom is no variableness, neither shadow of turning." James 1:17 -- You rec

[web2py] Re: Building a query from a form

grrr query = query&(db.sarua[request.vars.refine.lower()].like('%'+request.vars.value.lower() +'%')) or (equivalent) query = query&(db.sarua[request.vars.refine.lower()].like('%'+request.vars.value +'%')) On Apr 5, 3:24 pm, Johann Spies wrote: >   query = > query&(db.sarua[request.va

Re: [web2py] Re: Building a query from a form

query = query&(db.sarua[request.vars.refine.lower()].like('%'+request.vars.value.lower+ '%')) TypeError: cannot concatenate 'str' and 'builtin_function_or_method' objects :( Regards Johann -- "Every good gift and every perfect gift is from above, and cometh down from the Father

Re: [web2py] Re: Building a query from a form

Thanks. Johann -- "Every good gift and every perfect gift is from above, and cometh down from the Father of lights, with whom is no variableness, neither shadow of turning." James 1:17 -- You received this message because you are subscribed to t

[web2py] Re: Building a query from a form

query = query&(db.sarua[request.vars.refine.lower()].like('%'+request.vars.value.lower + '%')) On Apr 5, 1:34 pm, Johann Spies wrote: > Using this form: > >   veld = ['affiliation', 'country','year','journal','author'] > >    form = SQLFORM.factory( >         Field('k', label='Type in up to 5 key