Here's how I usually do it. My structure looks like this:
- Issue
- Article
- Paragraph 1
- image 1
- image 2
- image 3
- Paragraph 2
and so on. You can easily have an Issue, Article, Paragraph and Image tab
le.
It runs nice and fast, and as a bonus you can reuse images...
-----Original Message-----
From: James [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 5:08 PM
To: CF-Talk
Subject: Magazines, Article and Diagrams.
Hi guys,
I am setting up a site for a magazine.
Each article needs to go on-line, most articles have
got diagrams or images contained in them.
I am a bit stuck on trying to figure out the best way to structure this.
The 2 options I have come up with are:
1. Have a table called IMAGES which would store the reference to the
diagram, image or table and relate that to the article number. From there
I can loop through the query and output the related images at the bottom
of the article.
2. Have a static page that I manually create for each article and then us
ing
cfinclude pull the content into the page by way of a reference ID that I
store
in the db.
would like to hear any opinions if anyone has done anything like this
before.
cheers
James.
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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
