Ah, I see the appeal of that approach.
Off the top of my head the way I would destgn the db is with 2 tables
Parent
Create Table Article
ArticleID (PK)
Title
DateCreated
Author
.
.
.
Abstract (text)
Child
Create Table ArticlePage
ArticlePageID (PK)
ArtickeID (FK references Article)
PageNumber
PageContent (text)
Or, you could denormalize, and include the first page content in the
Article record.
Each page probably would be stored as a separate html page entity.
But, if you can standardize the content format (maybe several
formats) you may be able to store the content without he html.
Then I would store the entire content in a single record.
Then you could dynamically generate page chunks (supply the html)
based on the configuration of the user's browser or by user-specified
options.
Searching would be much easier.
BTW, the salon site appears to have simple formatting requirements.
Simple enough that the content need not include any html.
The Salon site could sure improve performance and reduce bandwith by
using frames & popups... a natural for this type of site.
HTH
Dick
At 1:00 PM -0800 9/16/00, Chris Lott wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Thanks for the tips. I'm still leaning towards some way of splitting
>the content because I want to increase readability on the site for
>longer pieces by breaking the stories up in to "pages", ala Salon
>magazine or the like. Primarily because the site is designed for
>online reading...
>
>I will also provide a single page download for printing/reading
>offline/reading that combines the pages, but for reading online I
>would LIKE to try to find some middle ground between providing just
>an intro and the whole text.
>
>Of course, maybe I shouldn't be bothering with that approach, but as
>an online reader I know *I* appreciate stories that are "chunked"
>
>c
>
>-----BEGIN PGP SIGNATURE-----
>Version: PGP 6.5.8 for message encryption and authentication: USE PGP!
>Comment: PGP KeyID: 0x51046CFD
>
>iQA/AwUBOcPfataLYehRBGz9EQL43gCfVj0Rrm8ARFlLRe3tkAVOdbpLLQcAn1nX
>ghNkiMbjHE6IoWpHBa6pdQ2W
>=qiS+
>-----END PGP SIGNATURE-----
>
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
