Object Expected Error - ASP / Active Server Pages

1 New Member

Would somebody please tell me why I am getting the error message:

Line: 46
Char: 1
Error: Object expected
Code: 0
URL: http://waitinglist.asp

Many thanks

Mark ....

My code is as follows:

Expand|Select|Wrap|Line Numbers

 
<%@LANGUAGE="VBSCRIPT"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"

   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html>

<!--#include file="../Connections/MISReporting2.asp" -->

<%

Dim rsCourses

Dim rsCourses_numRows

Dim strSQL
 
Set rsCourses = Server.CreateObject("ADODB.Recordset")

rsCourses.ActiveConnection = MM_MISReporting2_STRING

strSQL = "SELECT stcsessd.full_desc, stcstatd.aos_code, stcsessd.aos_period, stcsessd.aos_start_dt, stcsessd.aos_end_dt FROM qlsdat.dbo.stcstudf INNER JOIN qlsdat.dbo.stcstatd INNER JOIN qlsdat.dbo.stcsessd ON stcstatd.aos_code = stcsessd.aos_code INNER JOIN qlsdat.dbo.stmaos ON stcsessd.aos_code = stmaos.aos_code AND stcsessd.acad_period = stmaos.acad_period AND stcsessd.aos_period = stmaos.aos_period ON qlsdat.dbo.stcstudf.aos_code = qlsdat.dbo.stcstatd.aos_code WHERE (stcstatd.active_yn = 1) AND (stcsessd.acad_period = '07/08') AND (stmaos.stage_code = 'ENR') AND (stmaos.stage_ind='E') AND (qlsdat.dbo.stcstudf.field2 ='FT') GROUP BY stcsessd.full_desc, stcstatd.aos_code, stcsessd.aos_period, stcsessd.aos_start_dt, stcsessd.aos_end_dt, stmaos.stage_code ORDER BY stcsessd.full_desc"

'response.Write(rsCourses.Source)

rsCourses.Source = strSQL

rsCourses.CursorType = 0

rsCourses.CursorLocation = 2

rsCourses.LockType = 1

rsCourses.Open()
 
rsCourses_numRows = 0
 
%>
 
<head>
 
<title>Course Waiting List</title>

<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">

<link rel="stylesheet" href="../css/pagelayout.css" type="text/css">

<link rel="stylesheet" href="../css/scrolling_table.css" type="text/css">

<link rel="stylesheet" href="../css/menu.css" type="text/css">

<script language="JavaScript" src="../js/menu.js"></script>

<script language="JavaScript" src="../js/tree_items.js"></script>

<script language="JavaScript" src="../js/menu_tpl.js"></script>
 
</head>
 
<% 
 
    Function getCourseDetails

        Response.Write("Hello")

    End Function
 
%>
 
<body>

<div id="maincontainer">

    <div id="banner">

            <div class="innertube">

                <h1>

            <!--#include file ="../inc/header.inc"-->

                </h1>

            </div>

    </div>
 
    <div id="contentwrapper">

        <div id="contentcolumn">

            <div class="innertube">                
 
                <%response.Buffer=true%>
 
                <!-- #include file="caDataGrid.asp"--> 

                <%

                dim cDataGrid, mapPath 
 
                'now lets set our own columns  

                Set cDataGrid = New caDataGrid 

                cDataGrid.AutoColumns = false 

                cDataGrid.AddTable("dataTable")

                cDataGrid.AddColumn("Course Title") 

                cDataGrid.AddColumn("AOS Code") 

                cDataGrid.AddColumn("AOS Period")

                cDataGrid.AddColumn("Start Date")

                cDataGrid.AddColumn("End Date")

                cDataGrid.AddColumn("Chk")

                %>
 
                <form name="myform" action="form_action.asp" method="get">

                    <br />

                      <label>Course Type

                          <select name="slCourseType" onChange="getCourseDetails()">

                            <option value="">All courses</option>

                            <option value="FT">Full Time</option>

                            <option value="PT">Part Time</option>

                            <option value="SC">Short Course</option>

                            <option value="SP">Schools Projects</option>

                            <option value="KS">Key Skills</option>

                            <option value="BS">Basic Skills</option>

                            <option value="FA">Full Time Additional</option>

                          </select>

                      </label>                      

                    <br />
 
                    <div class="scrollTableContainer">

                        <%

                        cDataGrid.Bind rsCourses,true

                        %>

                    </div>
 
                        <br />

                        <input type="submit" value="Submit" />

                        <input type="reset" value="Clear" />
 
              </form>
 
                <%

                set cDataGrid = nothing

                rsCourses.Close()

                Set rsCourses = Nothing

                %>
 
            </div>

        </div>

    </div>
 
    <div id="nav">

    <div class="innertube">

        <script language="JavaScript">

            new menu (TREE_ITEMS, MENU_TPL);

        </script>

    </div>

    </div>
 
    <div id="footer">

    <!--#include file ="../inc/footer.inc"-->

    </div>
 
