Big problem when I try to update an existing field with SQL.
numero = request.querystring("numero")
auteur=Request.Form("auteur")
news=Request.Form("news")
titre=Request.Form("titre")
heure=Request.Form("heure")
sDate=Request.Form("sDate")
images1=Request.Form("images1")
images2=Request.Form("images2")
images3=Request.Form("images3")
images4=Request.Form("images4")
images5=Request.Form("images5")
images6=Request.Form("images6")
update1 = "UPDATE News SET auteur = "& auteur &", news = '"& news &"' ,titre = '"& titre &"', heure = '"& heure &"', date = '"& sDate &"', images1 = '"& images1 &"', images2 = "& images2 &", images3 = "& images3 &", images4 = "& images4 &", images5 = "& images5 &", images6 = "& images6 &" WHERE numero2 = "& numero &""
I don't know... i declare the variable.... it say me : the content of auteur is a missing operator or somthing like this.....
Please help me !!! 200 POINTS !!!!!!
Nic