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 OLE DB Provider for SQL Server (0x80040E14) Incorrect syntax near

  • 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:
    60
  • Date Created
    Wednesday, December 1, 2010
  • This Article Has been Viewed
    1628 times
  • Short Desc
    When creating your SQL Statement to make a double Query, you may forget to add in the AND or OR between your Columns.
  • Details
    When you create your Select Statement to make a Query, sometimes you may forget to add in the AND or OR statement between the 2 Columns that are being Queried.
    If this happens, you will receive the following error.

     
    Microsoft OLE DB Provider for SQL Server (0x80040E14)
    Incorrect syntax near 'email'.
    /Reg.asp, line 47
  • Recreate Issue
    to recreate this error.

    <%
    getSQLtemp.CommandText = "SELECT tempid, Email, PromoID FROM UserTemp WHERE tempid=? email=?"
    %>


    As you can see in the code above, there is not AND between the tempid=? and email=?
  • Resolve Issue
    To correct this issue and compile through with your code.

    <%
    getSQLtemp.CommandText = "SELECT tempid, Email, PromoID FROM UserTemp WHERE tempid=? and email=?"
    %>


    As you can see, we have added in the AND between our 2 columns.