Ok, I am at the computer that had my test file.
Here it is
Ben Johansen - http://www.pcforge.com From: Ben Johansen
[mailto:[EMAIL PROTECTED]
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]
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]
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
________________________________________________________________________ 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 |
ScriptTest.taf
Description: Binary data
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf