yes you are right, i was looking also in IS_IN_SET and finally after your reminder one solution came up easily,
IS_IN_SET([i.name for i in rows = union(db().select(db.a.name),db().select( db.b.name)).sort(lambda row: row.name)]) which now displays all the values of a required column from both tables! don't know if there is a better way to do this, or a way to use IS_IN_DB() but i think that this one works On Thursday, August 1, 2013 2:48:40 PM UTC+3, viniciusban wrote: > > I don't think so. > > The book says IS_IN_DB() can receive a Set, but not Rows. > > On Thu, Aug 1, 2013 at 8:33 AM, Antonis Konstantinos Tzorvas > <ant...@tzorvas.com <javascript:>> wrote: > >> --- https://groups.google.com/d/msg/web2py/o3GebSeC7j4/Sct76ynB3fsJ---- > >> > >> db=DAL()db.define_table('a',Field('name')) > >> db.define_table('b',Field('name')) > >> db.a.insert(name='Alex') > >> db.a.insert(name='Max') > >> db.a.insert(name='Tim') > >> db.b.insert(name='John') > >> db.b.insert(name='Jack') > >> def union(x,y): > >> y.colnames=x.colnames > >> return x|y > >> > >> rows = union(db().select(db.a.name),db().select(db.b.name)).sort(lambda > > >> row: row.name) > >> > >> for row in rows: print row.name > > > > > > this one worked for the union select part, > > but how can i use it with a validator like IS_IN_DB for a form? > > > > i have two identical tables which data are from different source but the > > structure is the same > > > > -- > > > > --- > > 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+un...@googlegroups.com <javascript:>. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- --- 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.
