Help: Replacing string with template result

[susan10]

Im new to Coldfusion, and here is what i would like to do:

I'm using a html-editor on one cfm-page, and saving the text in a database:

--mytext written i the html-editor ----------------------

Nunc libero ligula volutpat ac aliquet id laoreet ac lacus.


[peopleoutofoffi ce]


In dictum tincidunt turpis. Morbi sodales, justo ut posuere viverra
, mi turpis egestas nunc, ac consequat leo elit vitae pede.

---------------------------------------------------------

And showing the text entered in the editor on an other page.

<!-- viewcontent.cfm -->
 
<cfquery name="pagecontent" datasource="myDB">
    Select id, mytext from contenttable
    Where id = 5
</cfquery>
 
 
<cfoutput query="pagecontent">#mytext#</cfoutput>
 

... that's very simple!


But, that i want to do is replacing the string; [peopleoutofoffi ce] in #mytest# with the result of an other cfm template, like this:

<CFOUTPUT>#replace(mytext,"[peopleoutofoffice]", GetOutOfOffice.cfm)#</CFOUTPUT>
 
 
<!-- GetOutOfOffice.cfm -->
 
<cfquery name="OutOfOffice" datasource="myDB">
    Select firstname, surname, status from persontable
    Where status is "out"
</cfquery>
 
 
<table>
<tr>
    <td>The following people is out of office</td>
</tr>
 
<cfoutput query="OutOfOffice">
<tr>
    <td>#firstname# #surname#</td>
</tr>
</cfoutput>
 
</table>
 

----------------------------------------------------------

How do i solve this problem?

[acoder]

Welcome to TSDN!

Interesting problem. I don't know if it's even possible, so how about setting a Coldfusion variable to the string within the template, including that template within the page and then using the variable instead of the template name in your replace function?