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

[ReneRubalcava]

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.

[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.