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, "Impossible de créer la connexion"
Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Impossible de créer un jeu d'enregistrements"
fp_conn.Open Application("Contact_ConnectionString")
FP_DumpError strErrorUrl, "Impossible d'ouvrir la base de données"
fp_rs.Open "abonnement", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "Impossible d'ouvrir le jeu d'enregistrements"
fp_rs.AddNew
FP_DumpError strErrorUrl, "Impossible d'ajouter un nouveau jeu d'enregistrements à la base de données"
Dim arFormFields0(14)
Dim arFormDBFields0(14)
Dim arFormValues0(14)
arFormFields0(0) = "Telephone"
arFormDBFields0(0) = "telephone"
arFormValues0(0) = Request("Telephone")
arFormFields0(1) = "detail"
arFormDBFields0(1) = "detail"
arFormValues0(1) = Request("detail")
arFormFields0(2) = "fax"
arFormDBFields0(2) = "fax"
arFormValues0(2) = Request("fax")
arFormFields0(3) = "secteur1"
arFormDBFields0(3) = "secteur1"
arFormValues0(3) = Request("secteur1")
arFormFields0(4) = "Prenom"
arFormDBFields0(4) = "Prenom"
arFormValues0(4) = Request("Prenom")
arFormFields0(5) = "secteur2"
arFormDBFields0(5) = "secteur2"
arFormValues0(5) = Request("secteur2")
arFormFields0(6) = "Nom"
arFormDBFields0(6) = "Nom"
arFormValues0(6) = Request("Nom")
arFormFields0(7) = "Adresse"
arFormDBFields0(7) = "Adresse"
arFormValues0(7) = Request("Adresse")
arFormFields0(8) = "CodePostal"
arFormDBFields0(8) = "CodePostal"
arFormValues0(8) = Request("CodePostal")
arFormFields0(9) = "Email"
arFormDBFields0(9) = "email"
arFormValues0(9) = Request("Email")
arFormFields0(10) = "typedebien"
arFormDBFields0(10) = "typebien"
arFormValues0(10) = Request("typedebien")
arFormFields0(11) = "titre"
arFormDBFields0(11) = "titre"
arFormValues0(11) = Request("titre")
arFormFields0(12) = "tranchepx"
arFormDBFields0(12) = "tranchedeprix"
arFormValues0(12) = Request("tranchepx")
arFormFields0(13) = "Ville"
arFormDBFields0(13) = "Ville"
arFormValues0(13) = Request("Ville")
FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0
fp_rs.Update
FP_DumpError strErrorUrl, "Impossible de mettre à jour la base de données"
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 "confirmabo.htm"
End If
End If
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
Partager