topic Re: Case sensitive query task in ArcGIS API for Flex Questions

Case sensitive query task

MikeJun — Thu, 27 Jan 2011 15:48:32 GMT

I have query task to seach first name however users have to type first letter as upper case just like value in the attribute table. For example, they have to type like 'John' not 'john'. Is there way that users can type either upper or lower case?

<esri:Query id="queryFname" text="%{qTextFname.text}%" where="FName like '%{qTextFname.text}%'">

Re: Case sensitive query task

ReneRubalcava — Thu, 27 Jan 2011 16:07:16 GMT

If it's just the one name you're worried about you could do this
var qName:String = qTextFname.text.toLowerCase();
var len:int = qName.length;
var ucase:String = qName.charAt(0).toUpperCase();
var temp:String = qName.substr(1, len);
var newName:String = ucase + temp;

AS3 doesn't have a simple capitalize function.

OOh, found a regex method to do it for multiple words
http://stackoverflow.com/questions/860394/flex-capitalize-words-in-string

Re: Case sensitive query task

RobertScheitlin__GISP — Thu, 27 Jan 2011 16:40:41 GMT

Mike,

If you want to do it all inline in the mxml then this works:

<esri:Query id="queryFname" where="Upper(FName) like Upper('%{qTextFname.text}%')">

You should not use text="something" and where="something" at the same time.

Re: Case sensitive query task

MikeJun — Thu, 27 Jan 2011 17:55:02 GMT

Rene, thanks for the quick response.

Robert, thanks a lot again. simple and work great as usual.