SQL problem

Results 1 to 4 of 4

Thread: SQL problem

  1. #1
    bobby Guest

    Default SQL problem

    I have a form that does update to a database. Here is a line of sql that I use to update a memo field called Narr in the database:<BR><BR>SQLStmt = SQLstmt & "Narr = &#039;" & form_Narr & "&#039;"<BR><BR>The problem is that if the user puts an apostrophe in the Memo field, it returns an error. How can I set it so that they can process the field as a block or something?

  2. #2
    Join Date
    Dec 1969

    Default Replace

    name = Replace( Request.Form("name"), "&#039;", "&#039;&#039;" )

  3. #3
    bobby Guest

    Default Thanks Doug D <eop>


  4. #4
    Join Date
    Dec 1969

    Default RE: Replace

    Hey doug thanks! I came here with the same problem as bobby and did a search for apostrophe and your post came up. Thanks much for the snippet!<BR><BR>Jim

Posting Permissions

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