topic Re: Query.Where SQL Statement in ArcGIS JavaScript Maps SDK Questions

Query.Where SQL Statement

mohamedsaad1 — Sat, 03 Jan 2015 13:20:50 GMT

i have a problem writing a sql where statment ,

here is my code( working fine ) :

		var cadname = dom.byId("CADName").value ;
		var fromno= dom.byId("fromNo").value ;
		var tono= dom.byId("toNo").value ;

query.where = " CAD_NAME= '" + cadname + "' AND LAND_NUMBER=" + fromno ;

--------------------

the above code working fine , but i want to add more " AND " Statement , so the query result is between " fromno" and " endno" .

i want the statement looks like

query.where = " CAD_NAME= '" + cadname + "' AND LAND_NUMBER>" + fromno AND LAND_NUMBER< " +tono ;

i think the problem in the sequence of single and double quotes.

Thank you

M-Sa3d

Re: Query.Where SQL Statement

RichardFairhurst — Sat, 03 Jan 2015 16:38:05 GMT

You forgot to put a + and open quotes after the fromno variable. It should be:

query.where = "CAD_NAME= '" + cadname + "' AND LAND_NUMBER > " + fromno + " AND LAND_NUMBER < " + tono;

Re: Query.Where SQL Statement

mohamedsaad1 — Sat, 03 Jan 2015 16:53:55 GMT

Thank you Richard

Re: Query.Where SQL Statement

josetorres2 — Thu, 16 Feb 2017 02:11:10 GMT

Richard Fairhust, would you mind helping me out with the same issue. I am currently enrolled in a GIS class and having a really tough time. THanks so much.

Re: Query.Where SQL Statement

RichardFairhurst — Thu, 16 Feb 2017 09:11:10 GMT

Did you create your own post with the code that is not working? You should and then link to it in a post here so I will be notified.