Hi
Can anyone help me with a simple SQL update query.
When I insert a value into my DB using the INSERT INTO statement I have no
problem.
Statement statement = connection.createStatement();
String query = "INSERT INTO parkingPrice (" +
" price " +
") VALUES ('" +
thePrice +
"')";
statement.executeQuery( query );
However I dont want multiple rows so when I try and do an update instead
using the following:
String query = "UPDATE parkingPrice SET " +
"Price='" + thePrice + "'";
System.out.println("query "+ query);
statement.executeUpdate( query );
There is no affect on the DB. I get no SQL errors and in the tomcat window
using the line "System.out.println("query "+ query);"
The query UPDATE parkingPrice SET Price='5'
The query seems valid yet there is no affect on the DB.
I am using MS ACCESS. Is the problem in the way the DB is set up?
Thanks in advance, Mick
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
