Passing ' to SQL Database

Results 1 to 2 of 2

Thread: Passing ' to SQL Database

  1. #1
    Join Date
    Dec 1969

    Default Passing ' to SQL Database

    Hi,<BR><BR>I am having a problem with passing single quotes text to an SQL database from ASP. Here is a sample of my code.<BR><BR>sqltext = "UPDATE Ticket SET temp = &#039;Remarkssp tableoption&#039;s can be used&#039; WHERE TicketID =&#039;10000001&#039;<BR><BR>The problem is that the script bombs when a &#039; is included in the passed text. For example tableoption&#039;s.<BR><BR>Any help is appreciated<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, Queries

    &nbsp;<BR>The link to the ASPFAQs is at the top right of this page and of most every page on this site.<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