Re: [web2py] how to passing query or db set through url securily

doh! Can we do this kind of query with SQLFORM.grid search tool : q = ((db.table.field == 'something' | db.table.field != None) & db.table.other_field == something) ?? Richard On Tue, Apr 28, 2015 at 2:58 PM, Richard Vézina wrote: > I maybe better constructing my db() set like so instead of

Re: [web2py] how to passing query or db set through url securily

I maybe better constructing my db() set like so instead of deconstruct it to get the query component : from gluon.dal import smart_query keywords = \ 'table1.f1 = True and ' \ 'table1.f2 != {0}'.format( db(db.ref_table.f1 =='Annulé - Void' ).select(db.ref_table.id).firs

Re: [web2py] how to passing query or db set through url securily

How to extract the operator of the query in familiar "==" or "=" db_set.query.second.op return adapter bound operator... Richard On Tue, Apr 28, 2015 at 12:15 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > I guess the best option would be to do the same as SQLFORM.grid search?? > >

Re: [web2py] how to passing query or db set through url securily

I guess the best option would be to do the same as SQLFORM.grid search?? On Tue, Apr 28, 2015 at 12:10 PM, Richard wrote: > Hello, > > I need to pass a db_set to a widget that is used into an IS_IN_DB() > validator. This as to be done in order to the widget which is a custom > autocomplet widget

[web2py] how to passing query or db set through url securily

Hello, I need to pass a db_set to a widget that is used into an IS_IN_DB() validator. This as to be done in order to the widget which is a custom autocomplet widget using bootstrap typeahead can make the correct query with ajax call to a returning json function which feed the widget with resul