topic Re: Query has no results return depend on the data? in ArcGIS JavaScript Maps SDK Questions

Query has no results return depend on the data?

MayJeff — Tue, 30 Sep 2014 17:31:13 GMT

Here is my query where clause:

query1.where = "(name) ='" + dom.byId("SUB").value + "'";

When I run a query, 90% query will return results except if the data has " ' ". For example, if my data has a name called "BRIAN'S ESTATES" then query won't return any results even though you enter the exact same name. Got ideas to change the where clause?

Thanks.

Re: Query has no results return depend on the data?

RobertScheitlin__GISP — Tue, 30 Sep 2014 19:33:30 GMT

Jeff,

This is because you will have to escape your single quote in the entered value for the expression to work.

So you have to check if the dom.byId("SUB").value has a single quote and if so then use the replace method to escape it.

        var usrVal = dom.byId("SUB").value.toString();
        if(usrVal.indexOf("'") > -1){
          usrVal = usrVal.replace(/'/g,"''");
        }