ADO and '

Results 1 to 2 of 2

Thread: ADO and '

  1. #1
    Join Date
    Dec 1969

    Default ADO and '

    Hi,<BR><BR>I wrote a parameter stored procedure, which insert text into a field.<BR><BR>Using ASP which graps an input type = text and pass it to this stored procedure. However, when there is an "&#039" (single bracket) in this text field it gives me an error. So I had to write a function to replace "&#039" with "&#039&#039". Is there another way to avoid this function? using command object? but I also like to execute more then one stored procedures on one ASP as well.<BR><BR>Please help!

  2. #2
    jason Guest

    Default RE: ADO and '

    there&#039s no way around it - it&#039s a part of SQL - single quotes delimit strings, therefore it will always interpret them as such - so yup, you&#039re stuck with it<BR><BR>jason<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