Web Development

20-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:


<%@ 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")%>


<%Response.write "Week " %>
<%Response.write id %>


<table border="0" width="614" height="1" cellpadding="0">
<tr>
<td width="12%" height="1" align="center" bgcolor="#D3D3D3">
Student ID
</td>
<td width="8%" height="1" align="center" bgcolor="#D3D3D3">
Type
</td>

<td width="9%" height="1" align="center" bgcolor="#D3D3D3">
SUP
</td>
<td width="9%" height="1" align="center" bgcolor="#D3D3D3">
ASS
</td>

<td width="14%" height="1" align="center" bgcolor="#D3D3D3">
Time
</td>
<td width="8%" height="1" align="center" bgcolor="#D3D3D3">
Day
</td>
<td width="10%" height="1" align="center" bgcolor="#D3D3D3">
Location
</td>

</td>
<td width="10%" height="1" align="center" bgcolor="#D3D3D3">
Release
</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">

<A HREF="presmain.asp?id=<%=orsbc3("studid")%>">
<%Response.Write orsbc3("studid")%>
</td>

<td width="8%" height="18" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc3("type")%>
</td>

<td width="9%" height="18" align="left" bgcolor="#CCE4FF">


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

<td width="9%" height="18" align="left" bgcolor="#CCE4FF">

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

<td width="14%" height="18" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc3("time")%>
</td>

<td width="8%" height="18" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc3("day")%>
</td>

<td width="10%" height="18" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc3("locale")%>
</td>

<td width="10%" height="18" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc3("release")%>
</td>

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

</table>

Note: Should there be any changes, kindly keep us informed latest by Friday before 12pm.



MIP/EOS = Midpoint / End of Semester Interviews

FYP = Final Presentation

</html>
</table>

<%else%>

<%response.write "Welcome "%>
<%response.write(a.names)%>
<%response.write " to"%>

<%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)
%>


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



<table border="0" width="614" height="1" cellpadding="0">
<tr>
<td width="12%" height="1" align="center" bgcolor="#D3D3D3">
Student ID
</td>
<td width="8%" height="1" align="center" bgcolor="#D3D3D3">
Type
</td>

<td width="9%" height="1" align="center" bgcolor="#D3D3D3">
SUP
</td>
<td width="9%" height="1" align="center" bgcolor="#D3D3D3">
ASS
</td>

<td width="14%" height="1" align="center" bgcolor="#D3D3D3">
Time
</td>
<td width="8%" height="1" align="center" bgcolor="#D3D3D3">
Day
</td>
<td width="10%" height="1" align="center" bgcolor="#D3D3D3">
Location
</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">

<A HREF="presmain.asp?id=<%=orsbc38("studid")%>">
<%Response.Write orsbc38("studid")%>
</td>

<td width="8%" height="19" align="left" bgcolor="#CCE4FF">

<%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">

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

<td width="9%" height="19" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc47("PermanentAssessorID")%>
</td>

<td width="14%" height="19" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc38("time")%>
</td>

<td width="8%" height="19" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc38("day")%>
</td>

<td width="10%" height="19" align="left" bgcolor="#CCE4FF">

<%Response.Write orsbc38("locale")%>
</td>

<%
orsbc47.close
orsbc38.MoveNext
loop
%>

</table>

Note: Should there be any changes, kindly keep us informed latest by Thursday before 12pm.



MIP/EOS = Midpoint / End of Semester Interviews

FYP = Final Presentation

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

</table>

<%end if
%>
<%else%>





<%response.write "Invalid Loging or Password."%>

<%response.write "Forgot your Password? Contact at"%>
<a href="mailto:webspace@apiit.edu.my">webspace@apiit.edu.my</a>

<table>

<INPUT type="button" align="center" value=" Back " name="B1" onClick="history.back(); ">

</table>





<%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...

Aman Bhullar20-Jan-09 23:29

Re: ADODB.Recordset error '800a0cc1' [modified]

20-Jan-09 23:29

Member 3408082 wrote:

Response.Write orsbc4("PermanentSupervisorID")

In the above code you have used Response.Write orsbc4("PermanentSupervisorID")
But where you have opened the recordset using query, i am unable to locate.
Please check it..... Wink | ;)

