What I man you need to be able to build a string (or object) that represents the query and store this object in the query. Then retrieve the object and rebuild the query.
On Wednesday, 17 July 2013 07:15:32 UTC-5, Sarbjit singh wrote: > > I am not aware of the word "serialize", Is there any possibility to > achieve it? > > > > On Wednesday, July 17, 2013 5:36:33 PM UTC+5:30, Massimo Di Pierro wrote: >> >> A query object cannot be put into a session unless you somehow serialize >> (but not with automated pickle/marshall/etc). >> >> On Wednesday, 17 July 2013 05:37:24 UTC-5, Sarbjit singh wrote: >>> >>> Hi, >>> >>> I am trying to use "dynamic search form" from >>> http://www.web2pyslices.com/slice/show/1403/dynamic-search. Current >>> implementation shows both the form and results on the same page. >>> >>> I want to display the search results (using GRID) in a new page and >>> wants to use customized forms for edit/view operations associated with GRID. >>> >>> As of now, I tried handling it in the view to not to show form contents >>> once the form is accessed but some how it is not working on subsequent >>> operations. >>> >>> So, I am thinking to pass query to a new controller and can hence handle >>> the custom forms there. But I am not able to do so. >>> >>> So here is what I tried : >>> >>> @auth.requires_login() >>> def search2(): >>> form,query = dynamic_search(db.customer) >>> if form.process().accepted: >>> session.sqlquery = query >>> redirect(URL('results')) >>> return dict(form=form) >>> >>> @auth.requires_login() >>> def results(): >>> query = session.sqlquery >>> print query >>> results = >>> SQLFORM.grid(query,searchable=False,create=False,csv=False) >>> results = None >>> return dict(results=results) >>> >>> With this code, first error that is encountered is in "session.sqlquery >>> = query" -> Can't pickle objects .... >>> >>> So I modified it as >>> >>> session.sqlquery = str(query) >>> >>> With this error appeared in "query = session.sqlquery" -> str object has >>> no attribute _db >>> >>> Can some one please suggest what is the right way to achieve this? >>> >>> -Sarbjit >>> >>> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
