p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning ASP 3.0 (http://p2p.wrox.com/forumdisplay.php?f=27)
-   -   ASP ERROR PLZ HELP ME... (http://p2p.wrox.com/showthread.php?t=93524)

RAMEEJAHMEDALI September 3rd, 2014 11:57 AM

ASP ERROR PLZ HELP ME...
 
<%
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


All times are GMT -4. The time now is 04:23 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.