How do you store formatted text to be displayed!

[stuart1231]

Hi please can someone help.

Im developing a dynamic website and all is well, but i want to be able to
store all the text somehow on the database, e.g. like most nearly all dynamic
website on the net.

Heres a page similar:
[url]http://www.thenetprofits.co.uk/coldfusion/faq/topic.cfm?TopicID=9[/url]

The topic.cfm must be a template but the TopicID changes the whole formatted
text not just a single varible (as i have previously done)

I am a beginner incase its a really stupid question.

Basically can i stored a premade page with formatted text and picutures and
use coldfusion and access database to work as the template.

How is the pages stored

Any help would be greatly appreciated!

Stuart

[Ultrashock]

create the form and type in the text formatted how you want it in the textarea.
When you submit it to the database, the database willl save how you
formatted/entered it. It's how you display that stored text that may be a bit
tricky.

If you DO NOT want to maintain the formatting, you can just query the database
and output the data like such:

#query.text#

If you DO want to maintain the formatting, ColdFusion provides at least two
options:
Option #1

#ParagraphFormat(query.text)#

Option #2

<cfset TextVariable = "#Replace(query.text, Chr(10), "<br />", "ALL")#">
#TextVariable#

Option 1 and 2 are similar, however I find option #2 better in that option #1
is not XHTML compliant since it uses <p> tags which breaks the w3c standard.
You'll also find that the <p> tag will also leave an unformattable gap at the
end of the formatted text which is quite annoying. Therefore I personally
stick with option #2 as much as possible.

Hope this helps.