SQL Prepared Statement with date

[Dcalladi]

Hi everyone
im trying to use a bit of SQL to update some field by using the date in the where clause.

i current have as my code :

        public transactionUploader(Double profit, Double change) {
        java.util.Date utilDate = new Date();
        java.sql.Date date = new java.sql.Date(utilDate.getTime());
        try {
            DriverManager.registerDriver(new com.mysql.jdbc.Driver());
            Connection conn = DriverManager.getConnection("jdbc:mysql://samp.inf.brad.ac.uk/dcalladi", "dcalladi", "Dannys21");
            pstmt = conn.prepareStatement("UPDATE Cash_Flows SET Profit = Profit + ?, "
                    + "Waste = + Waste ?, Change = Change + ?, Transactions = Transactions + 1 WHERE Date = ?");
            pstmt.setDouble(1, 56.09);
            pstmt.setDouble(2, 22.70);
            pstmt.setDouble(3, 1.00);
            pstmt.setDate(4, date);
            pstmt.executeUpdate();
            pstmt.close();
            conn.close();
        } catch (Exception ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
    }

this should to me work as it has the date in the right format adding all the data in the right format but i i getting an error

SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ Waste = + Waste 22.7, Change = Change + 1.0, Transactions = Transactions + 1 W' at line 1

seems to be curtting the statement short as last time is also included the "WHERE" part of the statement

Thanks in advance

[doWhile]

Are you sure the syntax of your SQL is valid? "Waste = + Waste ?," seems a bit odd.

[javin.paul]

try running that SQL generated by code in mysql directly , it will help you to find and resolve errors related to sql syntax quickly. once you have working sql than code that in java.

[Dcalladi]

i manage to get it working i seperate each colunm into its own update command and found out which one wasn't working
which i then found out that it was Change so for future reference to anyone Change is a keywork in SQL so you can not use it in a SQL command
so i solved my own problem by swapping Change to ChangeGiven

Thanks Guys