AnsweredAssumed Answered

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

Question asked by schlot on Oct 11, 2013
Latest reply on Oct 11, 2013 by cblinnmrc
  • Comment • 6
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!
cblinnmrc
cblinnmrc Oct 11, 2013 11:30 AM
Correct Answer
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.
See the reply in context
No one else had this question

Outcomes