syntax error(')

Results 1 to 3 of 3

Thread: syntax error(')

  1. #1
    cheril Guest

    Default syntax error(')

    When I try to insert in the database a string from a text area which has a apostrophe(eg d&#039souza) it gives me a syntax error.<BR>How do I allow avoid this error I want the user to be able to give apostrophe.<BR>Thanx for reading.

  2. #2
    Join Date
    Dec 1969

    Default RE: syntax error(')

    Before you execute the sql statement replace the &#039 with &#039&#039 (double apostrophe) i.e.<BR><BR>replace(textfield, "&#039", "&#039&#039")

  3. #3
    ines Guest

    Default RE: syntax error(')

    replace the single quote with a double quote for example;<BR><BR>replace(trim(request.form("txtText ")), "&#039", "&#039&#039")<BR><BR>and your problem will be solved,<BR><BR>bye

Posting Permissions

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