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> > > > ---------------------------------- > > > > > > > > > > > > ______________________________________________________________________ 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
