Recordset problem

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
>
>