No, that was a typo just when I wrote in the UT, error still exists.
>You have wrong table name, 'thistable' instead of 'csulog6'.
>
>>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."
