Asp Syntax Error In Update Statement
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Syntax Error In Update Statement Access
of this site About Us Learn more about Stack Overflow the company Business syntax error in update statement c# Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask
Syntax Error In Update Statement Vba
Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign syntax error in update statement oledb up Syntax error in Update Statement ASP Classic up vote 0 down vote favorite I am having the syntax error in my code on a update statement, after reading multiple posts about it I cant figure out what is causing the error. The code is as follows: if request.querystring("do")="customer" then New_customer = request.Form("customer") openconn con sSQL="SELECT RelationNumber FROM Relations WHERE RelationName='" & syntax error in update statement vb6 New_customer & "'" set rst = con.execute(sSQL) if rst.EOF then response.write "No relation found" else Relationnumber_update = rst("RelationNumber") sSQL2="SELECT Number FROM Orders WHERE Relation=" & Relationnumber_update & "" set rst2 = con.execute(sSQL2) if rst2.EOF then response.write("No order number found!") else if Relationnumber_update <> 1000 then Ordernumber_update = rst2("Nummer") sSQL3="UPDATE Bookings SET Order=" & Ordernumber_update & " WHERE ID=" & request("ID") con.execute(sSQL3) else response.write("Order number 1000 is not allowed!") end if end if end if closeconn con response.redirect("myPage.asp?action=page") response.end end if The error happens on the line: sSQL3="UPDATE Bookings SET Order=" & Ordernumber_update & " WHERE ID=" & request("ID") Things to know: The request queriestring is from the form where the user can choose a customer in a dropdown list. See code: