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 по дате отправления: