Missing Default Property

E

eddie wang

Hi, I got the following error when access an asp page. Please help.
Thanks.

Response object error 'ASP 0185 : 8002000e'
Missing Default Property
/downtime_category-old2.asp, line 0
A default property was not found for the object.
 
R

Ray at

What's your code? Wait, line 0? What are the first five or ten lines of
your code in that page?

Ray at work
 
E

eddie wang

Here is the beginning of the code. I don't know what is line 0.
Thanks.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML>
<HEAD>
<TITLE>Downtime Chart</TITLE>
<!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.5
Library" UUID="{00000205-0000-0010-8000-00AA006D2EA4}" VERSION="2.5"-->

<LINK REL=STYLESHEET TYPE="text/css" HREF="stylesheets/standardms.css">
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR>
</HEAD>

<!-- #INCLUDE FILE="page_begin.inc" -->
<!-- #include virtual="/Include/CfxIE.inc" -->
<!-- #include virtual="/Include/SfxCrossTab.inc" -->
<!-- #include virtual="/Include/CfxIECmds.inc" -->
<!-- #include virtual="/Include/CfxIEExtra.inc" -->

<SCRIPT LANGUAGE="VBScript">
<!--
Dim sHref, sQString, aArgs, sFacility, syear
 
E

eddie wang

I need to comment out the following response.write. Thanks.

set ARS=acn.Execute("select category_desc, event_period, lost_equiv_bbls
from PO_downtime_Facilities where mid(event_period,5) in ("
+session("stryear")+ ")" + " and facility_name='EB602' " +" order by
event_PERIOD, class_id, category_id;")


'response.write ARS
 
R

Ray at

ARS is a recordset object. If you want a value from it, you'd do:

Response.WRite ARS.Fields.Item(0).Value '''0 is the first column selected,
category_desc in this case.

Ray at work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,764
Messages
2,569,564
Members
45,041
Latest member
RomeoFarnh

Latest Threads

Top