Hello

  I have following sql statement saved as a query.
  SELECT * FROM tbl_booking WHERE func_compare_date([pick_up_date]) =TRUE;

   Where func_compare_date is a function created uder module tab in microsoft access.

  This query is working perfectly while executing it from Access itself.

  But when I tried to call this from ASP ( code as under) it showed me following error.

  func_compare_date is undefined..

ASP Code :
        Dim cmd_bookings
    set cmd_bookings=Server.CreateObject("ADODB.Command")
    set cmd_bookings.ActiveConnection=cnn_chauffeurcar
    cmd_bookings.CommandType=adcmdStoredProc
    cmd_bookings.CommandText="qry_pick_up_date"
    Set rst_bookings = cmd_bookings.Execute()



Shibu

__________________
Shibu Narayanan
Software Associates

Hi Shibu,

Check out this thread. A similar problem has been discussed there.

undefined function

BTW, what is that function doing in turn? Why not do that within ASP, instead of using a function within that query?

Cheers!

_________________________
- Vijay G
Strive for Perfection