It is tags. Perhaps there is another way to approach this. The website uses a standard CF template that includes 3 other templates using CFInclude (top, footer, bar) plus one with the content that is always different. The Content template querys are different, layout is different, some are lists, other based on a row in table. As Matthew said I could put all the content templates in a folder and reference them by templateID. I have 400 such content templates, so I'm trying to figure out a way to keep things manageable.
Any advice is really welcome Mike ---------------------------------------------------- NZERN National Office Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz ---------------------------------------------------- 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> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > bgcolor="99CC99"> > > > > > > > > > > > > #Tem plate# > > > > > > > > > > > > > > > > > > > > > > > > > > > > -------------------- > > > > Contents of #Template# when NavItemID=15 > > > > > > > > > > > > SELECT > > > > NursID, > > > > NursTitle > > > > FROM tblNursery > > > > ORDER BY NursTitle > > > > > > > > > > > > > > > > cellspacing="0" > > > > bgcolor="##FFFFFF"> > > > > > > > > > > > > > > > > size="4">Native Plant > > > > Nurseries A to Z > > > > -------------------------------------------------------------------------- > > > > > > > > > > > > > > > > > > > > > > cellspacing="0" > > > > bgcolor="##FFFFFF"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > target="_top">#NursTitle# > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ---------------------------------- > > > > > > > > > > > > > > > > > > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
