Re: [web2py] edge case of SQLFORM.grid search not working on 1.99.2

2011-11-17 Thread Johann Spies
On 17 November 2011 18:08, Cliff wrote: > grid search fails to find values if > - the field type is reference:string > - the field value contains a space > > db.define_table(mytable, Field('silly_strings', 'reference:string)) > > db.mytable.sillystrings.requires = IS_IN_SET(['one', 'two', 'buckle

[web2py] edge case of SQLFORM.grid search not working on 1.99.2

2011-11-17 Thread Cliff
grid search fails to find values if - the field type is reference:string - the field value contains a space db.define_table(mytable, Field('silly_strings', 'reference:string)) db.mytable.sillystrings.requires = IS_IN_SET(['one', 'two', 'buckle my shoe'], zero='pick one' ) grid search finds 'one'