Hi all,
Iam trying to insert multiple values to a database from a multiple select box. But it inserting only one value. Here iam showing my simplified jsp code. Plz help me.......

 <%
        String s13;
        String driver = "org.gjt.mm.mysql.Driver";
        Connection con=null;
        PreparedStatement pstmt=null;
        String sql="INSERT INTO comp_det(membtype,products) VALUES(?,?)";
    s13=request.getParameter("membtype");
    String[] s14=request.getParameterValues("multipleselect");
try
  {
    Class.forName(driver).newInstance();
        String url="jdbc:mysql://localhost:3306/vinikzdb";
    con=DriverManager.getConnection(url,"vinikz","vini kz");
        pstmt=con.prepareStatement(sql);
         pstmt.setString(13, s13);
         int i = 0;
         while (i < s14.length ) {
         pstmt.setString(14, s14[i] + " , " );
         i++;
         }
        pstmt.executeUpdate();

place the executeUpdate() method in the while() loop and try.

- Rakesh