query.where clause using variable for field name instead of hard coded

[TracySchloss]

I'm sure if it wasn't Friday afternoon, I'd figure this out on my own.

I am trying to set up a more generic function to construct and execute a query task.   Instead of having my query.where clause be something like

selQuery.where = "DISTRICT= '" + myCode + "'";  //myCode coming from a FilteringSelect value

I'd like the field name to also be a variable.  But I think the syntax for the where clause needs to be in the form of "FIELDNAME" = 'myValue', and I'm not quite sure how to get the quotes properly formatted in the string. 

Please someone who's brain is still functioning, help me out!

[ChristopherBlinn1 · Accepted solution]

Tracy,

Just make sure your field variable is a string.  There where property is type string..

var myField = "DISTRICT"; . . . selQuery.where = myField + " = '" + myCode + "'"

I actually build the entire where statement in a string variable in most of my applications, then set .where to the variable.

Hope this helps and Happy Friday,
Chris B.

[TracySchloss]

I tried that first, before I sent this and it wasn't working.  I've changed several places in this function to use variables instead, maybe I should be expand to other lines.  This might not be the problem at all!

Like I said - Friday - brain dead.

[ChristopherBlinn1]

If you would like to post your entire function, I'd gladly take a look at it.

Or if your application is publicly accessible I can look from there.

[TracySchloss]

Thanks for the offer.  I have a feeling it's something right in front of me, so I'm going to try  a little longer.  No sense in embarrassing myself.

[TracySchloss]

Sure enough, I had renamed my errorHandler function, but forgot to change the queryTask.on event listener

 queryTask.on('error', populateErrorHandler); 

[ChristopherBlinn1]

Glad you found it!