Member 340808221-Jan-09 16:17

21-Jan-09 16:17

ohh sorry, ok i have added dat to the code,

]]>

bt now the error message changes to:

"
ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/uctipresentation/pscheduler/abcweek.asp, line 0
"

....dang Frown | :(

Aman Bhullar21-Jan-09 21:20

21-Jan-09 21:20

Member 3408082 wrote:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

i.e. either you have reached end of record or there are no rows in table

Member 340808221-Jan-09 21:34

21-Jan-09 21:34

thanks dude, actualy ure earlier reply kinda helped me lot to get to the source of the problem...
This code isnt done by me, the previous developer did it, dat was correct, then some coleague brot it over to another system, just tried to do the same thing but i gess kinda screwed it up...
actualy u see everything other dan Supervisor and the Accessor comes from a different database.
So the Student Id in the DB1 doesnt exist in the DB2 which the Supervisor and the accesor belongs to.
Thats y the error pops up...

thanks a lot dude, i mite need to ask u again if i got any probs... Smile | :)

add me to ure msn if u want to Smile | :)

shounakg@msn.com

peace

Aman Bhullar21-Jan-09 23:24

21-Jan-09 23:24

hi,

I am sorry, i don't have a msn mail. I use gmail. If you have a gmail account then add me in your list
my id is: aman@armatrimonials.com
or you can also mail me if you ever have problem with ASP.

Member 340808221-Jan-09 16:34

URL in action attribute is converted to page name only (for FireFox)......?

21-Jan-09 16:34

ohh by the wy there are no records in the database, table for that particular field.

AshishTijare20-Jan-09 20:10

AshishTijare

20-Jan-09 20:10

I have a frame. I am creating a new form object in javascript.
I have set action attribute to "TestMyPage.ashx"
During runtime, FireFox converts action attribute to full url
containing protocol, host name, virtual dir. name and page name.
e.g.: "http://localhost:4768/MyApp/TestMyPage.ashx"

It is expected that FireFox should load the url in action attribute
on submit when it have the full url.
But when I add the form object to frame, it converts the action
attribute to "TestMyPage.ashx". I don't know what is causing this.
Because action attribute now has page name only, it can not load
the page (it do not have full url now).

Code for FireFox:

	this.innerDocument = document.getElementById('MYFRAME').contentWindow.document;
	var _form = document.createElement('form');
       _form.id = 'MYFORM';
       _form.name = 'MYFORM';
       _form.method = 'post';
       _form.enctype = 'multipart/form-data';
       _form.action = 'TestMyPage.ashx'; //Here, at runtime, action attribute gives full url.
        this.innerDocument.body.appendChild(_form); //Here, at runtime, full url in action 
attribute is converted to page name only ...?.

When this is done for IE, during runtime it shows full url in action
attribute, so it loads the page successfully.
But FireFox is converting url to page name in action attribute.

Code for IE:

         var _form = this.innerDocument.createElement('<form id = "MYFORM" 
method="post" enctype="multipart/form-data"  action="ImportHandler.ashx" />');         
         var formHTML = _form.outerHTML;
         document.getElementById('MYFRAME').contentWindow.document.body.innerHTML = formHTML;

Can anybody suggest what is the problem for such behavior.
Any guesses are welcome.
Thank you.

Ashish
Software Engineer, Pune

Sending HTML email using mailto

peaceful_warrior20-Jan-09 18:35

peaceful_warrior

20-Jan-09 18:35

Hi,
I am working on a Java application in which we are generating a newsletter. Now my requirement is to send email this newsletter to subscribers. One way to do this is using JavaMail class which requires details of the SMPT server, but I do not have access to the SMPT server of my company. So I thought i'll try mailto tag. I used the following code as a test code.

<html>

<a href="mailto:?body=<h1>heading</h1>">Send as an Email</a>

</html>

this code successfully triggered my outlook express, but it did not render the html in the body. It simply wrote the whole html tag in the body of the email.

Can someone help me to figure out how can i solve this??

Re: Sending HTML email using mailto

Aman Bhullar20-Jan-09 21:51