INSERT INTO with the famous '

Results 1 to 4 of 4

Thread: INSERT INTO with the famous '

  1. #1
    Jean-Luc Guest

    Default INSERT INTO with the famous '

    I remember seing a piece of code allowing me to track and replace the famous &#039 prior to insert in a table.<BR><BR>Any idea where ?

  2. #2
    Join Date
    Dec 1969
    Posts
    94

    Default RE: INSERT INTO with the famous '

    Check out:<BR><BR>http://asp-help.com/database/database.asp<BR><BR>I think it has what you are looking for.<BR><BR>Drew

  3. #3
    Earl Guest

    Default RE: INSERT INTO with the famous '

    SQL interprets &#039&#039 as &#039. So, you can use VBScript to change your query so that all &#039 are replaced with &#039&#039. Here is a line of code which will do that (assuming strSomething is the string that you need to replace &#039 to &#039&#039):<BR><BR>strSomething = Replace(strSomething,"&#039","&#039&#039")<BR><BR> This replaces all instances of "&#039" in strSomething with "&#039&#039"

  4. #4
    Jean-Luc Guest

    Default RE: INSERT INTO with the famous '

    Looks like, thanks


Posting Permissions

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