Hi,


Hoe to insert multiple selection from checkbox(from jsp) in to one column of the table(sql server database ).


Anyone can you help me?

Thanx

With a prepared statement and multiple executes.

Hi,
Thanx for your reply . I know, how to retreive the checkbox value(using prepared statement with request.getParameteVales("checkboxname")).

But, It will return an array of values.
I don't know about how to insert this array of values into single column of the table(sqlserver database).

No What I meant was using the JDBC prepared statement. here an example:

String[] vals = request.getParameterValues("checkbox");
try {
  PreparedStatement pStmt = conn.prepareStatement("Insert into table (field) values (?)");
  for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();
  }
} catch .....

of course replacing checkbox, table, and field with the real things.

No What I meant was using the JDBC prepared statement. here an example:

String[] vals = request.getParameterValues("checkbox");
try {
  PreparedStatement pStmt = conn.prepareStatement("Insert into table (field) values (?)");
  for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();
  }
} catch .....

of course replacing checkbox, table, and field with the real things.

Hi i have one error in this line:

pStmt.setString(1, val);


The error is ; expected.
I haven't any idea about this

Can you help me

Are you using jdk 1.5 or an earlier version. If you are not using 1.5 then the following lines
must be changed:

for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();

to:

for (int i = 0; i < vals.length; i++) {
    pStmt.setString(1, vals[i]);
    pStmt.execute();

multiple checkbox & textfield insert in Oracle9i using Jsp

It is bad enough that you reopened old thread you did not even provided proper description of whatever you up to. Do you mind to correct your mistake?

This article has been dead for over six months. Start a new discussion instead.