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.
[peopleoutofoffice]
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; [peopleoutofoffice] 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?