convert .cfm to .htm 1

[hpvic03]

I have a page that loads data from a specific database row based on a url variable (i.e.

http://www.mypage.com?id=5

pulls up row 5). I want to convert the html that is outputted by the server into its own specific page such as

http://www.mypage.com/row5.htm

. Is there any way to do this (besides manual copy and paste)?

Thanks ahead of time!

 

[cfStarlight]

You could use cfhttp to grab the page content and cffile to save the content as an .html page.

 

[hpvic03]

excellent... i'll see if I can make it work

 

[hpvic03]

Ok cfhttp was all I needed - you can add file and path attributes and it will save it for you. Cool! Thanks starlight.

 

[cfStarlight]

Glad its working for ya' !

 

[Sarky78]

Just to throw my 10p into the equation.

If you are already generating the page, and don't actually want to use the cfm page within your site then you could just wrap the whole of your cfm page in a cfsavecontent, then write this out to a file, it will be quicker than cfhttp as it doesn't need to make an http connection for every page.

the code would be something like this:

<cfquery ... name="qryData">
select id.....
from your_table
where id = #url.id#
</cfquery>

<cfsavecontent variable="flat_file">
  all your output here
</cfsavecontent>

<cffile action="write" file="#ExpandPath('./html/')#row_#URL.ID#.htm" output="#variables.flat_file#">

you could generate all of the files that you want by having a loop of all of the id's around the above block like this:

<!--- get all of the data from the database you need --->
<cfquery .... name="qryAllData">
  select All fields you need
  FROM your_table
</cfquery>

<!--- loop over that query --->
<cfloop query="qryAllData">
  <!--- perform a query of queries to get the current row we want --->
  <cfquery dbtype="Query" name="qryData">
    select id.....
    from your_table
    where id = #qryAllData.id#
  </cfquery>

  <!--- save the content into vbl --->
  <cfsavecontent variable="flat_file">
    all your output here
  </cfsavecontent>

  <!--- write the content to a file --->
  <cffile action="write" file="#ExpandPath('./html/')#row_#qryAllData.ID#.htm" output="#variables.flat_file#">
</cfloop>

this could then be run as a scheduled task whenever you like

Hope this helps!

Tony