Apostrophe in Queries

Results 1 to 2 of 2

Thread: Apostrophe in Queries

  1. #1
    Join Date
    Dec 1969

    Default Apostrophe in Queries

    I looked at the FAQ <BR>http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=27<BR><BR>and see how to set up the script to change input from a form that contains double (") with a single (&#039;) but is there any way to actually put in the double marks (")?<BR><BR>The form input I am trying to create will occasionally have dimensions in it so change 3" to 3&#039; changes the dimensions of something from 3 inches to 3 feet.

  2. #2
    Join Date
    Dec 1969

    Default You misread that COMPLETELY...

    You do NOT need to or want to change a quote " character to an apostrophe! Just leave all " marks alone!<BR><BR>Read that FAQ again: The problem is with &#039; marks that are in your data. And you must double them up IN ORDER TO END UP WITH ONLY ONE IN THE FINAL DATA.<BR><BR>Read the FAQ again...do not read into it what is not there.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts