<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("STDU.mdb"))



set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT SEATNO FROM REC ORDER BY SEATNO"
rs.Open sql,conn
SEATNO=request.form("SEATNO")

%>
<% do until rs.EOF
if rs.fields("SEATNO")=empty then
response.write("SEATNO")
end if
rs.MoveNext
loop
rs.Close
set rs=Nothing %>
<%
if SEATNO<>"" Then
sql="SELECT PRNNO,SEATNO,STUDENTNAME,BRANCH,COLLEGEABBRV,EXAMC ODE,SUBJECTS,SEM,THEORY,PRCTL,TRM,EXT,TOTAL,RESULT ,RESULTDATE FROM REC WHERE SEATNO='" &SEATNO&"'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.Open sql,conn
if RS.EOF then 'traps for IF DB empty THEN:
Response.Write "Plz Check Your RollNo!!"
Response.End
end if
%>
<table width="973" border="0">
<tr>
<td width="169">PRN NO: </td>
<td width="395">&nbsp;</td>
<td width="366">COLLEGE ABBRV </td>
<td width="366">&nbsp;</td>
</tr>
<tr>
<td>SEAT NO </td>
<td>&nbsp;</td>
<td>EXAM CODE:- </td>
<td>&nbsp;</td>
</tr>
<tr>
<td>STUDENT NAME </td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>BRANCH/SUBJECT</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<table width="100%" cellspacing="0" cellpadding="2" border="1" bgcolor="#FFCC66">
<tr bgcolor="#408080">

<th width="17%">SUBJECTS</th>
<br>
<th width="7%">SEM</th>
<th width="13%">THEORY</th>
<th width="18%">PRCTL/VIVA</th>
<th width="15%">TRM-WRK</th>
<th width="11%">EXT.</th>
<th width="19%">TOTAL</th>
</tr>
<%
do until rs.EOF
response.write("<tr bgcolor=lightyellow>")
response.write("<tr>")
response.write("<td>" & rs.fields("SEATNO") & "</td>")
response.write("<td>" & rs.fields("SUBJECT") & "</td>")
response.write("<td>" & rs.fields("THMARK") & "</td>")
response.write("<td>" & rs.fields("PARMARK") & "</td>")
response.write("<td>" & rs.fields("TOTALMARK") & "</td>")
response.write("</tr>")
rs.MoveNext
loop
rs.close
conn.Close
set rs=Nothing
set conn=Nothing%>
</table>
<p>
<% end if %>
</p>
<p align="center">An e-Bulletin of University published monthly, highlights campus activities.Document for Citizen (Nagarikanchi Sanad), Information Officers, etc..<br>
</p>
</body>
</html>
================================================== ===
Iam Getting The Following Error Mgs plz i need help..
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/asp/UNISTU/UNIRESULT.asp, line 21