Hello everybody... i have a program code which needs to update the fields provided by the user . i am doing something like this.. i have a mysql table which has 27 rows and 20 columns in each row.
<%
String url="jdbc:mysql://localhost:3306/vikh?user=root&password=admin";
con=DriverManager.getConnection(url);
stmt=con.createStatement();
rst=stmt.executeQuery("select * from it_21;");
while(rst.next())
{
out.print("inside while"); //this is getting displayed
rst.updateInt(3,123445); // the program flow is stopping at this point.
rst.updateRow();
out.print("In while"); // this is not getting displayed
}
---- rest of the code ------
%> Thanks in advnace