Database Discussion - posting unformatted text to DB

Print Page | Close Window

posting unformatted text to DB

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6478
Printed Date: 28 March 2026 at 4:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: posting unformatted text to DB

Posted By: gr8indianbear
Subject: posting unformatted text to DB
Date Posted: 16 October 2003 at 12:15pm

I want to make an web-based editing tool that a user with little HTML knowledge can edit a Memo field in Access. I want it so that they wold jsut be able to edit in a Textbox. They could make paragraphs and the HTML tags wold be added when they post. How do i do this? i've been looking through the Web wiz codes but cant find anything simpler than the WYSIWYG Editor, and that is too complex. I dont need any formatting other than the paragraphs.

Replies:

Posted By: MorningZ
Date Posted: 16 October 2003 at 8:55pm

uhh.. you would just store whatever the person types in exactly as they typed it

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: gr8indianbear
Date Posted: 16 October 2003 at 9:26pm

the problem im having is that when i do that and then read it back out onto a webpage it needs the html tags. will a regular Textbox put the tags in the access field? here's an example

here's what it shold look like:

This is a paragraph and it goes on and on and on and on and on and on and on and on. that's on paragraph.

This is the second paragraph, it goes on too, and it's seperate form the other paragraph.

but this is how it comes out:

This is a paragraph and it goes on and on and on and on and on and on and on and on. that's on paragraph.This is the second paragraph, it goes on too, and it's seperate form the other paragraph.

hope that makes it clear? =/

Posted By: MorningZ
Date Posted: 16 October 2003 at 9:47pm

when you display the text... replace vbCrlf with <br />, like:

Response.Write Replace(TheTextFieldFromTheDB, vbCrlf, "<br />")

-------------
Contribute to the working anarchy we fondly call the Internet