Sorry i found
distinct=True
Le vendredi 25 septembre 2015 16:25:42 UTC+2, Laurent Lc a écrit :
>
> 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.
