Correction... IS_IN_DB(db,'activitytypes.code','%(code)s')
The select is web2py when the form is instantiated. Massimo On Nov 17, 2:44 am, billf <[EMAIL PROTECTED]> wrote: > IS_IN_DB(db().select(db.activitytypes.ALL),'activitytypes.code') > > IS_IN_DB also creates a dropdown list > > On Nov 17, 8:20 am, "marco prosperi" <[EMAIL PROTECTED]> > wrote: > > > hello everybody, I would like to do something similar to > > > db.activity.activitytype.requires=[IS_NOT_EMPTY(),IS_IN_SET([ x for x in > > db().select(db.activitytypes.code)] )] > > > to let the user be able to choose between values defined in another table > > (activitytypes), not in a mymodel.py file (I will modify the query above to > > limit the number of values in IS_IN_SET to just the last dozen). Is it > > possible or am I only using the wrong syntax? > > > thanks in advance > > > Marco --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
