View Single Post
 
Old October 8th, 2003, 09:39 PM
tsparker tsparker is offline
Registered User
 
Join Date: Oct 2003
Location: , , USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Inserting forms fields into Access

Hi

I'm new to ASP and hope someone can help me.

I have a web form that I want the fields to be entered into an Access database.

When I hit the submit key, I get this error message:

Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/test/test.asp, line 22

It's a really simple page, and I'm sure it's a simple error, but I can't get the user input into the database. When I hard code a ein and name into the database it works fine.

Thanks for any help!

t



<%

    Response.Expires = 0

    Dim objConn, objRS, strQ, strConn, strOutput
    Dim strConnection, strEin, strName

    strEin = Request.Form("ein")
    strName = Request.Form("name")

    Response.Write strEin & "<br/>"
    Response.Write strName

    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open strConnect

    strQ = "INSERT INTO Shippers (ein, name) VALUES "
    strQ = strQ & "(strEin, strName)"

    objConn.Execute(strQ)

%>