Results 1 to 2 of 2

Thread: crozer

  1. #1
    crozer Guest

    Default crozer

    I need to pass a long text box to a stored procedure that contains quotes how do I pass the data and tell the SQL server that the quotes are to be treated as text and not an end of the varialbe

  2. #2
    David Ashworth Guest

    Default RE: crozer

    convert your &#039; to &#039;&#039; (2 apostrophes)<BR><BR>you can try... Replace(szString, "&#039;", "&#039;&#039;")<BR><BR>i think that should work, where szString is the text in your text box.

Posting Permissions

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