topic Creating a query statement in Geoprocessing Questions

Creating a query statement

joepublic — Fri, 17 Oct 2014 15:07:16 GMT

I would like to display a the result of a query that loops thru an array. The query statement should look the

one shown below:

countryCodes = [840, 332, 643, 724, ....];

for (var i = 0; i < countryCodes.length; i++)

{

cntryq.where = "UN = " + countryCodes =

}

cntryq.where = "UN = " + countryCodes = [0] + "OR UN = " + countryCodes = [1] + ....

Is this possible?

My script is attached

Re: Creating a query statement

KenBuja — Fri, 17 Oct 2014 15:33:30 GMT

You access objects in an array like

countryCodes

What you should do is build a query like

"UN in (840, 332, 643, 724, ....)"

which is the same as

"UN = 840 OR UN = 332 OR ..."

So you can build the statement this way

var inString = "";
for (var i = 0; i < countryCodes.length; i++)
{
   inString += countryCodes + ", ";
}
inString.slice(0, -2);

cntryq.where = "UN in (" + inString + ")";

Re: Creating a query statement

joepublic — Fri, 17 Oct 2014 19:54:01 GMT

Thanks you Ken!!

Problem solved