dealing with apostrophes

Results 1 to 5 of 5

Thread: dealing with apostrophes

  1. #1
    MG Guest

    Default dealing with apostrophes

    I have a form with textarea field. It calls a function with and insert statement into an SQL 7.0 table. Whenever there is an apostrophe&#039s in the text to be inserted, I get a "incorrect sytax error". How do I fix this. Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: dealing with apostrophes

    Double up your apostrophes...<BR><BR>value = replace (value, "&#039", "&#039&#039")

  3. #3
    MG Guest

    Default Thanks

    You never know when you are going to learn something new.

  4. #4
    Skippie Guest

    Default Another FAQ.

    Let&#039s take a poll. When is the next time this question will <BR>appear on this forum? <BR><BR>I&#039m voting for September 11th.<BR><BR>How about another poll? How many times will this question<BR>appear on this forum before Jan 1, 2001?<BR><BR>I&#039m voting for 50.<BR><BR>!!! CAST YOUR VOTES !!!<BR><BR>!!! THE WINNER TAKES ALL !!!<BR><BR><BR>-- Skippie

  5. #5
    Join Date
    Dec 1969

    Default Probably the MFAQ

    I&#039ll try 9/12/2000 and 51. I&#039m sure to beat you on one of those.

Posting Permissions

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