inserting multiple selection from checkbox in to one column
 

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

Re: inserting multiple selection from checkbox in to one column
 

With a prepared statement and multiple executes.

Re: inserting multiple selection from checkbox in to one column
 

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).

Re: inserting multiple selection from checkbox in to one column
 

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.

Re: inserting multiple selection from checkbox in to one column
 

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

Re: inserting multiple selection from checkbox in to one column
 

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?