Code: Select all
<input name="FirstName" type="text" id="FirstName" value="<%=(rsUsersMod.Fields.Item("FIRST_NAME").Value)%>" size="20" readonly>
Code: Select all
If Request.Form("send") = "requestOff" Then
strSQL ="SET NOCOUNT ON; " &_
"INSERT INTO RequestOff (" &_
"FirstName," &_
"LastName," &_
"RequestTypeID," &_
"StartDate," &_
"EndDate," &_
"ReasonAbsence," &_
"Manager," &_
"Signature," &_
"DateSubmitted" &_
") VALUES (" &_
"'" & Request.Form("FirstName") & "'," &_
"'" & Request.Form("LastName") & "'," &_
"'" & Request.Form("RequestTypeID") & "'," &_
"'" & Request.Form("StartDate") & "'," &_
"'" & Request.Form("EndDate") & "'," &_
"'" & Request.Form("ReasonAbsence") & "'," &_
"'" & Request.Form("Manager") & "'," &_
"'" & Request.Form("Signature") & "'," &_
"'" & Date() & "');" &_
"SELECT @@Identity AS Ident; "
'Response.Write(strSQL)
dbConn.Execute(strSQL)
IF ((Session("Level") = "Admin")) Then
ErrorMess = "<font color=#77ae99>Request Has Been Received!</font>"
Else
Response.Redirect("log-time.asp?id=" & Request.Form("recordId") & "")
End If
End If