General discussion

Locked

SQL Update Incorrect syntax

By Sandy ·
I am using the following code to update a record displayed in a form to an Access database but cannot get the syntax right! Any ideas as to what Ive done wrong?
Thanks in advance.
<%
rs.MoveNext
rs.Close
END IF
ELSEIF Request.Form("flag")="2" THEN

SQLstmt = "UPDATE ClientTbl SET "

SQLstmt = SQLstmt & "VALUES ('" & request.form("FirstName") & "','" &

request.form("LastName") & "','" & request.form("Address1") & "','" &

request.form("Address2") & "','" & request.form("Town") & "','" &

request.form("County") & "','" & request.form("PostCode") & "','" &

request.form("Tel")& "','" & request.form("Fax")& "','" & request.form("AccountNotes")

& "')"


SQLstmt = SQLstmt & "WHERE AcNo=" & TRIM(Request.Form("Recordid"))

%>

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums