did you ORDER BY appropriately? you need to ORDER BY the column(s) on which you're grouping.
On 7/23/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > 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:284370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4