Column D was coming from a verity search. It was the score field. The other columns came from a products table. I ended up by adding all the data I wanted to the Cfindex tag and using the Cfsearch to get everything I needed in one fell swoop. I still wish that you could sort multidimensional arrays though.
David Boehm Website & Database Management Product Ordering On-Line M&T Printing Group 907 Frederick St. Kitchener, ON Canada N2B 2B9 (519) 571-0101 Fax (519) 571-0129 [EMAIL PROTECTED] -----Original Message----- From: rudy [mailto:[EMAIL PROTECTED]] Sent: March 12, 2002 6:50 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] Sorting queries and arrays > 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) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Dave Boehm" <[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)
