update form

Results 1 to 3 of 3

Thread: update form

  1. #1
    Join Date
    Dec 1969

    Default update form

    I have made an update form, when I write a word with an apostroph in a textfield I get the following error:<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near &#039;s&#039;.<BR>/Test/admin/Update2.asp, line 56<BR><BR>It updates my database fine when i write words without apostrophes.<BR><BR><BR>

  2. #2
    Eddie Campbell Guest

    Default Read the FAQ's


  3. #3
    Join Date
    Dec 1969

    Default RE: update form

    try:<BR><BR>searchtxt = Replace(Request.form("searchtxt"), "&#039;", "&#039;&#039;") <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