Try this

<CFPARAM NAME="VARIABLES.DIRECTORYLIST" DEFAULT="">
<CFDIRECTORY ACTION="LIST" DIRECTORY="D:\BOOKS" NAME="DirList" SORT="name
ASC">
<CFLOOP QUERY="DirList">
        <CFIF TYPE IS "DIR" AND FINDNOCASE('.',NAME) IS 0>
                <CFSET VARIABLES.DIRECTORYLIST=VARIABLES.DIRECTORYLIST&','&NAME>
        </CFIF>
</CFLOOP>
<CFSET
VARIABLES.DIRECTORYLIST=RIGHT(VARIABLES.DIRECTORYLIST,LEN(DIRECTORYLIST)-1)>
<CFOUTPUT>#DIRECTORYLIST#</CFOUTPUT>

============================================
Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL
============================================

-----Original Message-----
From: FlashGuy [mailto:flashmx@;rogers.com]
Sent: Monday, November 04, 2002 11:24 AM
To: CF-Talk
Subject: Replace in string


Hi,

I need to output the results as a comma-delimited string. An example of the
output from the below code would be like:

dir1 dir2 dir3 dir4 dir5

I would like to have:

dir1,dir2,dir3,dir4,dir5

Whats wrong with my below syntax?


<cfdirectory action="LIST" directory="d:\books" name="DirList" sort="name
ASC">

<cfoutput query="DirList">
  <cfif left(DirList.name,1) neq ".">
    #ListGetAt(Replace(DirList.name," ",",","ALL"),1,',')#
  </cfif>
</cfoutput>




---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Reply via email to