%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Err.Clear
strErrorUrl = ""
If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
Err.Clear
Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "Cannot create connection"
Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Cannot create record set"
fp_conn.Open Application("dbcweb_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"
fp_rs.Open "catreq", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"
fp_rs.AddNew
FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(20)
Dim arFormDBFields0(20)
Dim arFormValues0(20)
arFormFields0(0) = "optother"
arFormDBFields0(0) = "optother"
arFormValues0(0) = Request("optother")
arFormFields0(1) = "optbarcode"
arFormDBFields0(1) = "optbarcode"
arFormValues0(1) = Request("optbarcode")
arFormFields0(2) = "optpos"
arFormDBFields0(2) = "optpos"
arFormValues0(2) = Request("optpos")
arFormFields0(3) = "HeardFrom"
arFormDBFields0(3) = "HeardFrom"
arFormValues0(3) = Request("HeardFrom")
arFormFields0(4) = "optshipping"
arFormDBFields0(4) = "optshipping"
arFormValues0(4) = Request("optshipping")
arFormFields0(5) = "zipcode"
arFormDBFields0(5) = "zipcode"
arFormValues0(5) = Request("zipcode")
arFormFields0(6) = "country"
arFormDBFields0(6) = "country"
arFormValues0(6) = Request("country")
arFormFields0(7) = "optbusact"
arFormDBFields0(7) = "optbusact"
arFormValues0(7) = Request("optbusact")
arFormFields0(8) = "firstname"
arFormDBFields0(8) = "firstname"
arFormValues0(8) = Request("firstname")
arFormFields0(9) = "optdevtools"
arFormDBFields0(9) = "optdevtools"
arFormValues0(9) = Request("optdevtools")
arFormFields0(10) = "lastname"
arFormDBFields0(10) = "lastname"
arFormValues0(10) = Request("lastname")
arFormFields0(11) = "email"
arFormDBFields0(11) = "email"
arFormValues0(11) = Request("email")
arFormFields0(12) = "phone"
arFormDBFields0(12) = "phone"
arFormValues0(12) = Request("phone")
arFormFields0(13) = "optsalesint"
arFormDBFields0(13) = "optsalesint"
arFormValues0(13) = Request("optsalesint")
arFormFields0(14) = "optinvmgr"
arFormDBFields0(14) = "optinvmgr"
arFormValues0(14) = Request("optinvmgr")
arFormFields0(15) = "city"
arFormDBFields0(15) = "city"
arFormValues0(15) = Request("city")
arFormFields0(16) = "company"
arFormDBFields0(16) = "company"
arFormValues0(16) = Request("company")
arFormFields0(17) = "state"
arFormDBFields0(17) = "state"
arFormValues0(17) = Request("state")
arFormFields0(18) = "othertext"
arFormDBFields0(18) = "othertext"
arFormValues0(18) = Request("othertext")
arFormFields0(19) = "streetaddr"
arFormDBFields0(19) = "streetaddr"
arFormValues0(19) = Request("streetaddr")
FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0
FP_SaveFieldToDB fp_rs, Now, "timestamp"
fp_rs.Update
FP_DumpError strErrorUrl, "Cannot update the database"
fp_rs.Close
fp_conn.Close
Session("FP_SavedFields")=arFormFields0
Session("FP_SavedValues")=arFormValues0
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
Response.Redirect "confirm.asp"
End If
End If
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
%>
Request a Catalog
|
|
 |
 |
|
Consulting |
 |
|
Need a
custom solution? Let our experienced
consultants assist you!
Call 860-644-5891
or visit our
consulting website to learn more!
|

|
| |