IS_IN_DB(db,'field.id','%(name)s',groupby=db.field.name)
On Nov 22, 4:23 pm, Audra Rudys <sphin...@gmail.com> wrote: > I have a form that only allows a subset of choices for some of the fields, > so I'm using a SQLFORM Factory and the IS_IN_DB validator to generate a list > of allowable values for the drop down list. The determination of allowable > values requires a join, which generates some duplicates in the drop down > list. > > Is there a flag or some other way to prevent these duplicates?? e.g., if it > were a query, one could use distinct=True, however, here the parameter is a > db. > > Thanks, > Audra
