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.Knowledge Base
- Breadrumbs:
Microsoft OLE DB Provider for SQL Server (0x80040E14) Incorrect syntax near
- 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.
Share With Friends (Updated 6-8-2010)
Recent Articles
All Topics
- Coming Soon - Knowledge Exchange
Trending Articles
- Microsoft VBScript runtime error '800a0046' Permission denied FileSystemObject 24695
- Microsoft OLE DB Provider for SQL Server error '80040e57' String or binary data would be truncated. or The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. 21297
- ADODB.Parameters error '800a0e7c' Parameter object is improperly defined 19544
- After Effects warning: Audio conforming failed for the following file .cfa. Perhaps due to disk space 17785
- The backup set holds a backup of a database other than the existing 16825