Thats 400 cf content templates replacing 50,000 static web pages. There are another 200 CF tempates as well. Coldfusion has been our salvation. It really is great. The SQL 7 database sitting behind it has 370 tables, another 400 GIS data tables to add later this year.
I'm teaching myself as I go. I'm looking for ways to make this website (with 200 applications accessable to members) managable. At the Macromedia MX launch in Christchurch today, I became convinced to add fusebox 2 by talking to Matthew Walker (contributor to CFTalk). Mike ---------------------------------------------------- NZERN National Office Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz ---------------------------------------------------- It sounds as if you don't need a database-driven site. I see no reason to 'build' 400 separate / independent pages just to store the data in a database. If lots of the data is similar, and you only have to build 10 or 20 templates, that might be a different story. Are these 400 pages of data unique? Are they related in some way that would give you benefits of using a database? At 05:12 PM 6/24/2002 +1200, you wrote: >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# > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ---------------------------------- > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
