Hi there

I'm trying to update a table in my SQL Server database but I get an

expected end of statement with this following UPDATE statement and I can't see where. Any help much appreciated.

SQLUpdate = "UPDATE ViaDetails SET Title = '" & replace(request.form("N"),"'","''") & "' , Detail = '" & replace(request.Form("A"), "'","''") & "' , Telephone = '" & replace(request.Form("T"), "'","''") & "' , Fax = "& replace(request.Form("F"), "'","''") & "' , UserID = " & replace.request.Form("EU"), "'","''") & "' , Email = " & replace(request.Form("E"),"'","''") & "'"

thanks

Adam

Write a debug script that will display the value of your variable "SQLUpdate". Seeing the actual sql command makes it much easier to debug rather than counting and matching single and double quotes. If you're still not able to see the problem, post the value of your sqlupdate variable here.

Assuming that Fax UserID and Email are string fields you are missing a single quote on each of these at the start of the value.

This
Fax = "& replace(request.Form("F"), "'","''") & "' , UserID = " & replace.request.Form("EU"), "'","''") & "' , Email = " & replace(request.Form("E"),"'","''") & "'"

should be (Notice the single quote added in front of the values for Fax, UserID and Email)
Fax = '"& replace(request.Form("F"), "'","''") & "' , UserID = '" & replace.request.Form("EU"), "'","''") & "' , Email = '" & replace(request.Form("E"),"'","''") & "'"


I hope this helps. If Fax, UserID and Email are not strings (why I would not know) then you need to remove the single quotes.

got it - thanks guys - the systematic approach like you said worked