<% option explicit Response.Buffer = true if session("company_id") <> "" then dim conn dim rs dim ssql dim sService_Id dim sService_Name dim sService_Description dim return_page %> <% sService_Id = day(now) & month(now) & year(now) & hour(now) & minute(now) & second(now) sService_Name = trim(Request.Form("service_name")) sService_Description = trim(Request.Form("service_description")) 'replace vbCrLf to
if len(sService_Description) > 0 then sService_Description = replace(sService_Description, vbcrlf, "
", 1, -1, 1) end if set rs = server.CreateObject("adodb.recordset") rs.Open "tbl_service",conn,3,3 'add new data rs.AddNew rs.Fields("service_id") = sService_Id rs.Fields("service_name") = sService_Name rs.Fields("service_description") = sService_Description rs.Update rs.Close conn.Close set rs = nothing set conn = nothing return_page = "" Response.Write return_page else Response.Redirect "../../index.asp" end if %>