BUG #2680: Update statement did not work with String object

Поиск
Список
Период
Сортировка
От Ravindra
Тема BUG #2680: Update statement did not work with String object
Дата
Msg-id 200610060640.k966eTmS016749@wwwmaster.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2680
Logged by:          Ravindra
Email address:      ravi@computer.org
PostgreSQL version: 8.1.4
Operating system:   Debian
Description:        Update statement did not work with String object
Details:

when i create a string object with the SQL statement and feed to
statement.executeUpdate(),nothing happens.
but if i write the sql with in statement.executeUpdate() it works.

Following code does not work
        String sql="update FieldOptions set option_description='"+newValue+"'
where field_name='country' and
option_code='"+(this.countryCode.trim())+"'";
        Connection cn=context.getDBConnection();
       statement=cn.createStatement();
           int res=statement.executeUpdate(sql);
        cn.commit();

but instead of the "sql" String object if i feed the string directly it
works. as given below

int res=statement.executeUpdate("update FieldOptions set
option_description='"+newValue+"' where field_name='country' and
option_code='"+(this.countryCode.trim())+"'");


pleaese check

thanks

ravindra

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "thanigaivel"
Дата:
Сообщение: BUG #2679: Logon failure error 1069
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2677: BCC 5.5 can't compile libpq 8.2 beta 1