1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| <%@ LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<TITLE>resultat de la modification ou de l enregistrement </TITLE>
</head>
<body style="text-align: center">
<body background="picsbase/c2.JPG">
<%
salb=Request.form("sab")
salb=replace(salb,"<br/>","\vbcrlf")
DSN_BASE = "DBQ=" & Request.ServerVariables("APPL_PHYSICAL_PATH") & "bd1.mdb" & ";Driver={Microsoft Access Driver (*.mdb)};Driverld=25"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DSN_BASE
Set RS = Server.CreateObject("ADODB.Recordset")
Select case request.form("Envoie")
case "Modifier"
SQL = "Update Contacts Set datei = '"& Request.form("datei") &"', lieuducontact = '"& Request.form("lieuducontact") &"', nomprenom = '"& Request.form("nomprenom") &"', adresse = '"& Request.form("adresse") &"', codepostal = '"& Request.form("codepostal") &"', ville = '"& Request.form("ville") &"', departement = '"& Request.form("departement") &"', paysregion = '"& Request.form("paysregion") &"', telprof = '"& Request.form("telprof") &"',postetravail = '"& Request.form("postetravail") &"',telmobile = '"& Request.form("telmobile") &"', telecopie = '"& Request.form("telecopie") &"', adresseelectronique = '"& Request.form("adresseelectronique") &"', contactprispar = '"& Request.form("contactprispar") &"', entrepriseconnupar = '"& Request.form("entrepriseconnupar") &"',lequel = '"& Request.form("lequel") &"', proprietairedunmh = '"& Request.form("proprietairedunmh") &"', lieu = '"& Request.form("lieu") &"',taille = '"& Request.form("taille") &"', marque = '"& Request.form("marque") &"', marqueq = '"& Request.form("marqueq") &"', salon = '"& Request.form("salon") &"', saisirlenbredechambre = '"& Request.form("saisirlenbredechambre") &"', budgetmaxi = '"& Request.form("budgetmaxi") &"', remarquemateriel = '"& Request.form("remarquemateriel") &"', lieudinstallation = '"& Request.form("lieudinstallation") &"', datedachatenvisage = '"& Request.form("datedachatenvisage") &"', recontact = '"& Request.form("recontact") &"', datederecontact = '"& Request.form("datederecontact") &"',projetabouti = '"& Request.form("projetabouti") &"', projetannule = '"& Request.form("projetannule") &"', remarquesdivers= '"& Request.form("remarquesdivers") &"',vfa = '"& Request.form("vfa") &"', sd = '"& Request.form("sd") &"', sab = '"& salb &"' where idco = "& Request.form("idco") &""
RS.Open SQL , Conn
Response.write "la fiche de : "& Request.form("nomprenom") &" a bien t modifi dans la base.<br/><a href=""choixcontact.asp"">Revenir</a>"
case "Enregistrer"
SQL="Insert into Contacts (datei,lieuducontact,nomprenom,adresse,codepostal,ville,departement,paysregion,telprof,postetravail,telmobile,telecopie,adresseelectronique,contactprispar,entrepriseconnupar,lequel,proprietairedunmh,lieu,taille,marque,marqueq,salon,saisirlenbredechambre,budgetmaxi,remarquemateriel,lieudinstallation,datedachatenvisage,recontact,datederecontact,projetabouti,projetannule,remarquesdivers,vfa,sd,sab) Values ('"& Request.form("datei") &"','"& Request.form("lieuducontact") &"','"& Request.form("nomprenom") &"','"& Request.form("adresse") &"','"& Request.form("codepostal") &"','"& Request.form("ville") &"','"& Request.form("departement") &"','"& Request.form("paysregion") &"','"& Request.form("telprof") &"','"& Request.form("postetravail") &"','"& Request.form("telmobile") &"','"& Request.form("telecopie") &"','"& Request.form("adresseelectronique") &"','"& Request.form("contactprispar") &"','"& Request.form("entrepriseconnupar") &"','"& Request.form("lequel") &"','"& Request.form("proprietairedunmh") &"','"& Request.form("lieu") &"','"& Request.form("taille") &"','"& Request.form("marque") &"','"& Request.form("marqueq") &"','"& Request.form("salon") &"','"& Request.form("saisirlenbredechambre") &"','"& Request.form("budgetmaxi") &"','"& Request.form("remarquemateriel") &"','"& Request.form("lieudinstallation") &"','"& Request.form("datedachatenvisage") &"','"& Request.form("recontact") &"','"& Request.form("datederecontact") &"','"& Request.form("projetabouti") &"','"& Request.form("projetannule") &"','"& Request.form("remarquesdivers") &"','"& Request.form("vfa") &"','"& Request.form("sd") &"','"& salb&"')"
Rs.Open SQL, conn
Response.write "La fiche de : "& Request.form("nomprenom") &" a bien t enregistr dans la base.<br/><a href=""choixcontact.asp"">Revenir</a>"
case else
Response.write "aucune tache choisie"
end select
Set RS = Nothing
Conn.Close
Set Conn = Nothing
%>
</BODY>
</HTML> |
Partager