Looks to me you are trying to update the price field
with the literal "thePrice", move "thePrice" outside
your double quotes such as:
String query = "UPDATE parkingPrice SET
Price = " + thePrice;
--- Mick Sullivan <[EMAIL PROTECTED]> wrote:
> 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]
>
=====
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Scott
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
