Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that assuming the file extension is only 3 characters, however two file extensions with the same last 3 characters isn't all that likely.
Now, I'm having a little trouble with this group by: <cfoutput query="VARIABLES.Messages" group="type"> #VARIABLES.Messages.type# </cfoutput> For some reason it doesn't appear to group properly, either that or I'm forgetting how to use it properly :-D That code snippet outputs like this: Gif Jpg Gif Txt Gif Vcf See how it's not grouping the gifs properly? Any ideas what I'm missing? Thanks guys, Rob -----Original Message----- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:24 To: CF-Talk Subject: Re: GROUP BY RIGHT()? No, but you could select a column in your query that reads just the first 3 characters of the filename, give it a column alias, order by that column alias, and then use that in your cfoutput group attribute. Something like this (check your particular RDBMS for the Right() function or similar): select filename, right(filename, 3) as lastThreeFileName from my table order by lastThreeFileName <cfoutput group="lastThreeFileName"></cfoutput> On 7/23/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > > Hello Guys, > > > > I've got a query which returns a load of file names which I'm looking to > group by their extension. Is there any way to do this dynamically from the > name or do I have to make a separate column in the database? > > > > Can I do something like this: > > > > <cfoutput query="myquery" group="right(filename, 3)"> > > #myquery.filename# > > </cfoutput> > > > > Thanks guys for any help, first time I've done any cf in a while, things > are > feeling a little rusty. > > > > Rob > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4