RE: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-11-01 Thread Ben Johansen
PROTECTED] Subject: RE: Witango-Talk: Distance Calculations - Sort on..., search on... Let me clarify, I didnt mean just doing the formula in script, I meant to process the array and sort it within server side _javascript_. Ben From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Sunday

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-11-01 Thread [EMAIL PROTECTED]
tober 31, 2004 11:18 AM Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search on... Alan, stored is only the altitude and longitude. So, no more informations. The rest is calculated. rs daniel --

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-11-01 Thread [EMAIL PROTECTED]
, 2004 9:34 PM Subject: RE: Witango-Talk: Distance Calculations - Sort on..., search on... Have you thought of sever side scripting? I did a similar test a while back where the array was passed into server side _javascript_ and it did the calcs very fast @SCRIPT EXPR

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-11-01 Thread [EMAIL PROTECTED]
, November 01, 2004 4:04 PM Subject: RE: Witango-Talk: Distance Calculations - Sort on..., search on... Ok, I am at the computer that had my test file. Here it is Ben Johansen - http://www.pcforge.comAuthorized Witango MDaemon ResellerAvailable for Witango

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-11-01 Thread Alan Wolfe
actual distances you could just square root them at that time - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 01, 2004 7:33 AM Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search on... Jonah, to avoid a lot

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-10-31 Thread Alan Wolfe
of the formula? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 31, 2004 10:22 AM Subject: Witango-Talk: Distance Calculations - Sort on..., search on... Distance Calculation is no problem, that works. Here the formula

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-10-31 Thread [EMAIL PROTECTED]
of the formula, would you still need the text of the formula? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 31, 2004 10:22 AM Subject: Witango-Talk: Distance Calculations - Sort on..., search

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-10-31 Thread Alan Wolfe
PM Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search on... Hi Richard, How is the list of locations generated and what do they represent? how are you using them in your program? Just wondering, why is it you want to store

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-10-31 Thread Alan Wolfe
iving away "proprietary secrets" or not to do so :P - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 31, 2004 11:18 AM Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search on... Alan, stored

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-10-31 Thread Jonah Simpson
Hey Daniel! What database are you using? I know MySQL can do the trigonometric functions in a select statement and you could order your result from the database... Doing trig functions is pretty gross efficiency wise. You might want to store some of the functions that aren't going to change in

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-10-31 Thread Alan Wolfe
Thats a neat idea having the lookup tables, very very cool idea (: - Original Message - From: Jonah Simpson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 31, 2004 12:10 PM Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search on... Hey Daniel! What

RE: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-10-31 Thread Ben Johansen
'Adressen.Geo_Breite')*COS(@COLUMN 'Adressen.Geo_laenge'-@@User$Laenge_1)) * 6378,388 Just a thought Ben From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 10:23 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Distance Calculations - Sort on..., search

RE: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-10-31 Thread Ben Johansen
: Distance Calculations - Sort on..., search on... Have you thought of sever side scripting? I did a similar test a while back where the array was passed into server side _javascript_ and it did the calcs very fast @SCRIPT EXPR=ACOS(SIN(@@User$Breite_1)*SIN(@COLUMN 'Adressen.Geo_Breite