sneakyimp
08-14-2004, 06:06 PM
hi!
I've written a macro in Access to calculate the great circle distance between two points on the earth's surface. can i use this function in an ASP query somehow? my function is called GreatCircleDistance...i would LOVE to be able to write a query like this:
SELECT t1.email FROM MailingList as t1, Zip as t2 WHERE t1.zip=t2.zip and GreatCircleDistance(2.064701, 0.5896872, t1.longitude, t1.latitude) < 50;
IF this possible, it is critical that it work on my webserver! I'm beginning work on an existing website that runs on a windows platform. the database is an Access MDB file and the server is using the Microsoft Jet Database Engine. the database interface code looke like this:
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("../data/lustra.mdb")
conn.Mode = 3
conn.Open
Set rs = Conn.Execute("SELECT * FROM MailingList;", recordsaffected)
Any help would be much appreciated...i'm very new to asp and access/jet
I've written a macro in Access to calculate the great circle distance between two points on the earth's surface. can i use this function in an ASP query somehow? my function is called GreatCircleDistance...i would LOVE to be able to write a query like this:
SELECT t1.email FROM MailingList as t1, Zip as t2 WHERE t1.zip=t2.zip and GreatCircleDistance(2.064701, 0.5896872, t1.longitude, t1.latitude) < 50;
IF this possible, it is critical that it work on my webserver! I'm beginning work on an existing website that runs on a windows platform. the database is an Access MDB file and the server is using the Microsoft Jet Database Engine. the database interface code looke like this:
set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("../data/lustra.mdb")
conn.Mode = 3
conn.Open
Set rs = Conn.Execute("SELECT * FROM MailingList;", recordsaffected)
Any help would be much appreciated...i'm very new to asp and access/jet