Double-quotes. You want the value of the Java variable 'thePrice', not the
SQL text 'thePrice'.
Steve Ruby wrote:
> Mick Sullivan 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
>
> This question is very OT... (ie, nothing to do with Tomcat :()
>
> probably you need single quotes around 'thePrice' in the UPDATE
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
