A
Alan
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
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