Web Wiz Rich Text Editor (RTE) - using apostrophe and ampersand

Print Page | Close Window

using apostrophe and ampersand

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Rich Text Editor (RTE)
Forum Description: Support forum for the Web Wiz Rich Text Editor (RTE).
URL: https://forums.webwiz.net/forum_posts.asp?TID=20006
Printed Date: 29 March 2026 at 2:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: using apostrophe and ampersand

Posted By: salsan
Subject: using apostrophe and ampersand
Date Posted: 23 May 2006 at 6:52pm

i am saving the data from the RTE to database. If I use apostrophe (') or (&) ampersand, i got page not found error. Any idea??? why and how can I solve this is issue.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 23 May 2006 at 7:31pm

Are you sure this is a page not found error and not a 500 internal server error?

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: salsan
Date Posted: 24 May 2006 at 7:34am

yes, you are right, it gives

HTTP 500 - Internal server error

Any idea y?

Posted By: WebWiz-Bruce
Date Posted: 24 May 2006 at 8:29am

If you turn off friendly HTTP errors in IE you will get a more accurate error message telling what the problem is.

But my guess is that you have written your own code to place the data into a database and you haven't parsed the data to make it SQL safe.

Quotes need to be escaped by replacing them with double quotes, or using &quote; if not the SQL to enter the data into the database will be malformed.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting