Click here to Skip to main content
15,900,457 members
Home / Discussions / Web Development
   

Web Development

 
QuestionWeb Service using COM object Pin
Griffin200221-Jan-09 9:31
Griffin200221-Jan-09 9:31 
Questionintegrate SnapCasa (thumbnail grabber) into a Guest book or scmething Pin
Task121-Jan-09 9:18
Task121-Jan-09 9:18 
QuestionProblem with Special Characters Pin
Christian Elena21-Jan-09 2:19
Christian Elena21-Jan-09 2:19 
AnswerRe: Problem with Special Characters Pin
SeMartens21-Jan-09 2:30
SeMartens21-Jan-09 2:30 
GeneralRe: Problem with Special Characters Pin
Christian Elena21-Jan-09 2:35
Christian Elena21-Jan-09 2:35 
QuestionThird Party Tool? Pin
Paramhans Dubey21-Jan-09 1:51
professionalParamhans Dubey21-Jan-09 1:51 
AnswerRe: Third Party Tool? Pin
Not Active21-Jan-09 2:13
mentorNot Active21-Jan-09 2:13 
QuestionADODB.Recordset error '800a0cc1' Pin
Member 340808220-Jan-09 22:30
Member 340808220-Jan-09 22:30 
HI all,

I am getting this particular error:

-------
ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/uctipresentation/pscheduler/abcweek.asp, line 100
-------

The filename: abcweek.asp

The source code:

<!--METADATA TYPE="typelib" file="c:\program files\common files\system\ado\msado15.dll"-->
<%@ Language=VBScript %>
<%If Len(Trim(Session("USERNAME"))) = 0 Then Response.Redirect "access_denied.asp"%>

<%
strPagolConn = Session("PAGOLCONN")
strDevConn = Session("DEVCONN")
%>

<HTML>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>APIIT B.Sc Presentations & EOS Interview/Midpoint Inteview Schedules</title>
</head>
<body bgcolor="#FFFFFF">


<% if session("userlogin") > 0 then %>

<%if request("weekid") <> "" then%>
<%id=request("weekid")%>



<font face="Verdana, Arial, Helvetica, sans" size="3"><b>
<%Response.write "Week " %>
<%Response.write id %>
</font></b>


<table border="0" width="614" height="1" cellpadding="0">
<tr>
<td width="12%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Student ID</font></b></p>
</td>
<td width="8%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Type</font></b></p>
</td>

<td width="9%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">SUP</font></b></p>
</td>
<td width="9%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">ASS</font></b></p>
</td>

<td width="14%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Time</font></b></p>
</td>
<td width="8%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Day</font></b></p>
</td>
<td width="10%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Location</font></b></p>
</td>

</td>
<td width="10%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Release</font></b></p>
</td>

</tr>
</table>

<table border="0" height="24" cellspacing="3" cellpadding="0" width="614">

<%
dim orsbc3

set orsbc3 = server.CreateObject ("ADODB.RECORDSET")

dim orsbc4

set orsbc4 = server.CreateObject ("ADODB.RECORDSET")

JobOfferSQL1 = "SELECT distinct(type),locale,studid,release,time,dayid,day FROM present_test where weekof='" &id& "' and entryid='1000' order by dayid, time"
orsbc3.Open JobOfferSQL1,strDevConn,1,3%>

<%do while not orsbc3.EOF %>


<tr>
<td width="12%" height="18" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<A HREF="presmain.asp?id=<%=orsbc3("studid")%>">
<%Response.Write orsbc3("studid")%>
</td>

<td width="8%" height="18" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc3("type")%>
</td>

<td width="9%" height="18" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">

<%Response.Write orsbc4("PermanentSupervisorID")%>
</td>

<td width="9%" height="18" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc4("PermanentAssessorID")%>
</td>


<td width="14%" height="18" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc3("time")%>
</td>

<td width="8%" height="18" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc3("day")%>
</td>

<td width="10%" height="18" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc3("locale")%>
</td>

<td width="10%" height="18" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc3("release")%>
</td>

<%
orsbc4.close
orsbc3.MoveNext
loop
orsbc3.close
%>

</table>
<b><font face="Verdana, Arial, Helvetica, sans" size="1"><font color="#FF0000">
Note: Should there be any changes, kindly keep us informed latest by Friday before 12pm</font>.
</font>
<font face="Verdana, Arial, Helvetica, sans" color="#008000" size="1">
<p style="margin-top: 0; margin-bottom: 0">
MIP/EOS = Midpoint / End of Semester Interviews
<p style="margin-top: 0; margin-bottom: 0">
FYP = Final Presentation

</html>
</table>



<%else%>
<b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%response.write "Welcome "%>
<%response.write(a.names)%>
<%response.write " to"%>
<p>
<%response.write "B.Sc Presentations & EOS Interview/Midpoint Interview Schedules Console."%>
<%Set a = CreateObject("dateway.Manipulation")
b = a.check(Date)
c = a.check1(Date)
d = a.check2(Date)
%>


<p>
<%response.write "Presentations Today " & b%>

</p>

<table border="0" width="614" height="1" cellpadding="0">
<tr>
<td width="12%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Student ID</font></b></p>
</td>
<td width="8%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Type</font></b></p>
</td>

<td width="9%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">SUP</font></b></p>
</td>
<td width="9%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">ASS</font></b></p>
</td>

<td width="14%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Time</font></b></p>
</td>
<td width="8%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Day</font></b></p>
</td>
<td width="10%" height="1" align="center" bgcolor="#D3D3D3">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">Location</font></b></p>
</td>
</tr>
</table>

<table border="0" height="25" cellspacing="3" cellpadding="0" width="614">

<%

dim orsbc47

