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
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
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
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
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
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
[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
7 matches
Mail list logo