On 2/22/10 1:35 PM, Ed Leafe wrote: > On Feb 22, 2010, at 6:09 AM, FraserB wrote: > >> A case insensitive filter seems to be a common requirement. >> Is there a neat and concise way of doing this? >> Or do we use ForceCase on a text edit box to obtain the value and then >> include Upper in the mySQL query? > > When you say 'filter', do you mean the Dabo bizobj filter() method, or > filtering in general in your queries? If it's the former, just use the > filterByExpression() method instead. For the latter, I would make the where > clause use the upper() function, and then override setParams() to set the > param list to the upper() value of the control. I wouldn't use ForceCase > unless you wanted to display only upper to the user.
Yes, setting ForceCase is kind of rude for most UI scenarios. If you need case-insensitive, do that behind the scenes without affecting the user. Then again, I had a user once that demanded I *turn capslock on* for a given field. Talk about misguided, but I did what I was told. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
