As an aside, once you do this (go from .cfm pages to .html) your server's ability to process page traffic is going tto go thru the roof, and since you have taken CF and your db out of the picture, page response times will go way down as well.
I loop over my db like so (very pseudo-code :-) ): <cfquery name=myquery> myfile.primarykey myfile.year myfile.make myfile.model </cfquery> <cfloop over myquery> <cfset mystaticfilename=myquery.year&"_"&myquery.make&"_"&myquery.model&".html" <cfhttp file="http://mydomain/myfile.cfm?primarykey=#myquery.primarykey# <cffile write filename> </cfloop> I actually keep a file designed specially for static page generation and do some stuff to make sure that page is never called directly by a bot or something. -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:259824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
