I have a site that works fine using a local server on my laptop.............however when I
access my site on Brinkster, that gets its source of iformation from the database, I get the following error message:
(My site is built on Dreamweaver using asp and Acess as a database).


ADODB.Fields error '800a0cc1'

Item cannot be found in the collection corresponding to the requested
name or ordinal.

/tasquiz2/tours_detail.asp, line 369

---------------------------------------------------------------------------

code around line 369:

h2><img src="<%=(rs_tourDetail.Fields.Item("tour_imageURL".Value)%>" alt=
"<%=(rs_tourDetail.Fields.Item("tour_imageALT".Value)%>" align="right">
<%=(rs_tourDetail.Fields.Item("countryName".Value)%>: <%=(rs_tourDetail.
Fields.Item("tourName".Value)%></h2>

.......................line 369 below.................................................
<p><strong>Tour Description</strong>:<%=(rs_tourDetail.Fields.Item("description".Value)%></p>

..................then code follow:.......

<p><strong>Number of Nights</strong>: <%=(rs_tourDetail.Fields.Item("numNights".Value)%></p>


<p><strong>Meals Per Day Included</strong>: <%=(rs_tourDetail.Fields.Item("meals_per_day".Value)%></p>
<p><strong>Exercise Required</strong>: <%=(rs_tourDetail.Fields.Item("exerciseReqd".Value)%></p>

---------------------------------------------------------------------------------
If I delete line 369 the site works perfectly...without the necessary "description" information.
I have deleted and inserted the code manually and using the "insert" button from the Bindings panel.

Obviously I am missing something simple which isn't hitting me at the moment.
Help would be truly appreciated.
Best wishes
Jim
cc1

I finally worked a way around this problem by adding a new field to my table, named "descript", copied all the data from the "description" field into "descript" field.
Then on my dreamweaver asp page I replaced the errand "description" field with the new field "descript", and ecco (or voila if you prefer French) it all works.
Unbelieveable.
Hope that can help someone else some day.