an asp function

Results 1 to 2 of 2

Thread: an asp function

  1. #1
    Join Date
    Dec 1969

    Default an asp function

    I built a database with only two fields.One of them is a memo type. I have a form that submits data to both fields. I am getting errors in the memo type field. I think whenever there is a single quote &#039 in the text, it gives me a syntax error. <BR>is there any function that goes through the text and fix that error or anything ican do about this. I know the memo type has a bog range of chars.<BR>Thank you<BR>here is my email <BR>Thanks again

  2. #2
    Fr0st Guest

    Default RE: an asp function

    Yes, there is an easy way to accomplish this:<BR>Let&#039s say you are passing the variable varExample to your database for Insert into the memo field. All you have to do is use varExample = Replace(varExample, "&#039", "&#039&#039") before your insert statment. This will eliminate any single quotes from your entry and allow you to process the Insert statement.<BR><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