Hi,
Does anyone know why this statement WILL ADD a value to a record (Price)in a
database named parkingPrice:
Statement statement = connection.createStatement();
String query = "INSERT INTO parkingPrice(" +
" Price " +
") VALUES ('" +
thePrice +
"')";
System.out.println("query "+ query);
statement.executeQuery( query );
but this statement WILL NOT UPDATE the record Price:
Statement statement = connection.createStatement();
String query = "UPDATE parkingPrice SET Price = thePrice";
System.out.println("query "+ query);
statement.executeUpdate( query );
The Variable thePrice is got using this function
public void setPrice( String price ) {
thePrice = price;
}
It works for INSERT but not UPDATE????
Also my table has only 1 value , being Price(1 row and 1 column).
I do not want to INSERT, I just want to UPDATE the single value.
Anyone at all with any ideas???
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]
