appending variables in a query

DebbieJamieson

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 &lt; 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 &lt; 1000000"  returnGeometry="true" outSpatialReference="{map.spatialReference}">

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

but get syntax errors. Any ideas???
thanks

EokNgo

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 &lt; 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 &lt; 1000000"  returnGeometry="true" outSpatialReference="{map.spatialReference}">

      <esri:Query id="query"  where="STATE_NAME = '"  & "{qStateName.text}" & "' and pop1990 &lt; 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 &lt; 1000000'"

Try that.