topic Whereclause syntax help.. in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553032#M14975 <HTML><HEAD></HEAD><BODY><SPAN>I'm pretty sure my syntax is not correct here.&nbsp; Can someone verify and let me know?&nbsp; SECT, RDIR, RNG, TDIR, and TWP are all string values.</SPAN><BR /><BR /><PRE class="plain" name="code">spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' TDIR = '" + TDIR + "' TWP = '" + TWP;</PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>thank you..</SPAN></BODY></HTML> Tue, 02 Nov 2010 13:36:51 GMT JoshV 2010-11-02T13:36:51Z Whereclause syntax help.. https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553032#M14975 <HTML><HEAD></HEAD><BODY><SPAN>I'm pretty sure my syntax is not correct here.&nbsp; Can someone verify and let me know?&nbsp; SECT, RDIR, RNG, TDIR, and TWP are all string values.</SPAN><BR /><BR /><PRE class="plain" name="code">spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' TDIR = '" + TDIR + "' TWP = '" + TWP;</PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>thank you..</SPAN></BODY></HTML> Tue, 02 Nov 2010 13:36:51 GMT https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553032#M14975 JoshV 2010-11-02T13:36:51Z Re: Whereclause syntax help.. https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553033#M14976 <HTML><HEAD></HEAD><BODY><SPAN>It looks like you're missing a few "AND"s</SPAN><BR /><BR /><PRE class="lia-code-sample line-numbers language-none"> spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND&nbsp; TDIR = '" + TDIR + "' AND&nbsp; TWP = '" + TWP; </PRE></BODY></HTML> Sat, 11 Dec 2021 23:54:24 GMT https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553033#M14976 KenBuja 2021-12-11T23:54:24Z Re: Whereclause syntax help.. https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553034#M14977 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I'm pretty sure my syntax is not correct here.&nbsp; Can someone verify and let me know?&nbsp; SECT, RDIR, RNG, TDIR, and TWP are all string values.<BR /><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' TDIR = '" + TDIR + "' TWP = '" + TWP;</PRE><BR /><BR />thank you..</BLOCKQUOTE><BR /><BR /><BR /><SPAN>Hi,</SPAN><BR /><BR /><SPAN>som "AND" word are missing</SPAN><BR /><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro"> "' AND TDIR = '" + TDIR + "' AND TWP = '" + TWP</PRE></BODY></HTML> Tue, 02 Nov 2010 13:46:00 GMT https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553034#M14977 vincentLahaye 2010-11-02T13:46:00Z Re: Whereclause syntax help.. https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553035#M14978 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">It looks like you're missing a few "AND"s<BR /><BR /><PRE class="lia-code-sample line-numbers language-none"> spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND&nbsp; TDIR = '" + TDIR + "' AND&nbsp; TWP = '" + TWP; </PRE></BLOCKQUOTE><BR /><BR /><SPAN>Thanks Ken and Vincent.&nbsp; Is the single quotes and double quotes correct as well?</SPAN></BODY></HTML> Sat, 11 Dec 2021 23:54:27 GMT https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553035#M14978 JoshV 2021-12-11T23:54:27Z Re: Whereclause syntax help.. https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553036#M14979 <HTML><HEAD></HEAD><BODY><SPAN>We all forgot the final single quote</SPAN><BR /><BR /><PRE class="lia-code-sample line-numbers language-none"> spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND&nbsp; TDIR = '" + TDIR + "' AND&nbsp; TWP = '" + TWP + "'"; </PRE></BODY></HTML> Sat, 11 Dec 2021 23:54:30 GMT https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553036#M14979 KenBuja 2021-12-11T23:54:30Z Re: Whereclause syntax help.. https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553037#M14980 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">We all forgot the final single quote<BR /><BR /><PRE class="lia-code-sample line-numbers language-none"> spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND&nbsp; TDIR = '" + TDIR + "' AND&nbsp; TWP = '" + TWP + "'"; </PRE></BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Thanks Ken and Vincent</SPAN></BODY></HTML> Sat, 11 Dec 2021 23:54:32 GMT https://community.esri.com/t5/arcobjects-sdk-questions/whereclause-syntax-help/m-p/553037#M14980 JoshV 2021-12-11T23:54:32Z