</div>

</body>
 
</html>

Jan 3 '08 #1

Subscribe Reply

1787

jhardman

3,406

Recognized Expert Specialist

I think your function syntax might be wrong. maybe

Expand|Select|Wrap|Line Numbers

function getCourseDetails()

Let me know if this helps at all. Check your line numbering, the line that shows up here as line 46 could not have generated this error.

Jared

Jan 5 '08 #2

Similar topics

object expected

by: Bill | last post by:

I call a function in my .js file like this: onClick="location.href='blank.html' + generateSearchStringFromForm('section')" where section is the name of my form. The function is defined as...

Javascript

function object to query STL containers

by: jsnX | last post by:

i want a function object that is a) initialized with an STL container foo b) will search foo for an object of type foo::value_type here is my code: ...

C / C++

Object reference not set to an instance of an object.

by: FredC | last post by:

OS Name Microsoft Windows XP Professional Version 5.1.2600 Service Pack 2 Build 2600 Total Physical Memory 1,024.00 MB MDE 2003 Version 7.1.3008 ..NET Framework 1.1 Version 1.1.4322 SP1...

C# / C Sharp

Error Object Expected

by: westplastic | last post by:

This one is driving me insane. The script works perfect on Firefox, but Internet Explorer keeps complaining about "Error Object Expected" and stuff like that. I've run it through Firefox's Java...

Javascript

window object

by: yb | last post by:

Hi, Is there a standard for the global 'window' object in browsers? For example, it supports methods such as setInterval and clearInterval, and several others. I know that w3c standardized...

Javascript

setTimeout and an object's methods

by: Andrew Poulos | last post by:

With the following code I can't understand why this.num keeps incrementing each time I create a new instance of Foo. For each instance I'm expecting this.num to alert as 1 but keeps incrementing. ...

Javascript

Object Expected Error!

by: loserdude84 | last post by:

Hi I keep getting the good old error 'Object Expected Error' on a site I recently built. I am really struggling with this one. Object Expected Error Line 66 <div...

Javascript

Object Expected Error in IE 7, Java 6? prevents pdf from opening in IE browser

by: JOJO123 | last post by:

I got here in search of an answer to this Javascrpt question. I upgraded jave on XP Ie 7, acrobat 5.1 and suddenly can't open any pdf files on web sites using IE. I see u guys all say, this is a...

Javascript

IE JScript Runtime Error "Object Expected"

by: RMWChaos | last post by:

WinVista/IE7 I am getting some weird errors only in IE7, but not in FF2.0.0.8 or NN9. It even happens on this website when I click "Sign In". The error is: "A Runtime Error has occurred."...

Javascript

jquery-validate "object expected" error

by: thj | last post by:

Hi. I've got this form that I'm trying to validate: <form id="periodForm" action="" method="post"> <p> Periode: <input id="startDate" name="startDate" type="text" size="7" value="<%=...

Javascript

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp