Syntax error over single quote (')

Results 1 to 2 of 2

Thread: Syntax error over single quote (')

  1. #1
    Join Date
    Dec 1969

    Default Syntax error over single quote (')

    Hello,<BR><BR>I recieve the following error:<BR>Microsoft JET Database Engine error &#039;80040e14&#039;<BR><BR>Syntax error (missing operator) in query expression &#039;&#039;trial with an apostrophe on President&#039;s tour&#039;,&#039;August&#039;,&#039;2004&#039;)&#0 39;.<BR><BR>/ahec/model_reporting/process_monthly_summary.asp, line 45<BR><BR>I am using a variation on the batch inserts article found at 4GuysFromRolla. It seems that this text area field gets hung up if someone enters a single quote in the text area. <BR><BR>Any ideas how to catch this? Thanks

  2. #2
    Join Date
    Dec 1969

    Default category Databases, Errors

    Click on link to ASPFAQs at center above.<BR><BR>Look in category noted in subject.<BR><BR>Find your FAQ.<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