It does sound a bit clumsy. I guess the question to the original poster is what type of CF code is he going to store. If its not tags, then no problem. And placing it in the DB simply involves escaping the pound signs (using ##) so that the function/variable is not evaluated yet.
> I meant "you can't process the code you will need to build a template in > a database". But that sounded kinda clumsy. > > > -----Original Message----- > > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] > > Sent: Monday, 24 June 2002 4:24 p.m. > > To: CF-Talk > > Subject: Re: templates held in database > > > > > > This is a date: #now()#. it can also look like this > > #dateformat(now())# > > The above is a string saved in a DB. Lets say its saved as a > > field teststring. We can do this to evaluate it. > > #Evaluate('"'&teststring&'"')# > > Basically, any functions, udfs and variables can be evaluated > > in this way. > > > > 1. #Evaluate('"'&teststring&'"')# > > 2. #Evaluate("This is a date: #now()#. it can also look like > > this #dateformat(now())#")# > > 3. #Evaluate("This is a date: {ts '2002-06-24 00:21:04'}. it > > can also look like this 24-Jun-02")# > > 4. This is a date: {ts '2002-06-24 00:21:04'}. it can also > > look like this 24-Jun-02 > > > > > 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> > > > > ---------------------------------- > > > > > > > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
