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

Like • Show 0 Likes0
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 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

cblinnmrc Oct 11, 2013 11:30 AM

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.

Actions

schlot Oct 11, 2013 12:03 PM

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.

Actions

cblinnmrc Oct 11, 2013 12:21 PM

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.

Actions

schlot Oct 11, 2013 1:04 PM

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.

Actions

schlot Oct 11, 2013 1:10 PM

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

 queryTask.on('error', populateErrorHandler);

Actions

cblinnmrc Oct 11, 2013 1:13 PM

Glad you found it!

Actions

6 Replies

cblinnmrc Oct 11, 2013 11:30 AM
Unmark Correct
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.
Like • Show 0 Likes0
Actions
schlot Oct 11, 2013 12:03 PM
Mark Correct
Correct Answer
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.
Like • Show 0 Likes0
Actions
cblinnmrc Oct 11, 2013 12:21 PM
Mark Correct
Correct Answer
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.
Like • Show 0 Likes0
Actions
schlot Oct 11, 2013 1:04 PM
Mark Correct
Correct Answer
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.
Like • Show 0 Likes0
Actions
schlot Oct 11, 2013 1:10 PM
Mark Correct
Correct Answer
Sure enough, I had renamed my errorHandler function, but forgot to change the queryTask.on event listener
```
 queryTask.on('error', populateErrorHandler); 
```
Like • Show 0 Likes0
Actions
cblinnmrc Oct 11, 2013 1:13 PM
Mark Correct
Correct Answer
Glad you found it!
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

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

Outcomes

Related Content

Recommended Content