Hi,

I connect to a database and can get a combobox to read the cell value.
Did not put in all the code for space. It is standard connection code.

<%
String connectionUrl =("jdbc:jtds:sqlserver://localhost:1032/");
String dbName="Calibration";
String driver="net.sourceforge.jtds.jdbc.Driver";
String user="sa";
String password="admin";

  // Establish the connection.
  Class.forName(driver).newInstance();
  con = DriverManager.getConnection(connectionUrl
+dbName,user,password);
  stmt = con.createStatement() ;
  rs = stmt.executeQuery(querySQL) ;

 ResultSetMetaData rsmd = rs.getMetaData() ;

 for(int i = 1 ; i <= rsmd.getColumnCount() ; i++) {
%>

<% } %>

</tr>

<%  while(rs.next()) { %>
   <tr>
       <td> <select name="cboWFMasPointTenth"
onChange="TestWFMasPointTenthfunction(this.value)">
           <option value=<%= rs.getInt(3)%> >  </option>
           <option value="1">Yes</option>
           <option value="0">No</option>
           <option value="-1">-</option>
       </td>
     <td> <%= rs.getInt(1)%> </td>
     <td> <%= rs.getString(2) %> </td>
   </tr>

The combobox will provide the user with a list. The selected value
will be read from the
database. If they change the value this will be updated in the list.

I believe that i need a session or event listner but have not idea how
to start.
Does anyone have a simple example or could provide a better
solution???

Thanks

Clive

...

I am pretty sure that is not what Roedy was getting at.

JSP (or servlets) can make reference to JavaScript
in the resulting HTML (it does not matter if it is JSP
or servlet - to a browser, it is HTML).  That JavaScript
might do things like help validate the form input on
the client side.