I'll try to be more helpful than Alan's dismissive response was.

I guess you need to re-position your expectations that "3.6.1" is a
number, in which case numeric sorting is inappropriate.  Similarly,
the common notion of alphabetical sorting won't help you because in a
list of 3.6.1, 3.6.5 and 3.6.10, the ordering should be as per how
I've listed it, whereas alpha would do it: 3.6.1, 3.6.10, 3.6.5.

Basically what you have is a custom (if not uncommon) sort
requirement, which means you're gonna have to roll your own sort
solution.  My approach would be to write a generic sort routine (using
a quicksort or merge sort... unless there's a better option these
days... I haven't done this sort of thing since being @ polytech in
the early 90s), into which you pass a callback function which does
whatever comparison you need to decide that "3.6.10" is "greater than"
"3.6.1", but "less than" "3.6.5".  Then your sort algorithm calls that
when needing to do these comparisons.  If you google "sort algorithm
callback" you'll get a bunch of stuff better explaining what I'm on
about.  probably not in CF, but it's the technique that's important,
not the actual code.

HTH.

--
Adam


On Sep 23, 12:01 am, tjones <[email protected]> wrote:
> Thanks, for all of the additional testing and comments.
>
> So with all of this info in hand, have any other people had this type
> of an issue and if so how was it solved?
>
> Thanks,
> tom

-- 
Open BlueDragon Public Mailing List
 http://www.openbluedragon.org/   http://twitter.com/OpenBlueDragon
 official manual: http://www.openbluedragon.org/manual/
 Ready2Run CFML http://www.openbluedragon.org/openbdjam/

 mailing list - http://groups.google.com/group/openbd?hl=en

Reply via email to