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
prashobvee@gmail.com

hai frnd...
the other thing u must notice is that...is there any data in the table like wat u hav given in the search box?
is the table name is correct?
for further needs get me at prashobvee@gmail.com

thanks and regards
prashu
prashobvee@gmail.com