set orsbc47 = server.CreateObject ("ADODB.RECORDSET")

dim orsbc38

set orsbc38 = server.CreateObject ("ADODB.RECORDSET")
JobOfferSQL1 = "SELECT distinct(type),locale,studid,time,day FROM present_test where weekof='" &d& "' and day='" &c& "' and entryid='1000' order by time"
orsbc38.Open JobOfferSQL1,strDevConn,1,3%>

<%do while not orsbc38.EOF %>


<tr>
<td width="12%" height="19" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<A HREF="presmain.asp?id=<%=orsbc38("studid")%>">
<%Response.Write orsbc38("studid")%>
</td>

<td width="8%" height="19" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc38("type")%>
</td>

<%
orsbc47.Open "select PermanentSupervisorID,PermanentAssessorID from user_student where userID ='" &orsbc38 ("studid")& "';",strPagolConn
%>


<td width="9%" height="19" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc47("PermanentSupervisorID")%>
</td>

<td width="9%" height="19" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc47("PermanentAssessorID")%>
</td>


<td width="14%" height="19" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc38("time")%>
</td>

<td width="8%" height="19" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc38("day")%>
</td>

<td width="10%" height="19" align="left" bgcolor="#CCE4FF">
<p style="margin: 0"><b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%Response.Write orsbc38("locale")%>
</td>


<%
orsbc47.close
orsbc38.MoveNext
loop
%>

</table>
<b><font face="Verdana, Arial, Helvetica, sans" size="1"><font color="#FF0000">
Note: Should there be any changes, kindly keep us informed latest by Thursday before 12pm</font>.
</font>
<font color="#008000" size="1">
<p style="margin-top: 0; margin-bottom: 0">
MIP/EOS = Midpoint / End of Semester Interviews
<p style="margin-top: 0; margin-bottom: 0">
FYP = Final Presentation


</html>
</table>
</table>
</table>



</table>




<%end if
%>
<%else%>
<p></p>
<p></p>
<p></p>
<font color="#000000">
<b><font face="Verdana, Arial, Helvetica, sans" size="2">
<%response.write "Invalid Loging or Password."%>
<p>
<%response.write "Forgot your Password? Contact at"%>
<a href="mailto:webspace@apiit.edu.my">webspace@apiit.edu.my</a>
<p>
<table>
<font face="Verdana, Arial, Helvetica, sans" size="2">
<INPUT type="button" align="center" value=" Back " name="B1" onClick="history.back(); ">
</font>
</table>

</font></b></font></b></b></b></font></font></font></font></b></b></b></b>

</font></font></font></font></b>

<%end if%>
------------------------------------------------------------------------------------

I believe the problem here is that the records are empty so its not moving forward and probably giving out the error.

I have tried to fix it in numerous ways but none succeeded. The error is displayed on the 3rd column, SUPERVISOR.

I hope there are many here who can read the code and probably help me out with a solution, I really am thankful for the help...

I have searched the error up n down on all possible websites and forums, none provide the rite sol.n.

Thanks a lot...
AnswerRe: ADODB.Recordset error '800a0cc1' Pin
Aman Bhullar20-Jan-09 23:29
Aman Bhullar20-Jan-09 23:29 
GeneralRe: ADODB.Recordset error '800a0cc1' [modified] Pin
Member 340808221-Jan-09 16:17
Member 340808221-Jan-09 16:17 
GeneralRe: ADODB.Recordset error '800a0cc1' Pin
Aman Bhullar21-Jan-09 21:20
Aman Bhullar21-Jan-09 21:20 
GeneralRe: ADODB.Recordset error '800a0cc1' Pin
Member 340808221-Jan-09 21:34
Member 340808221-Jan-09 21:34 
GeneralRe: ADODB.Recordset error '800a0cc1' Pin
Aman Bhullar21-Jan-09 23:24
Aman Bhullar21-Jan-09 23:24 
GeneralRe: ADODB.Recordset error '800a0cc1' Pin
Member 340808221-Jan-09 16:34
Member 340808221-Jan-09 16:34 
QuestionURL in action attribute is converted to page name only (for FireFox)......? Pin
AshishTijare20-Jan-09 20:10
AshishTijare20-Jan-09 20:10 
QuestionSending HTML email using mailto Pin
peaceful_warrior20-Jan-09 18:35
peaceful_warrior20-Jan-09 18:35 
AnswerRe: Sending HTML email using mailto Pin
Aman Bhullar20-Jan-09 21:51
Aman Bhullar20-Jan-09 21:51 
QuestionCapture an object in ASP Pin
Anoop Unnikrishnan20-Jan-09 17:06
Anoop Unnikrishnan20-Jan-09 17:06 
QuestionCircumventing IE Navigation Controls Pin
Roger Wright20-Jan-09 16:53
professionalRoger Wright20-Jan-09 16:53 
QuestionHow to Display Repeater control Items like table with rows and columns??? Pin
Charmy320-Jan-09 9:28
Charmy320-Jan-09 9:28 
AnswerRe: How to Display Repeater control Items like table with rows and columns??? Pin
Abhishek Sur20-Jan-09 10:41
professionalAbhishek Sur20-Jan-09 10:41 
QuestionVirtual Pin
BRIMID19-Jan-09 11:12
BRIMID19-Jan-09 11:12 
QuestionComplex c# javascript to web sevice call question Pin
m1k3314118-Jan-09 15:45
m1k3314118-Jan-09 15:45 
QuestionAdding custom button to IE Pin
Haim Nachum18-Jan-09 10:00
Haim Nachum18-Jan-09 10:00 
AnswerRe: Adding custom button to IE Pin
Not Active19-Jan-09 5:22
mentorNot Active19-Jan-09 5:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.