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:
>>Development (Web and Desktop) >> Web Development >> ASP (Active Server Pages)
Microsoft JET Database Engine error '80040e14' Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
99
Date Created
Wednesday, February 9, 2011
This Article Has been Viewed
2791 times
Short Desc
When you create your SQL Statements for DELETE, INSERT, PROCEDURE, SELECT, or UPDATE, you may not spell the name correctly, in this case, this error will happen.
Details
When you write your SQL Statement, make sure that you spell the name correctly, if not, you will receive the following error message.

Microsoft JET Database Engine error '80040e14'
Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
/4.asp, line 19

When the SQL Statement is run, it will look to see if you have provided the appropriate code that triggers the Query to be performed. If this code is not found, it will return the 80040e14 error message as demostrated above.
Recreate Issue
To recreate this issue:

<%
sql.commandtext="Sekect column1, column2 from table2"
%>

In the above code, we have misspelled the name: SELECT
Instead, we have it spelling out as: SEKECT
Knowing that the K and L are side by side, this at times will happen.
Resolve Issue
To correct this issue:

<%
sql.commandtext="Select column1, column2 from table2"
%>

As you can see in the code above, we have spelled the name correctly, so that script will now function properly and the trigger will be fired.

All Topics