Recordset problem

[jim_pilot]

I have a site that works fine using a local server on my laptop.............however when I
access my site on Brinkster on one partcular page , 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 follows:.......

<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

[Newsgroup_User]

are you sure your field name in the database table is "description" just
like you have it here? I think case could be an issue .. so check that.

Also check your Insert statement in the server behaviors window and see if
everything matches up from form insertion to column name insertion.
--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development


"jim_pilot" <webforumsuser@macromedia.com> wrote in message
news:e1vajl$mlo$1@forums.macromedia.com...
>I have a site that works fine using a local server on my
> laptop.............however when I
> access my site on Brinkster on one partcular page , 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 follows:.......
>
> <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
>
>

[jim_pilot]

Hi Nancy,
is the ACE in reference to flying ???
Ta for your quick reply, I checked the Access database "description" is in lower case, I re-inserted "description" on my asp page (tours_detail), using the insert button from the Bindings panel and everything works as advertised on my laptop using IIS. However when I upload and run on Brinkster I get the error message that started this thread. I have attached the entire page coding and marked (about 3/4 page down) where the problem lies.
Doesn't make sense.
Divine intervention would be appreciated !!
Best wishes
Jim

[jim_pilot]

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.