ASP Database Formatting

[prez]

I cant seem to populate the database so that it shows the formatting such as paragraphs in the text. This is my source code in the attachment.

What i want is that the output in title, introduction,.. etc. to have paragraphs, but instead with the codes above, the paragraphs disappears.

Can someone help me out? Thanks

[PCBrandon]

I'm a bit confused on what you want, but I think I have an idea.

If you are wanting to have it so that when you display the data from the database it is formatted like what it was when you entered it then you need to perform a replace statement.

Example:
Enter into database:

Blah

Blah


Blah

and have it output exactly like that:

Blah

Blah


Blah

To do that you need to replace the carriage returns to a paragraph. It keeps parsing my paragraph tag, so I replaced the P with an X. Just replace the X with a p. Also, can anyone tell me how to not make it parse HTML tags? I thought wrapping it in code tags would do that.

SourceOfText = Replace(SourceOfText, vbCrlf, "<X>")

BEFORE you enter it into the database.

[prez]

thanks for your reply.

You mean i have to insert the codings before i sent it/store it in the database? but im using the textarea tag and when i check it in the database, it has paragraphs. only when i call it from database using the
<%=strname %> that i get the whole text without paragraphs. If i insert the string into a textarea, it has paragraphs.

so how do i exactly do it? You can check my source code to see what im talking bout. :P

thanks

[PCBrandon]

Can you post the code for the file you use to create the reports (where you enter the information into the database)?

Brandon

[prez]

hmm.. i dont have the codes with me right now. but i used textarea tags for users to enter the text and then store it in the database. In the database the paragraphs are there but not when i request for it in another page.

[PCBrandon]

I'll need to see the code for that page to help you anymore. I still think you need to do what I suggested in my first post, but I want to see your code to tell you exactly where to place it and see if it works.

Brandon

[prez]

thanks. i will post it in a few days time cos i will be away

[prez]

this is the page that you wanted.

[prez]

i finally found out how to solve it. All i need to do is insert this in the main page

sqlReportID = Replace(sqlReportID ,vbcrlf,"
")

and walla... thanks for your help.

but now i cant insert any word that has an aprostophe. if i do, then i get an error

Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression

how do i solve this? is it because of the way i code it or is there solutions to this problem? thanks