topic Query.where problem in ArcGIS API for Flex Questions

Query.where problem

MichaelSmilie — Thu, 22 Jul 2010 20:43:42 GMT

I have a situation where I make a query dynamicly and the where clause can be quite long. This can work fine when testing on the server but when testing on client computers it throws a Fault for the where clauses that are generated that have above 10 OR statements. So if the user searches for an item that has

Bldg_Name = 'blah' OR Bldg_Name = 'bleh' OR Bldg_Name = 'blegh'...x10

A Fault will be thrown on their computer but this issue will not happen on the server. Any help would be greatly appreciated.

Thanks,
Smilie

Re: Query.where problem

RobertScheitlin__GISP — Thu, 22 Jul 2010 21:17:58 GMT

Smilie,

If you are querying the same field i.e Bldg_Name than the better SQL Query would be

Bldg_Name IN (123,234,345,456,763,566,777,888,999)

Re: Query.where problem

MichaelSmilie — Fri, 23 Jul 2010 16:44:05 GMT

Thanks Robert, this worked perfectly.