Hi Bob
 
This is the Code I am using.
 
<cfdirectory action="LIST" directory="server/#directory#" name="repdir" sort="name DESC" filter="*.html">
<form name="report" method="post" action="display.cfm" target="_blank">
<input type="Hidden" name="directory" value="<cfoutput>#directory#</cfoutput>">
<select name="filename">
 <cfset var1 = "_">
 <cfset var2 = " ">
 <cfset var3 = ".html">
 <cfoutput>
  <cfloop query="repdir" startrow="1" endrow="20">
   <cfset dispname = #RemoveChars(repdir.name, 1, 6)#>
   <cfset dispnamefinal = #replace(dispname, var3, var2)#>
   <option value="#name#">#Replace(dispnamefinal, var1, var2, "all")#</option>
   <!--- <input type="Hidden" name="dispnamefinal" value="#dispnamefinal#"> --->
  </cfloop>
 </cfoutput>
 
 
The HTML documents are generated using Excel, there is tons of code but if you view them via the url they load fine.  Intermedia asked me to stop using this function as it is taxing the CPU.
 
Mike
----- Original Message -----
Sent: Tuesday, March 26, 2002 3:16 PM
Subject: Re: [CFTALKTor] CFdirectory

I haven't heard of that problem before.  Are you using a filter for your directory listing?  That might improve performance.  Do you have control over the creation of these html files?  If so, perhaps you could add an entry to a table whenever a file is created.  One other idea, but I imagine it would perform much worse that CFDirectory, would be to write a batch file that does a directory listing and pipes it to a file.  You could use CFEXECUTE to run the batch file and CFFILE to read it, but that is really just an insane workaround.  You really should be able to use CFDIRECTORY.
 
Do the hosts tell you that you shouldn't be using CFDIRECTORY?
 
Bob
----- Original Message -----
From: Mike
Sent: Wednesday, March 27, 2002 8:00 AM
Subject: [CFTALKTor] CFdirectory

Hello All,
 
I am having a problem with my hosting company (intermedia) while using CFDirectory.  I have a small application that reads html files that are created using excel and then send via FTP to a particular directory i.e. 1.html, 2.html etc.
 
These files are then shown in a combo box and launch in a new window.  I am getting timeouts and server errors.  Intermedia says that the CPU is peaking when ever I place a request like this.
 
I thought that intermedia was not able to handle this so I created a new account at crystal tech, but I am geting the same issues. 
 
Apparently CF directory is very taxing on a shared server, can anyone recommend a way to view these files in a combo box not using CFdirectory?
 
Thanks in Advance
 
Mike

Reply via email to