Professional Web Applications Themes

Help Requested ... VBScript runtime Error - Microsoft SQL / MS SQL Server

First - thanks for all the help I have been asking lately. Can someone help me with this error? Error Type: Microsoft VBScript runtime (0x800A01A8) Object required: 'Request.QueryString(...)' /lab/test/testTicker.asp, line 40 Line 40 - rsUpdateEntry.Fields("line") = Request.QueryString("line") Line 41 - rsUpdateEntry.Fields("text") = Request.QueryString("TicText") Full Script <% 'Dimension variables Dim adoCon 'Holds the Database Connection Object Dim rsUpdateEntry 'Holds the recordset for the record to be updated Dim strTicker 'Holds the SQL query for the database 'Create an ADO connection odject Set adoCon = Server.CreateObject("ADODB.Connection") 'Set an active connection to the Connection object using a DSN-less connection adoCon.Open "DRIVER={Microsoft Access Driver ...

  1. #1

    Default Help Requested ... VBScript runtime Error

    First - thanks for all the help I have been asking lately.

    Can someone help me with this error?

    Error Type:
    Microsoft VBScript runtime (0x800A01A8)
    Object required: 'Request.QueryString(...)'
    /lab/test/testTicker.asp, line 40


    Line 40 - rsUpdateEntry.Fields("line") =
    Request.QueryString("line")
    Line 41 - rsUpdateEntry.Fields("text") =
    Request.QueryString("TicText")



    Full Script
    <%
    'Dimension variables
    Dim adoCon 'Holds the Database
    Connection Object
    Dim rsUpdateEntry 'Holds the recordset for the record to
    be updated
    Dim strTicker 'Holds the SQL query
    for the database

    'Create an ADO connection odject
    Set adoCon = Server.CreateObject("ADODB.Connection")

    'Set an active connection to the Connection object using
    a DSN-less connection
    adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)};
    DBQ=" & Server.MapPath("ticker.mdb")

    'Initialise the strSQL variable with an SQL statement to
    query the database

    strTicker = "UPDATE ticker1 SET [ticText] = '" &_
    Replace( Request.QueryString("TicText"),"'","''" )&_
    "' WHERE line = " & Cint( Request.QueryString("line"))


    adoCon.Execute( strTicker )


    rsUpdateEntry.Fields("line") = Request.QueryString
    ("line")
    rsUpdateEntry.Fields("text") = Request.QueryString
    ("TicText")


    'Reset server objects
    rsUpdateEntry.Close
    Set rsUpdateEntry = Nothing
    Set adoCon = Nothing

    'Return to the update select page incase another record
    needs deleting
    Response.Redirect "tAdmin.asp"
    %>
    dalethom Guest

  2. #2

    Default Help Requested ... VBScript runtime Error

    Hi

    1. If your ADO Command Object returns a recordset then
    use

     
    record to 
    kannan Guest

  3. #3

    Default Help Requested ... VBScript runtime Error

    Hi

    1. If your ADO Command Object returns a recordset then
    use

     
    record to 
    kannan Guest

Similar Threads

  1. Replies: 11
    Last Post: August 25th, 04:44 PM
  2. Error : Microsoft VBScript runtime (0x800A000D)
    By virweb in forum Dreamweaver AppDev
    Replies: 2
    Last Post: May 16th, 11:14 PM
  3. Microsoft VBScript runtime error '800a0046'
    By nicholas.gadacz in forum ASP
    Replies: 8
    Last Post: May 12th, 07:29 PM
  4. Microsoft VBScript runtime error '800a01c9'
    By Rahul Bakshi in forum ASP
    Replies: 3
    Last Post: September 28th, 05:42 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139