Form to db Error on " ' "

Wrox Programmer Forums

		Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Form to db Error on " ' "

Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

December 3rd, 2005, 06:35 AM

merchafil

merchafil is offline

Registered User

Join Date: Dec 2005

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Form to db Error on " ' "

Hi

I am suing a form to database which works fine but when a user types "blar blar ' blar " the code breaks because the " ' " is used by the code - please can someone tell me how to fix this problem?

Murray

Old

December 5th, 2005, 07:34 AM

ChrisScott ChrisScott is offline

ChrisScott is offline

Friend of Wrox

Join Date: Jul 2003

Posts: 683

Thanks: 0

Thanked 1 Time in 1 Post

Default

Hi Murray,

Just replace all occurrences of a single quote with two single quotes.

HTH,

Chris

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
submit data to db with html form....(help)	PeterJB	Beginning PHP	2	August 6th, 2006 12:07 AM
Update db showing data in form	Chamaeleon	PHP How-To	2	January 26th, 2006 05:55 PM
DB CR Balance in Form	mateenmohd	Access	4	October 12th, 2004 11:32 PM