Whereclause syntax help..

Question

I'm pretty sure my syntax is not correct here.  Can someone verify and let me know?  SECT, RDIR, RNG, TDIR, and TWP are all string values.spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' TDIR = '" + TDIR + "' TWP = '" + TWP;

thank you..

JoshV · Answer

We all forgot the final single quote
spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND  TDIR = '" + TDIR + "' AND  TWP = '" + TWP + "'";

Thanks Ken and Vincent

kenbuja · Answer

We all forgot the final single quote
spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND  TDIR = '" + TDIR + "' AND  TWP = '" + TWP + "'";

JoshV · Answer

It looks like you're missing a few "AND"s
spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND  TDIR = '" + TDIR + "' AND  TWP = '" + TWP;

Thanks Ken and Vincent.  Is the single quotes and double quotes correct as well?