Wrox Programmer Forums
|
Classic ASP Professional For advanced coder questions in ASP 3. 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 Professional 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 January 15th, 2006, 11:53 PM
Registered User
 
Join Date: Jan 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Adding line feeds and apostrophes to a database


I created a database in ACCESS of two fields, one a text field and the other a memo field. I can add to the database all right until I try to add a line feed or an apostrophe.

The code is:
   SQL2 = "INSERT INTO tblSignData (nametbl, comtbl) VALUES ('" + myname + "',"
   SQL2 = SQL2 + "'" + mycomment + "');"
   adoConn.Execute(SQL2)
   adoConn.close

Is there another way of writing this code so the LF and apostrohpes are accepted?

Riffaff

 
Old January 21st, 2006, 05:40 PM
Authorized User
 
Join Date: Jun 2003
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default

did u try using the html version or double quote them?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Rendering new line feeds in browsers mangaroo XSLT 4 March 6th, 2007 09:17 PM
Adding a blank line to a memo field Scootterp Access VBA 3 October 31st, 2006 01:15 PM
apostrophes or quotation marks crmpicco Javascript 6 March 21st, 2006 09:01 AM
issues with apostrophes darkhalf Classic ASP Databases 3 December 22nd, 2004 02:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.