Query with a blank where clause

[KeithWeber1]

Hi all,

I am new to using the ArcGIS API for Flex. I want to query a table and return all records, but when I attempt to execute a query without setting the where clause, I get an error. If I set something in the where clause, the query executes correctly. Does someone have some example code on how to execute a query with no search criteria?

[RobertScheitlin__GISP · Accepted solution]

Keith,

   When trying to return everything than you just set the where clause to 1=1. Now each map service has a limit set by default to 1000 features.

[KeithWeber1]

Thanks! That did the trick. In this particular scenario, the table should never contain more than a couple records.

[RobertScheitlin__GISP]

Keith,

   Glad that worked for you. Now you can help the forums out by marking this thread as answered.

Don't forget to click the Mark as answer check on this post and to click the top arrow (promote).
Follow these steps as shown in the below graphic:

[RobertScheitlin__GISP]

Keith,

   Close... You missed step one (the most important) in the attached graphic.