That worked -- thanks! On Mon, Nov 22, 2010 at 4:58 PM, mdipierro <[email protected]> wrote:
> IS_IN_DB(db,'field.id','%(name)s',groupby=db.field.name) > > On Nov 22, 4:23 pm, Audra Rudys <[email protected]> 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 >
