[thelist] Re: SQL Problem

[rudy]

> 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