Storing formatted data.

Posted on 2005-05-14
Last Modified: 2013-12-24
I'd like some suggestions/thoughts/discussions on this. I've implemented similar projects before with various results, and wonder if there is a better way.

I'm building a small knowledge base for a small company where policies, procedures, etc. can be stored. The content will be entered by clerical staff with no HTML experience, and I want to keep training needs as low as possible.

Each record will have the usual fields, including the title (the question), datestamp, various levels of classification, etc. The body of the question (the answer), will be a field of text type (I'm using MS SQL) for easy searching and indexing using Verity. I'm using ColdFusion for all administration and viewing pages.

But that body content needs to be formatted. I don't want to ask the staff to learn HTML so they can write the document using basic HTML tags (p, br, b, i, etc.) and I don't want to have the content be so bare that I just save plain text and then process it before displaying it on the page. I don't want messy HTML pasted in from Word or the like...
Question by:lavachickie
    LVL 9

    Accepted Solution

    It sounds like you're in need of a WYSIWYG editor (what you see is what you get) -- it allows easy-to-use page formatting for text that builds the HTML for the user. I personally use HTMLArea3, but unfortunately, support for it is dying. There is a really nice directory of editors at the following URL:

    If you want HTMLArea3, you can still get it here:


    LVL 35

    Expert Comment

    This is a nice tag:

    Free and creates a text area that looks a lot like Microsoft Word - so if you users can use that they should be able to use this.

    They have a demo (caution the demo loads very slowly on their site) - it doesn't run that slow on actual pages and once you customize it:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
    Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now