hai frnd...
i have to leave now...
let us see it on 2maro....
that may be the problem with ur datatype definition...
look at the part of the code given .....
while(rst.next())
{
System.out.println("inside while");
%>
<tr>
<td width="100"><%=rst.getInt(1) %></td>
<td width="124"><%=rst.getString(2) %></td>
<td width="127"><%=rst.getString(3) %></td>
<td width="127"><%=rst.getInt(4) %></td>
<td width="127"><%=rst.getInt(5) %></td>
<td width="127"><%=rst.getString(6) %></td>
<td width="127"><%=rst.getInt(7) %></td>
</tr>
<%
}
here u must give the correct datatype according to each column of ur table....is the first column is int?
2nd is VArchar?
3rd varchar?
4th int?
5th int?
6th varchar?
7th int?
you must give the correct datatype according to the table defintion....
thanks and regards....
prashu
[email protected]