Whereclause syntax help..

[JoshV]

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..

[KenBuja]

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;

[vincentLahaye]

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..

Hi,

som "AND" word are missing

 "' AND TDIR = '" + TDIR + "' AND TWP = '" + TWP

[JoshV]

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?

[KenBuja]

We all forgot the final single quote

spatialFilter.WhereClause = "SECT = '" + featureID + "' AND RDIR = '" + RDIR + "' AND RNG = '" + RNG + "' AND  TDIR = '" + TDIR + "' AND  TWP = '" + TWP + "'";

[JoshV]

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