Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP 3.0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 3rd, 2014, 11:57 AM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation 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

Last edited by RAMEEJAHMEDALI; September 4th, 2014 at 10:29 AM.. Reason: FOR ERROR MGS


Similar Threads
Thread Thread Starter Forum Replies Last Post
error help plz... sweetraskels BOOK: ASP.NET Website Programming Problem-Design-Solution 0 March 12th, 2007 07:58 AM
ASP Help Plz xanderxvr Classic ASP Professional 1 February 1st, 2005 03:40 PM
can some 1 plz help with this error konaseemakurradu Classic ASP Databases 4 November 26th, 2004 07:14 AM
passing value error...plz help fung Classic ASP Basics 3 August 23rd, 2004 11:25 AM
Build Error - Plz Help - Thanks ank2go ASP.NET 1.0 and 1.1 Basics 1 February 23rd, 2004 10:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.