I'm trying to generate some static pages of a directory listing, one 
page for each letter A through Z.  I intend to generate these pages 
once each month on my development system, then FTP to a non-
CF enabled Website.  Below is some code showing how I'm trying 
(unsuccessfully) to do it.

CFSCHEDULE is not creating the static pages, and CFLOOP is 
not creating distinct pages, but one page with all listings on it.  
Can this even be done?

application.cfm:
-----------------------------------------
<cfparam name = application.TYPEBUS default = "">
<cfparam name = application.DIRNAME default = "">
<cfparam name = application.letter default = "a">

schedule.cfm:
<cfschedule action="UPDATE"
            task="MakePage" 
            operation="HTTPRequest"
            url="http://64.248.98.147/Stage/lacanadaflintridge"
            startdate="#DateFormat(Now())#"
            starttime="#TimeFormat(Now())#"
            interval="1"
            resolveurl="No"
            publish="Yes"
            file="diralpha_#application.letter#.html"
            path="\\Imedcoserver\IMEDCO 
C\InetPub\wwwroot\Stage\lacanadaflintridge\alpha">
<cfinclude template="topalpha.cfm">

topalpha.cfm:
-----------------------------------------
<cfloop index="letter" list="a,b,c">
cfquery name="diralpha" datasource="#DSN#" dbtype="ODBC">
select  BUSACCES.TYPEBUS,
BUSACCES.DIRNAME
from BUSACCES
where DIRNAME like '#letter#%'
order by DIRNAME;
</cfquery>
<cfset application.letter = letter>
<body>
<cfinclude template="alpha.cfm">
<cfschedule action="RUN" task="MakePage"> 
</cfloop>
</body>

alpha.cfm:
-----------------------------------------
(this template simply formats the output of the directory)


Thanks very much for any help!


--

Ron Connelly
The Internet:Works
[EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to