cgishack

Query Limit ?

Discussion created by cgishack on Oct 27, 2010
Latest reply on Nov 3, 2010 by cgishack
Hello,
I am doing a large query and the esri js api is crashing on me..

I have tested my where clause in ArcMap and it works but its not working in the JS API because of its size / length (i believe)

Below is a dump of my where clause
SWISPIN IN ('18388911.-1-53.12','1824003.-1-99','18200012.-1-35.21','1824005.-1-53.2','1824005.-1-3','18348912.-1-51','18348912.-1-59.2','18348911.-1-23.2','1824005.-1-24','18240016.-1-8','FLAG','18388911.-1-36.11','18388910.-1-7.1','1824004.-1-10','FLAG','18240016.-1-21.1','1824003.-1-99','18240016.-1-23','1824003.-1-16.2','1824004.-1-23.2','1824001.-1-10.112','1824001.-1-10.12','FLAG','18428925.-1-28.2','1824004.-1-3.12','18240020.-1-98.21','1844002.-2-16.12','FLAG','FLAG','1824005.-1-6','1824005.-1-39.2','1824005.-1-13','1824003.-1-22','1824003.-1-128','1824002.-1-38','1824003.-1-100','1842899.17-1-3','1844001.-1-51','FLAG','18348910.-1-28.113','FLAG','18240013.-1-113.2','1824003.-1-6.2','1842898.-1-45','FLAG','1824005.-1-11.12','1824006.-1-60.2','1824004.-1-35','1832893.-1-13','1844001.-1-35','1824005.-1-144','18268915.-1-13.12','1842899.17-1-15','1838898.-1-8.12','18240014.-1-39','FLAG','FLAG','1824003.-1-110','1824001.-1-10.211','18348910.-1-24.2','1824005.-1-37','1824005.-1-52.2','18240016.-1-2','1824004.-1-9','18348912.-1-45','FLAG','1824005.-1-29.1','FLAG','1824004.-1-1.11','1824004.-1-11','FLAG','1824004.-1-19.1','1824005.-1-135','FLAG','1824005.-1-42.2','18348912.-1-65.1','FLAG','18440010.-1-9.111','18240017.-1-22','18240017.-1-16.121','1824006.-1-62.2','1824007.-1-94','1824003.-1-24','1824004.-1-27.2','1824005.-1-20','FLAG','18348910.-1-24.1','FLAG','18240020.-1-16','18348912.-1-66.111','18428925.-1-7','1824003.-1-109.1','1824005.-1-135','1844006.-1-19.2','1824003.-1-101','1824003.-1-101','18348912.-1-50.2','FLAG','18348911.-1-23.1','18240020.-2-51','18240020.-2-55.12','18348911.-1-22','1824004.-1-7','18368919.-1-22.2','18388911.-1-49.12','18240014.-1-40.1','18240017.-1-16.121','1824005.-1-22.1','1824005.-1-36.12','1844001.-1-49','1824006.-1-60.1','1824003.-1-16.1','1826896.-1-59','1824003.-1-109.2','18348910.-1-15.2','18240019.-1-42','FLAG','FLAG','1824005.-1-36.2','1824005.-1-36.114','1844001.-1-40','1824003.-1-129','18428925.-1-28.2','1824004.-1-20.1','FLAG','FLAG','1824002.-1-29.1','1824005.-1-2','FLAG','1824005.-1-9.12','1824002.-1-34','1824003.-1-25.1','FLAG','1824003.-1-93','18348912.-1-59.112','1824005.-1-52.12','1844001.-1-50','18348912.-1-52','1824005.-1-29.2','18348911.-1-21','1824006.-1-8','1824005.-1-137','1824003.-1-27','18440012.-1-25.1','1824005.-1-12.1','18200012.-1-48','18240016.-1-19.2','1842898.-1-52','FLAG','FLAG','1824004.-1-36','1824006.-1-12.2','1824006.-1-56','FLAG','1824002.-1-37','1824003.-1-102','1824005.-1-17.2','1824002.-1-28.2','18388910.-1-5.1','1824003.-1-15','18388911.-1-50.2','18348911.-1-17','18348910.-1-23','18368931.-1-108.12')


Yes its long, but its really only 165 properties.

According to Firebug and my own debugging the query is not even being sent to the server, it dies on execute() but works when I use a small length where clause.
Right now i get a "Type error: io is undefined" error from the ESRI JS file.

Is there a limit on the where clause length?

Drew

Outcomes