string problem

Results 1 to 2 of 2

Thread: string problem

  1. #1
    Join Date
    Dec 1969

    Default string problem

    I have a form for adding records. When you submit a new taskcard, it adds just fine. But it will not allow you to add an apostrophe in the field because it messes up the sql statement, which depends on the requested taskcard. Any code to get around this? The sql statement is like this...<BR><BR>sql="select * from table where taskcard = &#039;" & request("taskcard") & "&#039;"<BR>of course if you add and apostrophe in on the form field for taskcard it throws off the sql statement and produces an error.

  2. #2
    Join Date
    Dec 1969

    Default RE: string problem

Posting Permissions

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