RE: [Reactor for CF] Iterator Order Question

Doug Hughes Tue, 11 Jul 2006 06:35:37 -0700

Beth,

Sorry, Reactor can’t do this.

However, you might be able to replace the field with an _expression_ and then sort by the field…

Doug

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Beth Bowden
Sent: Tuesday, July 11, 2006 9:21 AM
To: [email protected]
Subject: Re: [Reactor for CF] Iterator Order Question

I have a column that is alphanumeric. It usually contains numbers but may have a suffix. So the following contents:

1
10
10a
2b

should be ordered like this:

1
2b
10
10a

I use this clause to do so:

TO_CHAR( TRANSLATE( tab.col,'ABCDEFGHIJKLMNOPQRSTUVWXYZ ',' '), '999999') DESC,
TRANSLATE( tab.col,'1234567890',' ' )

On 7/11/06, Teddy Payne <[EMAIL PROTECTED]> wrote:

Can you give an example of what you are trying to achieve?

On 7/11/06, Beth Bowden < [EMAIL PROTECTED]> wrote:

I need to sort an iterator by an _expression_. Is there a way to do this?

TIA.

Beth

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

--
<cf_payne />

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

RE: [Reactor for CF] Iterator Order Question

Reply via email to