> I have a query to which I add and populate a column. I would like
> to sort the query on the new column. Is it possible? I have tried
> dumping the query into an array in order to use ArraySort() but 
> ArraySort() seems to only work with one-dimensional arrays (lists) 
> and this has to be two-dimensional. BTW we are using ColdFusion 4.52.

hi david

if you have

       select A, B, C
          from yourTable
       order by A

and now you want to add a new column D and sort on it, why not just

       select A, B, C, D
          from yourTable
       order by D

obviously, there's something i don't understand...

rudy

-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "rudy" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)

Reply via email to