Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old September 3rd, 2014, 12:57 PM
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 11:29 AM. Reason: FOR ERROR MGS
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 08: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 12:25 PM
Build Error - Plz Help - Thanks ank2go ASP.NET 1.0 and 1.1 Basics 1 February 23rd, 2004 10:09 PM



All times are GMT -4. The time now is 05:05 AM.


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