You can do it with functions and variables, but not with CF tags.
> Hi
>
> My question. Is it possible to store the contents of a CF template in a SQL7
> table, insert that into another template with a query and for it to work? If
> it does, are there any restictions.
>
> Thanks for any simple answers
> Mike
> ----------------------------------------------------
> NZERN National Office
> Mail: PO Box 9000, Christchurch
> (03) 338-5451
> E-mail: [EMAIL PROTECTED]
> http://www.bush.org.nz
> ----------------------------------------------------
>
> Example
> -----------------------------------
> page.cfm
>
> <!--- Search Engine --->
> <CFQUERY name="Template" datasource="DataSQL" dbtype="ODBC">
> SELECT Template
> FROM tblTemplate
> WHERE (NavItemID = #NavItemID#)
> </CFQUERY>
>
> <!DOCTYPE html public "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML>
> <HEAD>
> <TITLE>[NZERN] #Navitem#</TITLE>
> </HEAD>
> <BODY bgcolor="#FFFFFF">
>
> <!--TOP PANEL-->
>
> <CFINCLUDE template="_top.cfm">
> <TABLE width="600" border="0" cellpadding="0" cellspacing="0"
> bgcolor="99CC99">
> <TR>
> <TD valign="top">
> <CFOUTPUT query="Template">#Template#</CFOUTPUT>
> </TD>
> </TR>
> </TABLE><!--FOOTER-->
> <CFINCLUDE template="_footer.cfm">
> </BODY>
> </HTML>
> --------------------
> Contents of #Template# when NavItemID=15
>
> <CFQUERY name="NZ_Nursery" datasource="DataSQL" dbtype="ODBC">
> SELECT
> NursID,
> NursTitle
> FROM tblNursery
> ORDER BY NursTitle
> </CFQUERY>
> <!--- --->
> <CFOUTPUT><TABLE width="430" border="0" cellpadding="0" cellspacing="0"
> bgcolor="##FFFFFF">
> <TR>
> <TD valign="top">
> <P align="center"> <BR><FONT face="Verdana" size="4"><B>Native Plant
> Nurseries A to Z</P>
> <HR>
> <P></B></FONT>
> <TD>
> <TR>
> <TD>
> <TABLE width="428" border="0" cellpadding="0" cellspacing="0"
> bgcolor="##FFFFFF">
> <TR>
> <TD>
>
> <FONT face="Arial narrow">
> <CFLoop query="NZ_Nursery">
> <A href="http://www.bush.org.nz/nursery/#NursID#.html";
> target="_top">#NursTitle#</A><BR>
> </CFLoop>
> </FONT>
>
> </TD>
> </TR>
> </TABLE>
> </TD>
> </TR>
> </TABLE>
> </CFOUTPUT>
> ----------------------------------
>
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
