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