Hello, I'm juste trying to use contains with a custom FORM, but it does not work with FORM(SELECT,_multiple=True....
Here is a piece of my controller: def rebuts(): #Formulaire de saisie des rebust ListeArticle=db(db.Article.id>0).select(orderby=db.Article.CodeArticle) Selection=FORM(TABLE(TR( (TD("De l'article",SELECT(_name='DebArt', *[OPTION(ListeArticle[i].CodeArticle, _value=str(ListeArticle[i].CodeArticle)) for i in range(len(ListeArticle))]))), TD("A l'article",SELECT(_name='FinArt',*[OPTION(ListeArticle[i].CodeArticle, _value=str(ListeArticle[i].CodeArticle)) for i in range(len(ListeArticle))])), TD("Test",SELECT(_name='Test',_multiple=True,*[OPTION(ListeArticle[i].CodeArticle, _value=str(ListeArticle[i].CodeArticle)) for i in range(len(ListeArticle))])), TD("De la date (AAAA-MM-JJ)", INPUT(_name='Debut', requires = IS_DATE(error_message=T('Doit être de la forme AAAA-MM-JJ !')))), TD("A la date (AAAA-MM-JJ)", INPUT(_name='Fin',requires = IS_DATE(error_message=T('Doit être de la forme AAAA-MM-JJ !')))), TD("Sélectionner", INPUT(_type='submit',_value='Sélectionner'))))) if Selection.accepts(request.vars,keepvalues=True): pass DebArt=request.vars.DebArt Debut=request.vars.Debut Fin=request.vars.Fin FinArt=request.vars.FinArt Test=request.vars.Test [...] query5=db(db.GPOF.OF_CART.contains(Test)).select() [...] return dict(query5=query5,Test=Test) If I submit one value to the Test field => query5 act as I want (=returns db.GPOF whose field OF_CART=Test) If I submit more than one value to the Test Field => query5 does not return anything. I guess this question have already been asked around there but I cannot find it through the group. Can somebody help me with this , I'd like to returen all rows db.GP_OF whose field are selected via the Test multiple select field .... Thanks a lot