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

[[EMAIL PROTECTED]]

Thank you Ben ! This will work on the sort problem, but not on the search...   BTW.: Do you know a way to store the formula directly in the database (and not only the result) ?   rs   Daniel ----- Original Message ----- From: Ben Johansen To: [EMAIL PROTECTED] Sent: Monday, 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.com Authorized Witango & MDaemon Reseller Available for Witango Developement From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 3:01 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Distance Calculations - Sort on..., search on...   Let me clarify, I didn�t 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, October 31, 2004 1:34 PM To: [EMAIL PROTECTED] 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="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�>   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 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf