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> ---------------------------------- ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
