Using PI and ArcCos in SQL line

[kliq316]

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)

[GazMathias]

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.

[kliq316]

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)?

[GazMathias]

@kliq316
Have you tried the first approach?

Gaz.

[kliq316]

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

[GazMathias]

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

Gaz.

[kliq316]

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

[GazMathias]

I think you miss understand me.

Instead of doing:

SELECT somefield, myfunction(someotherfield) As something FROM sometable

You do:

SELECT somefield, someotherfield FROM table
...
Response.Write myfunction(rs("someotherfield"))
 

Make sense?