Apostrophe Dilemma - Please Help

Results 1 to 2 of 2

Thread: Apostrophe Dilemma - Please Help

  1. #1
    Join Date
    Dec 1969
    Posts
    33

    Default Apostrophe Dilemma - Please Help

    When I insert an apostrophe into a text box as part of a word eg. "Juliet&#039s" an SQL error occurs. Can anyone tell me how I can get around this. <BR><BR>Thanks

  2. #2
    Jose Fernandez Guest

    Default RE: Apostrophe Dilemma - Please Help

    Piece of cake:<BR>Replace every single &#039 with a double &#039&#039 before your sql statement, like this:<BR>variable=Replace(variable,"&#039","&#039& #039")<BR><BR>Also check the FAQ, there are zillion answers for this problem...<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
  •