CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    52
  • Date Created
    Tuesday, November 23, 2010
  • This Article Has been Viewed
    1751 times
  • Short Desc
    When writing your Parameters Queries out within your SQL Statement, you might leave an invalid character behind.
  • Details
    When using Parameters or simple ASP SQL Statements, you might end of leaving behind a character that was once used in the statement that is now replaced by a ? or @ symbol.
    If this happens, you will receive the following error.

     
    Microsoft JET Database Engine (0x80040E14)
    Syntax error (missing operator) in query expression '(((tblTalent.ProfessionServiceID)=?) AND ((tblAccounts.AccountNumber)=1?) AND ((tblTalent.TalentID)=?))'.
    /IDResults.asp, line 92
  • Recreate Issue
    To recreate this issue, leave an invalid character in your SQL Statement
    Example
    <%
    (((tblTalent.ProfessionServiceID)=?) AND ((tblAccounts.AccountNumber)=1?) AND ((tblTalent.TalentID)=?))
    %>


    As you can see in the above example, there is the # 1 left in the code
    <%
    (tblAccounts.AccountNumber)=1?)
    %>
  • Resolve Issue
    To correct this issue, remove the invalid character, in this case, it is the # 1

    <%
    (((tblTalent.ProfessionServiceID)=?) AND ((tblAccounts.AccountNumber)=?) AND ((tblTalent.TalentID)=?))
    %>


Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles