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>
> > ----------------------------------
> >
> >
> >
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
