At 05:44 PM 12/19/2000 -0500, you wrote:
>Well I can tell you right off the bat that this:
><cfloop query ="ProdCatDESC">
> <cfoutput query="ProdCatDESC" >
> #ProductCategoryDescShort#, #ProductCategoryID#
> </cfoutput>
>
><snip>
>
></cfloop>
>
>Is not helping. You are asking it to loop over the query and then for every
>single iteration of the loop, process the entire query in the cfoutput.
Thanks for your speedy responses folks...
You were right...watching the files being generated showing up in explorer
showed that every time it generated a new category it would also
re-generate all the ones it had previously processed...so the first file it
wrote to would end up being written 15 times...the second 14 etc...no
wonder it was taking too long...
I tried Mike's idea to remove cfloop altogether and just enclose it in a
cfoutput
<!---begin looping thru product categories--->
<cfset dirlocation = "C:\storeTEMP\store_ca\">
<cfoutput query="ProdCatDESC">
#ProductCategoryDescShort#, #ProductCategoryID#
<cfhttp
url="http://127.0.0.1/gen_cat_pages.cfm?MIDResults=1&CatResults=#ProductCate
goryID#&dirlocation"
method="get" resolveurl="false" UserAgent="Mozilla/4.0 (compatible; MSIE
5.01; Windows NT 5.0)">
</CFHTTP>
<CFFILE action="write"
file="#Dirlocation#\#ProductCategoryDescShort#.html"
output="#CFHTTP.FileContent#">
</cfoutput>
Which is MUCH faster...took only about 7 minutes to generate the 15 pages....
Thanks again....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
