I'm trying to use functions in a QoQ to parse out some text. I have a directory that has folders of images in it. What I want is a simple QoQ that will extract the directory and filename from a CFDIRECTORY tag into another query. My plan is to put this resulting query into the application scope since this data is relatively static and time consuming to generate.
<CFSET ThePath = "#APPLICATION.RootServerPath#doc\ToolImages\Photos"> <cfdirectory directory ="#ThePath#" action="list" name="ImageList" filter="*.jpg" recurse = "yes" type="all"> <cfquery dbtype="query" name="myList"> SELECT name as imageName, replace(directory,"#ThePath#","") as imageDir FROM ImageList </cfquery> myList would be set as an application scope variable in the next stages of this. I'll use it in another QoQ. Thanks! Warren Koch ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4