Hello Friends, How can I populate my selection box values from database,please help me out
ernest fakudze
Ranch Hand
Joined: Aug 27, 2001
Posts: 216
posted
0
I used the code below. It gets all the userNames from the db and populate the drop down menu. Of course remember to first initialise your Connecetions and ResultSets. out.pritnln("<SELECT NAME =selectedCustomer>"); out.println("<OPTION VALUE =none SELECTED> Please Select A userID </OPTION>"); while(rs.next()) { userID = rs.getString("userID"); out.println("<OPTION VALUE =\"" + userID + "\" + "); out.println(">" + userID + "</OPTION>"); } // end while out.println("</SELECT>"); [This message has been edited by ernest fakudze (edited October 05, 2001).]
In a time of drastic change it is the learners who inherit the future. The learned usually find themselves equipped to live in a world that no longer exists.<br />Eric Hoffer
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
