' - these lovely things

Results 1 to 2 of 2

Thread: ' - these lovely things

  1. #1
    Join Date
    Dec 1969

    Default ' - these lovely things

    IF i have a text box and someone types in something with &#039 I get errors. the error message is:<BR><BR>Line 1: Incorrect syntax near &#039s&#039. <BR><BR>How am I supposed to say in my code to accept &#039 if a user puts it in?<BR><BR>I am using SQL Server<BR><BR>Matt

  2. #2
    JW van Domselaar Guest

    Default RE: ' - these lovely things

    Before you do an update or insert, replace every single quote with two single quotes with replace("string with some &#039 in it","&#039", "&#039&#039")<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