Results 1 to 2 of 2


  1. #1
    Join Date
    Dec 1969

    Default HELP PLEASE!

    I have a form where a user enters text to be inserted into a db field. The field is set to memo. The user entered text surrounded by double quotes. Then inside their text, they also have used single quotes. Later, when I go to their edit page where they can edit this info, because of the outside quotes around the string, it is screwing up the page. I have tried using the replace function like this.<BR><BR>text = replace(text,""","""")<BR><BR>but I get an unterminated string error. Can anyone help me figure out how to fix this problem? Thanks.

  2. #2
    Join Date
    Dec 1969

    Default Fun with quotes...

    You need:<BR><BR>text = Replace( text, """", """""" )<BR><BR>That&#039;s FOUR " marks in the first string and SIX in the second.<BR><BR>A *clearer* way to do that would be:<BR><BR>&#060;%<BR>QT = Chr(34) &#039; a single quote mark<BR>text = Replace( text, QT, QT & QT ) &#039; replace a single one with a pair<BR>%&#062;<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