poliboy7
Messages postés1Date d'inscriptionmardi 8 juillet 2008StatutMembreDernière intervention11 août 2008
-
11 août 2008 à 21:02
nhervagault
Messages postés6063Date d'inscriptiondimanche 13 avril 2003StatutMembreDernière intervention15 juillet 2011
-
11 août 2008 à 21:55
voila je suis reponsable d'un site et il y a cette page qu'on utilise comme page pour modifier le infos des utilisateur mais a chaque fois que je clique le bouton update record il ya cette erreur
Microsoft JET Database Engineerror '80040e14'
Syntax error in UPDATE statement.
/adm/EditUser.asp, line 103
voici le code de la page merci de votre reponse
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
// *** Logout the current user.
MM_Logout = String(Request.ServerVariables("URL")) + "?MM_Logoutnow=1";
if (String(Request("MM_Logoutnow"))=="1") {
Session.Contents.Remove("MM_Username");
Session.Contents.Remove("MM_UserAuthorization");
var MM_logoutRedirectPage = "default.asp";
// redirect with URL parameters (remove the "MM_Logoutnow" query param). if (MM_logoutRedirectPage "") MM_logoutRedirectPage String(Request.ServerVariables("URL"));
if (String(MM_logoutRedirectPage).indexOf("?") == -1 && Request.QueryString != "") {
var MM_newQS = "?";
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
if (String(items.item()) != "MM_Logoutnow") {
if (MM_newQS.length > 1) MM_newQS += "&";
MM_newQS += items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
}
}
if (MM_newQS.length > 1) MM_logoutRedirectPage += MM_newQS;
}
Response.Redirect(MM_logoutRedirectPage);
}
%>
<!--#include file="../Connections/NewsConn.asp" -->
<%
// *** Edit Operations: declare variables
// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
MM_editAction += "?" + Server.HTMLEncode(Request.QueryString);
}
// boolean to abort record edit
var MM_abortEdit = false;
// query string to execute
var MM_editQuery = "";
%>
<%
// *** Update Record: set variables
if (String(Request("MM_update")) == "form1" &&
String(Request("MM_recordId")) != "undefined") {
var MM_editConnection = MM_NewsConn_STRING;
var MM_editTable = "Admin";
var MM_editColumn = "UserID";
var MM_recordId = "" + Request.Form("MM_recordId") + "";
var MM_editRedirectUrl = "MenuUtilisateur.asp";
var MM_fieldsStr = "Password|value|Prenom|value|nom|value|Description|value|Level|value|DenyRubriquesAddRemove|value|DenyPageAddRemove|value|Suspendu|value";
var MM_columnsStr = "Password|',none,''|Prenom|',none,''|Nom|',none,''|Description|',none,''|UserLevel|none,none,NULL|DenyRubriquesAddRemove|none,1,0|DenyPageAddRemove|none,1,0|Suspendu|none,1,0";
// create the MM_fields and MM_columns arrays
var MM_fields = MM_fieldsStr.split("|");
var MM_columns = MM_columnsStr.split("|");
// set the form values
for (var i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = String(Request.Form(MM_fields[i]));
}
// append the query string to the redirect URL
if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) { MM_editRedirectUrl +((MM_editRedirectUrl.indexOf('?') -1)?"?":"&") + Request.QueryString;
}
}
%>
<%
// *** Update Record: construct a sql update statement and execute it
if (String(Request("MM_update")) != "undefined" &&
String(Request("MM_recordId")) != "undefined") {