Hi,

i'd like to create a form from a database.
    form = SQLFORM.factory(
        
Field('groupe',requires=IS_IN_DB(db1,db1.test.id,'%(groupe)s',multiple=False)),
        
Field('financement',requires=IS_IN_DB(db1,db1.test.id,'%(financement)s')),
        
#Field('quantity','integer',requires=IS_INT_IN_RANGE(1,100))).process()
        Field('date','date')).process()

Im my first field "groupe" there are many doubloons and i need to put a 
condtional query, howto do that ?

In Sql like this

SELECT DISTINCT **** from mytable
in web2py ..

Thank you


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to