Can't do that. As I told you the query has to be executed on the destination.
quinta-feira, 2 de Maio de 2019 às 01:01:01 UTC+1, Dave S escreveu: > > > > On Wednesday, May 1, 2019 at 2:47:53 PM UTC-7, [email protected] wrote: >> >> Yes, I read it.. >> >> If you try to save it on a session var (to pass between requests) it will >> return a pickling error (or not), depending on the query. >> I tried to save this >> db.equipment.sn_counter_id == request.args[0] >> and it returns a pickling error. >> Probably because of request.args[0]. >> >> > Does copying request.args[0] to a local [string] variable help? > > /dps > > >> >> quarta-feira, 1 de Maio de 2019 às 22:43:06 UTC+1, Dave S escreveu: >>> >>> < >>> >>> On Wednesday, May 1, 2019 at 2:22:11 PM UTC-7, [email protected] wrote: >>>> >>>> What do you mean? >>>> >>>> I don't want to serialize the query. >>>> And I want the query to only be executed on the desalination controller. >>>> >>>> >>> Did you read the reference? >>> >>> <quote> >>> >>> You can even build a query (using operators like ==, !=, <, >, <=, >=, >>> like, belongs) and store the query in a variable q such as in: >>> >>> >>> q = name == 'Alex' >>> >>> </quote> >>> >>> >>> >>> >>>> >>>> quarta-feira, 1 de Maio de 2019 às 22:00:27 UTC+1, Dave S escreveu: >>>>> >>>>> >>>>> >>>>> On Wednesday, May 1, 2019 at 1:53:25 PM UTC-7, [email protected] >>>>> wrote: >>>>>> >>>>>> Got the answer in the Telegram chat. Using eval. >>>>>> It's a dangerous solution but works. >>>>>> >>>>>> >>>>> What about storing a querey, as in >>>>> <URL: >>>>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Query-Set-Rows >>>>> > >>>>> ? >>>>> >>>>> /dps >>>>> >>>>> >>>>>> >>>>>> quarta-feira, 1 de Maio de 2019 às 10:07:45 UTC+1, [email protected] >>>>>> escreveu: >>>>>>> >>>>>>> Hello, >>>>>>> >>>>>>> How to pass a query set string or a string with a select/count to be >>>>>>> executed in another controller? >>>>>>> >>>>>>> On one controller I create one of these 4 examples: >>>>>>> session.checks = [ >>>>>>> 'db(db.equipment.sn_counter_id == request.args[0]).count()', >>>>>>> T('Cannot be deleted while assigned to an equipment.'), >>>>>>> ] >>>>>>> >>>>>>> session.checks = [ >>>>>>> QUERY_FOR_COUNT, >>>>>>> 'db.equipment.sn_counter_id == request.args[0]', >>>>>>> T('Cannot be deleted while assigned to an equipment.'), >>>>>>> ] >>>>>>> >>>>>>> session.checks = [ >>>>>>> 'db(db.equipment.depends_on == request.args[0]).select()', >>>>>>> T('Cannot be deleted while dependent on an option.'), >>>>>>> ] >>>>>>> >>>>>>> session.checks = [ >>>>>>> QUERY_FOR_SELECT, >>>>>>> 'db.equipment.depends_on == request.args[0]', >>>>>>> T('Cannot be deleted while dependent on an option.'), >>>>>>> ] >>>>>>> >>>>>>> and then execute it on another controller using something similar to >>>>>>> (of course my example below doesn't work): >>>>>>> if session.checks[0]: >>>>>>> session.flash = session.checks[1] >>>>>>> redirect(return_to) >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> JM >>>>>>> >>>>>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
