At 1:17 PM -0800 1/3/01, paul smith wrote:
>Yes, I agree. CFAS's query caching is very handy.
>
>I've considered using the database approach for client websites.
>Do you include HTML or CFML in the text stored in the database table?
>Do you have any suggestions of do's & don't's?
>
I've done both on the same web site:
Supplier & Product Listings:
----------------------------
No cfml or html in the db, all formatting and markup provided bt the
CF program which retrieves and presents the data,
News and Article listings:
-------------------------
Storing markup (html) in the db as part of the content offers the
most flexibility especially if you have tables, lists images.
Here, you might use a combination approach:
intermixed markup and data for most of the text
placeholders in the text for images (where the images URLs and and
characteristics are in he db.
The program substitutes the URL & size oarams for the placeholders
You might take the same approach for other db fields (Title, Author, etc.)
HTH
Dick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
