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
