topic appending variables in a query in ArcGIS API for Flex Questions

appending variables in a query

DebbieJamieson — Thu, 29 Jul 2010 17:51:09 GMT

I can create a query with mulitple variables just fine if I hardcode all of them...

<esri:Query id="query" where="STATE_NAME = 'Texas' and pop1990 < 1000000" text="{qCityName.text}" returnGeometry="true" outSpatialReference="{map.spatialReference}">

BUT, I want to use the users input of State value and can't figure out how to append it, I have tried..

<esri:Query id="query" where="STATE_NAME = '" + "{qStateName.text}" + "' and pop1990 < 1000000" returnGeometry="true" outSpatialReference="{map.spatialReference}">

<esri:Query id="query" where="STATE_NAME = '" & "{qStateName.text}" & "' and pop1990 < 1000000" returnGeometry="true" outSpatialReference="{map.spatialReference}">

but get syntax errors. Any ideas???
thanks

Re: appending variables in a query

ReneRubalcava — Thu, 29 Jul 2010 18:06:53 GMT

If you're using the where clause, I don't think you need the text property. It's not your error though.

<esri:Query id="query" where="STATE_NAME = '{qStateName.text}' and pop1990 &lt; 1000000" returnGeometry="true" outSpatialReference="{map.spatialReference}">

FlashBuilder makes it look like you're passing regular text, but you're really binding it to the input.

Re: appending variables in a query

EokNgo — Thu, 29 Jul 2010 18:14:52 GMT

I can create a query with mulitple variables just fine if I hardcode all of them...

<esri:Query id="query" where="STATE_NAME = 'Texas' and pop1990 < 1000000" text="{qCityName.text}" returnGeometry="true" outSpatialReference="{map.spatialReference}">

BUT, I want to use the users input of State value and can't figure out how to append it, I have tried..

<esri:Query id="query" where="STATE_NAME = '" + "{qStateName.text}" + "' and pop1990 < 1000000" returnGeometry="true" outSpatialReference="{map.spatialReference}">

<esri:Query id="query" where="STATE_NAME = '" & "{qStateName.text}" & "' and pop1990 < 1000000" returnGeometry="true" outSpatialReference="{map.spatialReference}">

but get syntax errors. Any ideas???
thanks

I believe the issue is in your where clause. The whole where statement should be a single text string:
where="'STATE_NAME = ' + {qStateName.text} + ' and pop1990 < 1000000'"

Try that.