hi everyone!
can anyone help me in sorting an array which contains date values.I
remember this question being asked before and forgot the solution.I went and
searched the archives in Witango and found only this which was of little
help.
I am afraid if there exist any solution for sorting a date column in an
array using the <@SORT > command through some technique.
If any other technique which is quick enough its most welcome.
The problem that I have is that I have few other cols like names and
numerics which is also to be sorted based on the clients action.
thanx
Prasad R
Tango Lead
OfficeTiger Database Systems India Pvt. Ltd.
mailto:[EMAIL PROTECTED]
http://www.officetiger.com
##########################################################################
Author: Mailing List Subscriptions
Posted: 14/08/1999 12:25:27 AM
Yesterday, I mentioned that the only problem with @MAP is that it
ONLY RETURNS A ONE COLUMN ARRAY (vs. updating a desired column in an
array).
Depending upon record size and the likely number to be returned in a
given foundset, we often put the resultSet into an Array and serve
run the summary list functions from it. This provides all sorts of
advantages.
One of the biggest is providing clickable column headers to sort
ascending/descending. Since the sort is done in RAM, it's lightening
fast.
HOWEVER, @SORT still doesn't accommodate dates nor times (was really
hoping for Tango 3.6) which is a real drag since many lists include
dates.
This is one area we have very little luck coming up with a realistic
work around.
@MAP would be great if one could assign an entire row or column at a time:
<@ASSIGN local$myArray[*,aDate] '<@MAP local$myArray
value="#aDate" true="<@DATETOSECS DATE=#aDate>">'>
The above says to "Update" column "aDate" with aDate converted to
seconds, which would then sort numerically just fine.
The other option would be to do an @ADDCOLS with the result of the
@MAP to add a new column with the seconds and sort by it.
Unfortunately, @ADDCOLS and @DELCOLS hasn't been seen as a priority
for the development team (maybe a bunch of emails to the product
manager would help?)
Thus, we're stuck.
Failing...
1) @SORT supporting Dates
2) @ASSIGN supporting rows/columns at a time
3) @ADDCOLS, @DELCOLS support (this would be SO useful!)
The only way I can think of to sort a date/time in an array is to do
a @ROWS loop and recreate the array. UGH! On arrays of any
significant size this is really slow and consumes memory.
There's got to be a better way!?!
__________________________________________
Chris OgdenInfoMatters, Inc.
441/236-8183 http://InfoMatters.com
Dynamic Website Design, Creation, Implementation,
Promotion, Maintenance, and Software
############################################################################
###########3
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
