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.
-- Ed Leafe
_______________________________________________
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]
