calling sql function in asp

Dear all,

I have a vb function converting date and "time string" to a double:

Function MKDate(d , h )
MKDate = DateSerial(Year(d), Month(d), Day(d))
If (h > "") Then MKDate = MKDate + TimeSerial(CInt(mleft(h, 2)),
CInt(mright(h, 2)), 0)
End Function

If I set this function in a module, I can make
select dt, hour, mkdate(dt, hour)
from appointments
-> It works.

Now I want to use this in asp.

If I set functions in a module, I get an error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'MKDATE' in
expression.
/test/dossier.asp, line 221

I also inserted this function in the .asp file, it compiles but I get
the same run-time error.

Is it possible to call this vb function in sql?


Regards,
Alain

can you use variable in the date calculations and assign to the function at
the end

xundubay

"Alain Bourgeois" wrote:

>
> Dear all,
>
> I have a vb function converting date and "time string" to a double:
>
> Function MKDate(d , h )
> MKDate = DateSerial(Year(d), Month(d), Day(d))
> If (h > "") Then MKDate = MKDate + TimeSerial(CInt(mleft(h, 2)),
> CInt(mright(h, 2)), 0)
> End Function
>
> If I set this function in a module, I can make
> select dt, hour, mkdate(dt, hour)
> from appointments
> -> It works.
>
> Now I want to use this in asp.
>
> If I set functions in a module, I get an error:
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC Microsoft Access Driver] Undefined function 'MKDATE' in
> expression.
> /test/dossier.asp, line 221
>
> I also inserted this function in the .asp file, it compiles but I get
> the same run-time error.
>
> Is it possible to call this vb function in sql?
>
>
> Regards,
> Alain
>