You are missing an "and between +"' and lname Margaret
-----Original Message----- From: Miao, Franco CAWS:EX [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 3:51 PM To: [EMAIL PROTECTED] Subject: pls help to check if it is SQL syntax error I put two SQL update statement in one Smt string get error, but when I put the same thing in SQL Squery Analyzer, it works fine no error. String updatebalance ="Update dsnuser set balance= balance+"+tamount+" from dsnuser where fname='"+fname+"' lname='"+lname+"' Update dsnuser set balance= balance-"+tamount+" from dsnuser where uname='"+tname+"' "; // Get result code int updateCount=SQLStatement.executeUpdate(updatebalance); ---------------------------------------------------------------------------- -------------------- javax.servlet.ServletException: Line 1: Incorrect syntax near 'lname'. =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
