In trunk but I am behing a firewall and I can ony commit to google code, not github, until later.
On Friday, 22 June 2012 17:21:51 UTC-5, backseat wrote: > > I have a combo box on a form to select a company name. The list of valid > company names is derived from a query, q, and so I have: > > t = db.t_tasks > c = db.t_companies > > t.f_company.requires = IS_EMPTY_OR(IS_IN_DB( > db(q), c.id, '%(f_name)s', zero="All")) > > That works, but the query may return more than one row for any given > company, and thus the combo repeats the company name, once for each row. I > need to make the query DISTINCT, but can't see how to do that. > > Can anyone help? > > Thanks, > Keith > -- > We're looking for good Linux people: > http://www.tiger-computing.co.uk/jobs > --
