|
-
Mar 16th, 2001, 05:35 AM
#1
Thread Starter
New Member
Sub Addrecord
dim objConn, objRS, objComm
dim start
Set objConn = Server.CreateObject("ADODB.Connection")
set objComm = Server.CreateObject("ADODB.Command")
set objRS = Server.CreateObject ("ADODB.Recordset")
objConn.Open "File Name=D:\VirtueBroadcastingIntranet\HR\Conn\objConn.udl"
objComm.ActiveConnection = objConn
objComm.CommandText = "INSERT INTO vtvemployee(emp_fname,emp_sname,emp_dept,emp_salary,emp_hrspw,emp_stdrate,emp_start,emp_holiday,emp_ bank,emp_sort,emp_acc)VALUES(" & Request.Form ("fname") & "," & Request.Form ("sname") & "," & Request.Form ("dept") & "," & Request.Form ("salary") & "," & Request.Form ("hrspw") & "," & Request.Form ("stdrate") & "," & Request.Form ("start") & "," & Request.Form ("holiday") & "," & Request.Form ("bank") & "," & Request.Form ("sort") & "," & Request.Form ("acc") & ")""
set objRS = objComm.Execute
I don't get it. I'm thick.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|