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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
| <%
nom = request.form("nom")
prenom = request.form("prenom")
salle = request.form("salle")
demande = request.form("demande")
commentaire = request.form("commentaire")
dates = request.form("dates")
heure = request.form("heure")
set connexion = Server.CreateObject("ADODB.Connection")
connexion.Open "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../fpdb/demandetravaux.mdb") & ";"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Ensembledemande", connexion
'rs.CursorType = adOpenDynamic
'rs.LockType = adLockPessimistic
'rs.AddNew
'rs.fields("nom") = nom
'rs("prenom") = prenom
'rs("salle") = salle
'rs("typeDemande") = demande
'rs("aurecommnet") = commentaire
'rs("dates") = dates
'rs("heure") = heure
'rs.Update
thesql="INSERT INTO Ensembledemande (nom,prenom,salle,typeDemande,autrecommnet,dates,heure) VALUES"
thesql=thesql & "('fdfdfd','dfdfdf','zdqdzqzq','dffdfdfdf','dfdf','fdfdfdf','dfdfdffdd')"
'('"&nom&"','"&prenom&"','"&salle&"','"&demande&"','"&commentaire&"','"&dates&"','"&heure&"');"
response.write(thesql)
connexion.Execute thesql
rs.Close
Set rs = Nothing
connexion.Close
Set connexion = Nothing
%>
<html>
<head>
</head>
<body>
<p>
<%=nom%>
</p>
</body>
</html> |
Partager