tGirl, I realize that I have no idea what your experience level is or what the requirements of your project are, but I would caution that the idea of a single page site where all the HTML is stored in a database seems like a very bad idea on the surface for the majority of Web sites. I've done a lot of work with content management systems, including extensive work with Macromedia Spectra, and I can tell you that going down this path is filled with problems that few developers anticipate unless they have prior experience developing CMSs.
The author of that article suggests that storing the HTML in a database somehow increases the speed and security of the site, but I would disagree with that assertion. The author doesn't back up those claims in any way. It is obvious from reading the article that the person who wrote it does not have significant experience coding so I would discourage anyone from following any of the advice in it. -Mike Chabot On Sun, Jan 18, 2009 at 10:05 AM, Torrent Girl <torrentg...@gmail.com> wrote: > Thanks > > I am creating a content management system so I don't want to strip the HTML. > I am also creating a "one page site" and got the suggestion to add it as > plain text from this tut: > > http://www.easycfm.com/coldfusion/forums/viewmessages.cfm?Forum=10&Topic=12469 > > > > >>HTML is just text, so you store it in any of the text column types >>(varchar, nvarchar, text, ntext). >> >>I have a comment form in a site that lets people add HTML markup to >>the comment. I take this text, clean up the HTML, and put it into two >>columns, a comment_html column and a comment_plaintext column that has >>the HTML markup removed. Both columns are of type varchar(max). The >>reason to store one comment twice is that not everything supports >>HTML, such as SQL Server Reporting Services and third-party grid >>controls. Storing a plain text version also allows for a >>left(comment,100) type of function to show a preview of a lengthy >>comment and could help with a text search feature. Instead of >>stripping out the HTML tags for every data retrieval, I strip them out >>once during the insert, which increases the size of the database but >>speeds up data retrieval. >> >>The next most common method of storing HTML I believe is to store it >>as XML. SQL Server 2005 introduced powerful and fast XML support, >>although I would suspect this is overkill for what you are trying to >>accomplish. >> >>I hope that helps, >>Mike Chabot >> >> >>> tGirl > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
