Thank you for your support. It has been solved by rewriting the arguments of IS_IN_DB. The format (3rd argument) should not contain dot and should come from only one table, which is the table of the second argument. The query (1st argument) can reference more than one table (one of them is used in the second and third argument, and it is the one that contain the description that is required to be shown in the dropbox). my mistake was that I thought that the second argument can be any one of the two that are equated in the query, but choosing one will choose that table that will be used in the format (third argument).
Thanks again and see you in the next opportunity. Ashraf On Feb 22, 1:26 am, Richard Vézina <ml.richard.vez...@gmail.com> wrote: > Maybe reading IS_IN_DB doc could helps... > > Richard > > On Tue, Feb 21, 2012 at 5:22 PM, Richard Vézina <ml.richard.vez...@gmail.com > > > > > > > > > wrote: > > Ok by new style I mean this syntax : > > > db.dog.owner.requires = IS_IN_DB(db,*db.person.id*,'%(name)s') > > > Instead of : > > > db.dog.owner.requires = IS_IN_DB(db,* 'person.id'*, '%(name)s') > > > In red... > > > So, I assume this is possible I am maybe wrong : > > > db.dog.owner.requires = IS_IN_DB(db,db.person.id, db.person(db.person.id > > ).name) > > > Then if that is possible, why not : > > > db.dog.owner.requires = IS_IN_DB(db,db.person.id,'%s' % db.person( > > db.person.id).name db.othertable(db.person(db.person.id > > ).fk_to_other_table_id).field_other_table) > > > The way your table are related affect how you have to write the request... > > > db.table(id).field is nothing else then db(db.table.id == > > id).select(db.table.field).first().field > > > Richard > > > On Tue, Feb 21, 2012 at 5:00 PM, Ashraf Mansour > > <ad...@aqar-riyadh.com>wrote: > > >> Unfortunately, did not work (both). > > >> Do you know of any running example? > >> in other words, where is it explained, old style and new style? > > >> On Feb 22, 12:33 am, Ashraf Mansour <ad...@aqar-riyadh.com> wrote: > >> > I will try both and i will let you know. > > >> > On Feb 22, 12:27 am, Richard Vézina <ml.richard.vez...@gmail.com> > >> > wrote: > > >> > > On Tue, Feb 21, 2012 at 4:27 PM, Richard Vézina < > >> ml.richard.vez...@gmail.com > > >> > > > wrote: > >> > > > Old > > >> > > > IS_IN_DB(helper_set,'table.id','%(field1)s > >> (%(field2)s)',multiple=True) # > >> > > > One table > > >> > > > Maybe this work but not sure : > > >> > > > IS_IN_DB(helper_set,'table.id',db.table2(db.table1.id).fieldTable2,multiple > >> =True) > >> > > > # 2 tables > > >> > > > Richard > > >> > > > On Tue, Feb 21, 2012 at 4:21 PM, Ashraf Mansour < > >> ad...@aqar-riyadh.com>wrote: > > >> > > >> Thank you for the immediate reply. > > >> > > >> please rewrite the example using the old requires syntax. > > >> > > >> On Feb 21, 10:39 pm, Richard Vézina <ml.richard.vez...@gmail.com> > >> > > >> wrote: > >> > > >> > For represent I usually do : > > >> > > >> > lambda id: db.fktable1(id).represent_field # 1 table > >> > > >> > lambda id: > >> db.fktable2(db.fktable1(id).id).represent_field_table2 # 2 > >> > > >> table > > >> > > >> > You can maybe proceding the same way, but I am not sure... I am > >> still > >> > > >> using > >> > > >> > old requires syntax... > > >> > > >> > Please report your experiment and how you solve it. > > >> > > >> > Richard > > >> > > >> > On Tue, Feb 21, 2012 at 1:57 PM, Ashraf Mansour < > >> ad...@aqar-riyadh.com > >> > > >> >wrote: > > >> > > >> > > Hi All, > > >> > > >> > > can the query in IS_IN_DB have more than one table? > > >> > > >> > > And how the fields of these tables be referenced in the > >> format, to be > >> > > >> > > shown in the dropbox ? > > >> > > >> > > Thanks in advance. > > >> > > >> > > Ashraf
