GROUP BY RIGHT()?

2007-07-23 Thread Robert Rawlins - Think Blue
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

RE: GROUP BY RIGHT()?

2007-07-23 Thread Ben Nadel
www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 11:11 AM To: CF-Talk Subject: GROUP BY RIGHT()? Hello Guys, I've got a query which returns a load of file names which

Re: GROUP BY RIGHT()?

2007-07-23 Thread Charlie Griefer
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

Re: GROUP BY RIGHT()?

2007-07-23 Thread Brian Kotek
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

RE: GROUP BY RIGHT()?

2007-07-23 Thread Robert Rawlins - Think Blue
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

RE: GROUP BY RIGHT()?

2007-07-23 Thread Adrian Lynch
An ORDER BY? Adrian -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:45 To: CF-Talk Subject: RE: GROUP BY RIGHT()? Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie

Re: GROUP BY RIGHT()?

2007-07-23 Thread Charlie Griefer
[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