pGustafson
asked on
Issue using SQL string to do UPDATE
When I run the attached code I get the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near '('.
When I output newSQL I get:
UPDATE xxXXX set (userName,FirstName,LastNa me,passwor d,emailAdd ress) Values('PhilG','Phil','Gxx xxxxon','1 2345','phi lg@abc.com ') WHERE AdminID = '5'
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near '('.
When I output newSQL I get:
UPDATE xxXXX set (userName,FirstName,LastNa
dim uname, fname, lname, password, emailAdd
uname = Request.Form("uname")
fname = Request.Form("fname")
lname = Request.Form("lname")
email = Request.Form("emailAdd")
password = Request.Form("password")
Dim newSQL
newSQL = "UPDATE xxXXX set (userName,FirstName,LastName,password,emailAddress) Values('" & uname & "','" & fname & "','" & lname & "','" & password & "','" & email & "') WHERE AdminID = '" & getUserID & "'"
'Response.Write(newSQL)
Set objRSupdate = Server.CreateObject("ADODB.Recordset")
objRSupdate.Open newSQL, objConn
Response.Write("User has been added Updated.")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER