You can't process CF code directly out of a database. What you can do is read it out of the db, write it to a temporary file, then cfinclude the temporary file, then delete the temporary file. Another simpler approach would be to store the meta data in the db (if there is any, e.g. template ID, template name, description, etc.) and store the template itself in a templates folder as [template id].cfm . Or you could store the template in the db and whenever it is edited automatically update the file copy.
> -----Original Message----- > From: NZERN National Office [mailto:[EMAIL PROTECTED]] > Sent: Monday, 24 June 2002 3:37 p.m. > To: CF-Talk > Subject: templates held in database > > > 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
