mysql and asp from a pdf form submitted as html.

[jsanbor1]

I am have been trying to use this .pdf form on my site and have my users fill that out instead of my plain html forms.

I can get the data to insert into my table now, but it all goes into the first field. It is driving me crazy!

here is the code on my asp page.

<%
Dim myConn, strSQL, objRecordset

set myConn = createobject("ADODB.Connection")
Set objRecordset = Server.CreateObject("ADODB.Recordset")


myConn.open "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=___;"_
& "UID=______;PWD=______; OPTION=3;"


strSQL = "INSERT INTO fap(nr, firstname, address)"
strSQL = strSQL & " VALUES ('','" & request.form("txtname") & "','" & request.form("txtaddress") & "')"

myConn.execute strSQL

myConn.close
Set myConn = nothing
Response.Redirect "fap_download.html"
%>

here is a screen shot of the result.

I have 2 fields on the form right now. first name and address. (I just typed sanborn into the address field)