Frontpage modules not running

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am a Frontpage learning-by-doing person and am having trouble running
frontpage modules. There are two, possibly related, problems:

Problem 1: "Module1" contains Public Function statements that are called up
from VB code within an asp page. I get a "Type mismatch" error message when
I run the asp page. The error line is the line that contains the function
call.

An example of the function call in the asp page is: j =
MaxConfirmedOccupancy (#1/1/2005#, #1/10/2005#, 2)

The error message occurs even if the function is reduced to:
Public Function MaxConfirmedOccupancy(dateFirstNight As Date,
dateLastNight As Date, intRoomID As Integer) As Integer

End Function

Do I need to do anything special with the module other than typing in the
functions and saving/closing the VB editor?

Problem 2: I note that I cannot compile the module as other functions in the
module have calls to a database and I get an error message of "Wrong number
of arguments or invalid property assignment" and the word Application
highlighted (in the Conn.Open Application line below).

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Application("RascalBookings_ConnectionString")

This code works well if incorporated int he asp page but it will not compile
as part of a module and presumably will therefore not work (but I cannot
test yet because of Problem 1).

Can you advise how to fix this. I presume I need a Dim statement referring
to the Application but do not know what form this should take.

Any help on these two problems would be appreciated.

Cheers...Alan




.

Quantcast