Using PI and ArcCos in SQL line

Hi folks,
I'm really stumped and need help .. on my ASP page, I'm running a line of SQL that has a calculation in it. In this calculation, I use PI and ARCCOS functions.

As my database is in Access, I have a module that has these functions detailed, but when I go to run the ASP page, it doesn't recognise these functions.

What can I do to get around this problem? Sorry if this is an obvious one, but i'm a newbie so please forgive me :o)

re: Using PI and ArcCos in SQL line

One way would be to build a generic query object in the Access database, which can see your functions, and call that in your page, limiting its results.

"SELECT * FROM qrySomeQuery WHERE something = somethingelse"

Or you could import your functions across.

Gaz.

re: Using PI and ArcCos in SQL line

Hey, I tried importing the functions in, but I'm not sure that I did it right (I just pasted the functions in from the module and referenced them in the sql query, but it still didn't recognise it)?

re: Using PI and ArcCos in SQL line

Have you tried the first approach?

Gaz.

re: Using PI and ArcCos in SQL line

Yeah, it didn't work .. it still didn't recognise the functions when accessing the page.

re: Using PI and ArcCos in SQL line

Oh well, I guess you'll have to do the work on the recordset then!

Gaz.

re: Using PI and ArcCos in SQL line

There's no work to be done on the recordset. Don't worry about it, I'll figure it out.

re: Using PI and ArcCos in SQL line

I think you miss understand me.

Instead of doing:

You do:

Make sense?