robleme update

<%@ Language=VBScript %>
<%
objconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("madat.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open objconn
if NOT isempty(Request.Form("Update")) then
conn.Execute " update direction set " _
& "nom = '" & Request.Form("nom") & "', " _
& "fonction = '" & Request.Form("fonction") & "', " _
& "departement = '" & Request.Form("departement") & "', " _
& "service = '" & Request.Form("service") & "' where " _
& "EmployeeID = " & Request.Form("EmployeeID")

response.redirect "./manage_data_menu.asp"
else
set RSEmp = conn.Execute("Select * from direction where EmployeeID = EmployeeID " _
& Request.QueryString("EmployeeID"))
end if
%>

quand j excute cette page je me retrouve avec ca

Microsoft JET Database Engine (0x80040E14)
Erreur de syntaxe (opérateur absent) dans l'expression 'EmployeeID ='.
/DIREC_press/html/update.asp, line 16

merci

set RSEmp = conn.Execute("Select * from direction where EmployeeID = EmployeeID " _
& Request.QueryString("EmployeeID"))

->>>>>

set RSEmp = conn.Execute("Select * from direction where EmployeeID = " &
Request.QueryString("EmployeeID"))

yopyop

desolé yopyop ca ne marche pas

ereur de compilation Microsoft VBScript error '800a03ea'

Erreur de syntaxe

/DIREC_press\html/update.asp, line 16

set RSEmp = conn.Execute("Select * from press where EmployeeID = " &
--------------------------------------------------------------------^
pour que tu puisse m'aider voilà la source sur la quelle j'ai fais la manip

-----------------------------------------------------------------------------------

<%@ Language=VBScript %>
<%
objconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("131415.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open objconn
if NOT isempty(Request.Form("Update")) then
	conn.Execute "update CIEmpDir set " _
	& "Name = '" & Request.Form("Name") & "', " _
	& "EmailAddress = '" & Request.Form("EmailAddress") & "', " _
	& "PhoneNumber = '" & Request.Form("PhoneNumber") & "', " _
	& "Department = '" & Request.Form("Department") & "' where " _
	& "EmployeeID = " & Request.Form("EmployeeID")
	response.redirect "./manage_data_menu.asp"
else
	set RSEmp = conn.Execute("Select * from CIEmpDir where EmployeeID = " _
	& Request.QueryString("EmployeeID"))
end if
%>

mais lui aussi ne marche pas MERCI 

salut,

A un moment tu vas chercher les valeurs dans le Form et à un autre dans le QueryString.. c'est normal ?

Ensuite je te conseille de faire (à chaque fois)
Request.Form("VALEUR")
->
Trim("" & Request.Form("VALEUR"))

Cela enlève les espaces ...

yopyop