Re: [web2py] How to turn retrieved rows into a SELECT?

2012-08-29 Thread lyn2py
In addition, I have tried IS_IN_DB(...), however the db([query]) will require a variable which can be loaded by the ajax call (which I have bolded it, in the code below). But I don't know how I can make the two meet (set IS_IN_DB and pass a variable to it on-the-fly). My query is simple: query

Re: [web2py] How to turn retrieved rows into a SELECT?

2012-08-28 Thread Richard Vézina
make_a_set = (query) Than use IS_IN_DB(db(make_a_set),...) Richard On Tue, Aug 28, 2012 at 12:28 PM, lyn2py wrote: > Hello experts, > > Generally, when we do a SQLFORM, the 'reference table' fields > automatically gets *all* the available options for choosing as a dropdown > menu. > > However,

[web2py] How to turn retrieved rows into a SELECT?

2012-08-28 Thread lyn2py
Hello experts, Generally, when we do a SQLFORM, the 'reference table' fields automatically gets *all* the available options for choosing as a dropdown menu. However, I would like to get a filtered list instead of *all* of the items. Is there an available function I can use to achieve a filtered