I did try: query = query1 | guery2 and received error: "Set | Set" or similar
On Wednesday, May 28, 2014 7:47:36 PM UTC-4, 98u...@gmail.com 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.