AnsweredAssumed Answered

I need help - Javascript - query.where

Question asked by hussambukhari on Aug 29, 2014
Latest reply on Aug 29, 2014 by hussambukhari

I'm still new for ESRI, I need your help, I'm using esri.tasks.query.where but my where is more than 2600 char, and it will not work in IE below is the snap of code, it will return SyntaxError: Syntax error can any one help



!DOCTYPE html>

html>

head>


<meta http-equiv="Content-Type" content="text/html; charset=utf-8">


<!--The viewport meta tag is used to improve the presentation and behavior of the samples

<meta name="viewport" content="initial-scale=1, maximum-scale=1,user-scalable=no">


<title>Query (with a POST)</title>


<script src="//js.arcgis.com/3.10/"></script>


<script>


"esri/tasks/query", "esri/tasks/QueryTask", "esri/config",

"dojo/dom", "dojo/on", "dojo/domReady!"


function (Query, QueryTask, esriConfig, dom, on) {

//need to reference a working proxy here, dropbox doesn't allow you to host proxies


"/DotNet/proxy.ashx";

//you can either explicitly include 'http' or 'https' or infer the same protocol as the running application


var queryTask = new QueryTask("http://geoportal.abudhabi.ae/rest/services/HealthMapService/MapServer/1");

var query = new Query();

false;

"*"];

"execute"), "click", execute);

function execute() {

//1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 


var strWhere1 = " Trim(LICENSENUMBER) in ('MF1026','MF104','MF1051','MF1102','MF118','MF1190','MF120','MF1206','MF1267','MF1286','MF1288','MF1300','MF131','MF1311','MF1329','MF1425','MF1429','MF1481','MF151','MF1518','MF1575','MF1577','MF1587','MF1589','MF1605','MF1618','MF165','MF166','MF1680','MF1690','MF170','MF175','MF1767','MF1773','MF1781','MF1835','MF1854','MF186','MF1893','MF1898','MF1901','MF1922','MF1937','MF1941','MF1942','MF1954','MF1958','MF1961','MF1962','MF1964','MF1974','MF1976','MF1989','MF2','MF2003','MF2006','MF2007','MF2021','MF2044','MF2058','MF2059','MF2066','MF2079','MF2089','MF2095','MF2096','MF2099','MF21','MF2101','MF2102','MF2125','MF213','MF2132','MF2144','MF2218','MF2250','MF2270','MF2291','MF23','MF2304','MF2320','MF2326','MF2338','MF2351','MF2377','MF2378','MF2394','MF2411','MF2426','MF2452','MF2495','MF2503','MF2522','MF2527','MF254','MF2542','MF2553','MF2555','MF2599','MF2617','MF268','MF272','MF291','MF2934','MF2958','MF3065','MF3087','MF3100','MF3104','MF313','MF3167','MF3179','MF3223','MF3226','MF3273','MF3303','MF3331','MF3335','MF351','MF3516','MF3525','MF3534','MF3580','MF3586','MF3611','MF3636','MF368','MF3693','MF3696','MF3743','MF3886','MF391','MF394','MF41','MF429','MF439','MF440','MF456','MF464','MF466','MF467','MF469','MF472','MF473','MF571','MF613','MF624','MF663','MF687','MF74','MF765','MF772','MF87','MF949','MF999')";

var strWhere = " Trim(LICENSENUMBER) in ('MF1026', 'MF1026', 'MF1026', 'MF1026', 'MF1026', 'MF1026', 'MF1026', 'MF1026', 'MF1026', 'MF1026','MF1026','MF1026', 'MF1026', 'MF1026', 'MF1026', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999', 'MF999')";

function showResults(results) {

"info").innerHTML = "success";

function err(e) {

"info").innerHTML = e;

</script>

head>

body>


<input id="execute" type="button" value="run query">


<br />


<br />


<div id="info" style="padding:5px; margin:5px; background-color:#eee;">


</div>

body>

html>

Outcomes