Error 80020009. Exception occurred. [Archive] - Cyber Tech Help Support Forums

1conair

April 23rd, 2001, 12:50 PM

I am developing an ASP page and using a Recordset to display some information. When I put this in I am getting this error "Error 80020009. Exception occurred." Anyone know what is causing this or what I can do to fix this? Below is my code

<%@ Language=VBScript %>
<% ' VI 6.0 Scripting Object Model Enabled %>

<% if StartPageProcessing() Then Response.End() %>
<FORM name=thisForm METHOD=post>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<link rel="STYLESHEET" href="Stylesheets/StateU1.css">
</HEAD>
<BODY>


<SCRIPT LANGUAGE="JavaScript" RUNAT="server">
function _initRecordset1()
{
thisPage.createDE();
var rsTmp = DE.Recordsets('classlist');
Recordset1.setRecordSource(rsTmp);
Recordset1.open();
if (thisPage.getState('pb_Recordset1') != null)
Recordset1.setBookmark(thisPage.getState('pb_Recor dset1'));
}
function _Recordset1_ctor()
{
CreateRecordset('Recordset1', _initRecordset1, null);
}
function _Recordset1_dtor()
{
Recordset1._preserveState();
thisPage.setState('pb_Recordset1', Recordset1.getBookmark());
}
</SCRIPT>



<H1>Class List</H1>
<H3>Classes available at State University</H3>




<SCRIPT LANGUAGE=JavaScript RUNAT=Server>
function _initGrid1()
{
Grid1.pageSize = 10;
Grid1.setDataSource(Recordset1);
Grid1.tableAttributes = ' cellpadding=2 cellspacing=0 bordercolor=#cccccc bgcolor=Gray border=1 cols=3 rules=ALL WIDTH=90%';
Grid1.headerAttributes = ' bgcolor=#003468 align=Left';
Grid1.headerWidth[0] = ' WIDTH=22%';
Grid1.headerWidth[1] = ' WIDTH=22%';
Grid1.headerWidth[2] = ' WIDTH=22%';
Grid1.headerFormat = '<Font face="Arial" size=4 color=White> <b>';
Grid1.colHeader[0] = '\'Number\'';
Grid1.colHeader[1] = '\'Title\'';
Grid1.colHeader[2] = '\'Major\'';
Grid1.rowAttributes[0] = ' bgcolor = White align=Left bordercolor=#cccccc';
Grid1.rowAttributes[1] = ' bgcolor = Silver align=Left bordercolor=#cccccc';
Grid1.rowFormat[0] = ' <Font face="Arial" size=2 color=Black >';
Grid1.colAttributes[0] = ' WIDTH=22%';
Grid1.colFormat[0] = '<Font Size=2 Face="Arial" Color=Black >';
Grid1.colData[0] = 'Recordset1.fields.getValue(\'ClassID\')';
Grid1.colAttributes[1] = ' WIDTH=22%';
Grid1.colFormat[1] = '<Font Size=2 Face="Arial" Color=Black >';
Grid1.colData[1] = 'Recordset1.fields.getValue(\'Title\')';
Grid1.colAttributes[2] = ' WIDTH=22%';
Grid1.colFormat[2] = '<Font Size=2 Face="Arial" Color=Black >';
Grid1.colData[2] = 'Recordset1.fields.getValue(\'Description\')';
Grid1.navbarAlignment = 'Right';
var objPageNavbar = Grid1.showPageNavbar(170,1);
objPageNavbar.getButton(0).value = ' |< ';
objPageNavbar.getButton(1).value = ' << ';
objPageNavbar.getButton(2).value = ' >> ';
objPageNavbar.getButton(3).value = ' >| ';
Grid1.hasPageNumber = true;
}
function _Grid1_ctor()
{
CreateDataGrid('Grid1',_initGrid1);
}
</SCRIPT>

<% Grid1.display %>


</BODY>
<% ' VI 6.0 Scripting Object Model Enabled %>
<% EndPageProcessing() %>
</FORM>
</HTML>

Steven.Bentley

April 23rd, 2001, 02:40 PM

Never done any ASP myself... hopefully someone else will know :)

Buzz

April 23rd, 2001, 04:26 PM

I've got no expereince with ASP either. I avoid those MS specific things. Like Steven posted, I hope someone will come along that does know ASP.

kwichang

February 28th, 2005, 10:04 PM

Lean to write ASP code with notepad instead of using microsoft visual studio. There is a log of garbage in this code. To display data from a DB using a record set takes about 6-10 lines of code.

You can use Microsoft Visual Studio to write these sorts of things, however if you dont know what its doing you will rely upon what it does and be unable to fix any problems that it cant solve for you, which will probably be a lot.

degsy

February 28th, 2005, 10:52 PM

Welcome :)

I see you dug up an oldie :D