Feature layer WHERE clause syntax

DonFreeman

How do you write a WHERE clause in a feature layer when you want to do a string compare? Something like this:

<esri:FeatureLayer ID="AllAvailableFeatureLayer" 
      Url="http://gismaps.pagnet.org/ArcGIS/rest/services/testprojectALLBikeCounts/MapServer/0"
      MouseLeftButtonUp="AllAvailableFeatureLayer_MouseLeftButtonUp"
      SelectionColor="Yellow"
      OutFields="*"
      Where="VolunteerAM='Available' and VolunteerPM<>'Available'"
      />

Thanks

JenniferNery

It seems that your date field is a number that represents the number of milliseconds since epoch (January 1, 1970) in UTC, so your Where clause has to be in the same format.  You can test if this is the case, by using some Epoch converter: http://www.epochconverter.com/. Here are some guidelines for writing your Where clause: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000033000000.htm