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 <[email protected]> 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
