www.webdeveloper.com
Results 1 to 3 of 3

Thread: Why Am I Getting This Error!!

  1. #1
    Join Date
    Feb 2003
    Location
    Sault Ste Marie, On, Canada
    Posts
    168

    Angry Why Am I Getting This Error!!

    THIS IS THE ERROR

    Error Type:
    Microsoft VBScript runtime (0x800A01B6)
    Object doesn't support this property or method: 'Fields'
    /hunting/wwwroot/View_Comments.asp, line 23


    <% @Language = VBScript %>
    <% Option Explicit %>
    <%

    Dim dbConn, dbQuery, recordsetDB, strComments, strQueryString1


    If IsObject(Session("users_dbConn") ) Then
    Set dbConn= Session("users_dbConn")
    Else
    Set dbConn = Server.CreateObject("ADODB.Connection")

    Call dbConn.Open ("Appdb1","Anyone","Anyone")

    Set Session("users_dbConn")= dbConn
    End If
    %>

    <%
    strquerystring1 = "SELECT Comments.Comments FROM Comments "
    recordsetDB = dbconn.execute(strquerystring1)

    strComments = recordsetDB.Fields("Comments").Value

    Set recordsetDB = dbConn.Execute(strquerystring1)
    %>
    <html>

    <head>
    <title>View Comments</title>
    </head>

    <body background="grback.jpg">

    <form name = "Comments" method="POST" action="View_Comments.ASP">
    <p><textarea rows="8" name="Comments" cols="41"></textarea></p>
    </form>

    </body>

    </html>

  2. #2
    Join Date
    Jan 2003
    Location
    Dundee, Scotland
    Posts
    1,367
    hi,
    change:
    strComments = recordsetDB.Fields("Comments").Value
    to
    strComments = recordsetDB("Comments")

  3. #3
    Join Date
    Feb 2003
    Location
    Sault Ste Marie, On, Canada
    Posts
    168
    IT STILL WORKED WITH THE .VALUE BUT YOU GAVE ME ANOTHER IDEA THAT WORKED ALL THE SAME. YOU THE MAN RIBBY.

    THX ALEX

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles