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.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads