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

[Alan Wolfe]

how many locations do you have stored and why are you storing them if i may ask?   and what is it you are trying to present to the user?   That is, if this doesnt give away too much info that you dont want to share :P   just sometimes, good solutions to problems can be found be examining the situation as a whole, instead of just looking at the brick wall of the dead end you may currently be at you know? ----- 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 is only the altitude and longitude. So, no more informations. The rest is calculated.   rs   daniel     ----- Original Message ----- From: Alan Wolfe To: [EMAIL PROTECTED] Sent: Sunday, October 31, 2004 7:40 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 the formula-text in the database?  If the database gave you the answer instead 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 on... Distance Calculation is no problem, that works. Here the formula: <@CALC EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 'Adressen.Geo_Breite'>)*COS(<@COLUMN 'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388" Precision="1">   The problem what I have is:   1) To do a sort of the result (OK, I can do it in a array, but this need to much RAM [more as 2500 records, nearly 50x on one time])   2) To do a search in a specified area like "show me all points near x miles(km).   One way what make sense is to store the formula in the database, but - if i make a assign to a variable, then Witango store only the result. What I like to store is the formula-text:     Second problem: I can't do a sort on the stored formula (Sort command: <@COLUMN 'Adressen.formel' Encoding="Metahtml">)   Any Successions ?   THX for help   regards Daniel   ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf