[crobinson]

Just need some help here I am trying to collect form data and send it to a sql table but I seem to be having a little trouble. Here is what I have. Seems to not do anything at all. Any help would be greatly appreciated


<%@ Language="VBScript" %>



<%

Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open Application("DBConnectString")

' assign variables to items in the forms collection.
strStartDate = request.form("StartDate")
strFirstName = request.form("FirstName")
strLastName = request.form("LastName")
strBirthDate = request.form("BirthDate")
strEmployeeID = request.form("EmployeeID")
strReq = request.form("Req")
strWinPass = request.form("WindowsPass")
strDiasPass = request.form("DiasPass")
strBAMPass = request.form("BAMPass")
strUnderTaCode = request.form("UnderTaCode")
strPermTemp = request.form("PermTemp")

'database connection
Set RSEmployeeData = Server.CreateObject("ADODB.Recordset")
RSEmployeeData.Open sSSQL, DataConn, 3

'Sql statement to insert the data
sSQL="INSERT INTO EmployeeData (StartDate, FirstName, LastName, BirthDate, EmployeeID, Req, WindowsPass, DiasPass, BAMPass, UnderTaCode, PermTemp) VALUES ('" _
& strStartDate & "','" & strFirstName & "','" & strLastName & "','" & strBirthDate & "','" & strEmployeeID & "','" & strReq & "','" & strWindowsPass & "','" _
& strDiasPass & "','" & strBAMPass & "','" & strUnderTaCode & "','" & strPermTemp & "')"

' execute it
set RS = DataConn.Execute(sSQL)

Response.Write "Employee Successfully Added!"

' Done. Close the connection object
DataConn.Close
Set DataConn = Nothing
%>

[Xtremist]

Is your form using Post or Get to submit the date?

[crobinson]

It is using post

[crobinson]

Fixed it thanks Stealth for your help.