I get the error ADODB.Fields (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
I know what is happening in that there is no data for the specified field.
Basically I have a crosstab in access displaying the results of a query, but I am unable to view this via my asp page as not all the fields have a value as yet.
I think I can over come this either one of two ways.
1. Get the cross tab to display 0 instead of displaying nothing when their is nothing to count
2. Somehow get the asp page to return a null or 0 value if nothing appears from the query.
The query in access is as follows.
TRANSFORM Count(statusreporthsc.SDC1) AS CountOfSDC1
SELECT statusreporthsc.date2, Count(statusreporthsc.SDC1) AS [Total Of SDC1]
GROUP BY statusreporthsc.date2
and the section of the asp page displaying the results is as follows
you are trying to display a piece of data (field) but that field is not contained in teh recordest you are building.
one of those 6 fields is not in the recordset. data content doesnt matter
Providing Technology services to non profit orgs, Homeless Shelters, Food Pantries, Clean And Sober Houses and more. To date we have given away over 900 free computers !
caeli enarrant gloriam Dei !
SInce you already have your Data Source as Recordset1, use for example
<%= Recordset1("date2") %>
or if using array fields use the index
<%= Recordset1.fields(0).value %>
<%= Recordset1.fields(1).value %>
The way you have it does not specify the fields that's why you are having the fields error.