Hi, ranchers!!! I would like to insert selected data from a comboBox into my database. I have tried using: String insertData = "Insert into Test " + "Values(?, ?)"; PreparedStatement ps = con.prepareStatement(insert data); int i =0; ps.setString(++i, txtFullName.getText()); ps.setString(++i, (String)comboDeptID.getText()); ps.executeUpdate(); However, this is not working out and the error I am getting is that "String will be truncated". How can I get over this, Is there any better way of getting through this. Also, what approach should I use if I am to select data from a ListBox.
posted 14 years ago
Not to worry, I figured out my mistake. I had allocated a small variable size for the column that takes the selected value of the comboBox. My code is OK then.