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



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284357
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to