In my VB asp page I have this line
"SELECT distinct office FROM thistable where nsn like" + "'51%' order by office"
and I get this error
A field or property with the name 'nsn' was not found on the selected data source.
However "SELECT distinct office,nsn FROM csulog6 where nsn like" + "'51%' order by office" does work
PS, I am using VFPOLEDB to access a microsoft visual Foxpro table
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."