[thelist] Re: SQL Problem
rudy
r937 at interlog.com
Mon May 7 07:37:58 CDT 2001
> I get the following error:
> ADODB.Field error '800a0bcd'
> Either BOF or EOF is True, or the current record has been deleted;
hi marios
i'm sorry, i cannot help you with the ASP
do you have Query Manager? define your view there
a query is defined once only, like a table
plus, you have to define it before you can use it
okay, now as for your queries --
sql37="select avg(value) as a37 from Dayview
where instrument=37 group by theday"
this query will return a record set consisting of column of numbers
you will have no way of knowing which day each number is associated with,
unless you put theday into the select list as well
select theday, avg(value) as a37 from Dayview
where instrument=37 group by theday
rudy
More information about the thelist
mailing list