SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Galactic Overlord gold trophysilver trophybronze trophy
    HAWK's Avatar
    Join Date
    Aug 2003
    Location
    New Zealand
    Posts
    12,587
    Mentioned
    980 Post(s)
    Tagged
    14 Thread(s)

    I'm missing something obvious...

    This is driving me nuts...
    What am I missing?


    Microsoft VBScript runtime error '800a01a8'

    Object required: '' /Course_Request/trainreq.asp, line 22

    (Line 22 orange)


    Code:
    Dim objConn 
    Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
    "DBQ=E:\Intranet\Course_Request\Form_Databases\trainreq.mdb" 
    objConn.Open 
     
    Dim objRS 
    Set objRS = Server.CreateObject ("ADODB.Recordset") 
    objRS.Open "trainreq", objConn, ,adLockOptimistic, adCmdTable 
     
    Dim MyBody 
    Dim MyCDONTSMail 
    Dim email, name, company, phone, address, model, serial, request, xerox, location 
     
    email = request.form("email") 
    name = request.form("name") 
    company = request.form("company") 
    phone = request.form("phone") 
    address = request.form("address") 
    model = request.form("model") 
    serial = request.form("serial") 
    request = request.form("request") 
    xerox = Request.Form("xerox") 
    location = Request.Form("location") 
     
    objRS.AddNew 
    objRS("email") = email 
    objRS("name") = name 
    objRS("company") = company 
    objRS("phone") = phone 
    objRS("address") = address 
    objRS("model") = model 
    objRS("serial") = serial 
    objRS("request") = request 
    objRS("xerox") = xerox 
    objRS("location") = location 
     
    objRS.Update 
    objRS.Close Set 
    objRS = Nothing 
    objConn.Close 
     
    Set objConn = Nothing

  2. #2
    SitePoint Zealot csi95's Avatar
    Join Date
    Jan 2005
    Location
    Albany, NY
    Posts
    151
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You Dim a variable called request just above the line in question. That means you have overridden the ASP Request object. Rename that variable to something else.
    Join the EasyImage Affiliate Program!
    30% commission on all sales
    Conversion rates as high as 20%
    Dedicated Affiliate Manager to help you succeed!

  3. #3
    Galactic Overlord gold trophysilver trophybronze trophy
    HAWK's Avatar
    Join Date
    Aug 2003
    Location
    New Zealand
    Posts
    12,587
    Mentioned
    980 Post(s)
    Tagged
    14 Thread(s)
    You rock!!!!!! Thanks very much.


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
  •