That will work fine if you are not executing any CF on your pages, just writing the content of your db to disk. If you are though you would want to use CFHTTP. That will execute any CF on the page and then you can use CFFILE to write the resulting html to disk.
Another cool thing about CFHTTP is it will give you an exact replica of the page as it is viewed by an end user. Using the below method, it will have an extra <table> wrapped around it. That may not be a problem for you though. I guess ultimately the method you use depends on how the database-driven site in question is implemented, and what your end goals are. -- Josh > Id's do something like this where you just write files somewhere on > your server after saving the data in a cfsavecontent > > <cfloop query "rsQuery"> > > <CFSET File = ""> > <CFFILE Action="Write" File=thefile#rsQuery.RecordID#.html" > Output="#File#"> > > <cfsavecontent variable="TheFile"> > > <table> > <tr><td> > #rsQueryGOODS# > </td></tr> > </table> > </cfsavecontent> > > <cffile action="APPEND" File=thefile#rsQuery.RecordID#.html" > output="#TheFile# " addnewline="Yes"> > > </cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259803 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

