I am having a problem pulling data out of an Access2000 file with ASP. The statment I have been working with is:
select distinct([codeview].section)
from [codeview]
order by [codeview].section
which works fine in the SQL window inside Access but throws an unspecified error when launched from ASP. The only luck I have found some info that says I can't use distinct on a field, only a row. Is there a way I could rewrite the statement to work?
select distinct([codeview].section)
from [codeview]
order by [codeview].section
which works fine in the SQL window inside Access but throws an unspecified error when launched from ASP. The only luck I have found some info that says I can't use distinct on a field, only a row. Is there a way I could rewrite the statement to work?