Sorry, I should have written: db.owner.own_veh_fk.requires=IS_IN_DB(db(query),'vehicle.id', '%(manufacturer)s %(vin)s')
If you need to pass a set so you need to call db(query) in order to execute the query. 2014-05-28 21:46 GMT-03:00 <[email protected]>: > I did try: > query = query1 | guery2 > and received error: "Set | Set" or similar > > > On Wednesday, May 28, 2014 7:47:36 PM UTC-4, [email protected] wrote: >> >> Thank you Mr. Massimo and your colleagues for bringing the web2py to the >> masses. >> I need to have a field that will present a choice of values that result >> from a union of query1 and query2 >> How can i create a set that would go where the question mark is? Thanks >> for any help! >> >> query1=((db.vehicle.id==db.owner.own_veh_fk)&(db.owner. >> own_end_date!=None)) >> >> query2=(~db.vehicle.id.belongs(db(db.owner.own_veh_fk==db.vehicle.id >> )._select(db.vehicle.id))) >> >> db.owner.own_veh_fk.requires=IS_IN_DB((db(?)),'vehicle.id', >> '%(manufacturer)s %(vin)s') >> >> -- > 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. > -- Att. Carlos J. Costa Cientista da Computação Esp. Gestão em Telecom EL MELECH NEEMAN! אָמֵן -- 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.
