Also what about adding a field called level. This would be used to display
the query in a format of 

Category
   subcategory
        subsubcategory

Level would be a number like 0,1,2,3 then we would have a cfloop where it
would do something like level*1 to get the spacing.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-----Original Message-----
From: Mike Craig [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 7:18 AM
To: CF_OpenSource
Subject: RE: doing a content mangement system, very simple need some
ideas


Categories and Sub-Categories (depending on how you want to customize
your upload/download directories and display pages for the uploaded
content) should probably have (or at least mine have in similar
situations):

Unique Id

Short Description (for display)

Long Description (for help)

Sub-Directory where any files may be stored

An Access "CODE", usually 20 characters in length tops that offers quick
identification for custom queries later (its easier to remember
BODPROFILE than Category 21).

A Bit field to turn the category/sub-category off for maintenance needs
(precautionary)

A Discontinue Date (so you can permanently disable the type of upload
document if it becomes obsolete but retain the linked information to
your master upload tables).

And Finally perhaps an administrative code or access level so that you
can integrate security (preventing some categories/sub-categories from
now showing as viable upload or download options when searching or view
the "board of directors" page).

There are a few of my ideas and how I have accomplished this in the
past.  I'm sure there are plenty others.

-----Original Message-----
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 25, 2002 12:00 PM
To: CF_OpenSource
Subject: doing a content mangement system, very simple need some ideas

Ok I have a project that needs to content management solution. I figured
since i have CoSmoS i will release the code as GPL once I am done with
it,
but anyways here is my problemo.

I am doing a website for a home owners association and it has to be
easy.

They want a place to put board of directors, links, upload documents,
edit
the front page, stuff like that.

The problem I am having is this, should I have categories, then
subcategories, should the subcategories have a definition of what they
are,
like a link, a file, or directory?

Anyone have some insight they can give me. It's gonna start out simple
then
get complicated eventually.

Robert Everland III
Dixon Ticonderoga


______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to