Result Set

Hi,

This code is displaying a single row of the result set multiple times.

Can u please tell me why this is happening ?

<%

while (rsnew.next()){ %>

<td><%

out.println(rsnew.getString("EMPLOYEENAME"));%></td>

<td><%

out.println(rsnew.getString("DESIGNATION"));%></td>

<td><%

out.println(rsnew.getString("BASIC"));%></td>

<td><%

out.println(rsnew.getString("GROSS"));%></td>

<td><%

out.println(rsnew.getString("NET"));%></td>

</tr>

<%}// end of while

%>

Thanx in advance !

[940 byte] By [muditvaidyaa] at [2007-11-27 9:57:09]