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 (0x80040E14) Missing ), ], or Item in query expression

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

Article ID:
80
Date Created
Monday, December 27, 2010
This Article Has been Viewed
1674 times
Short Desc
A SQL Statement with starting Parentheses must have a closing Parentheses as well.
Details
When you create a Query that has a ( Parentheses to start, you must made sure that you close it, same goes for a Bracker [ as well.
If not, you will receive the following error.

Microsoft JET Database Engine (0x80040E14)
Missing ), ], or Item in query expression '(((qryUnilever_.Warehouse)=Name) AND Users.uid=?'.
/Inventory.asp, line 22
Recreate Issue
To recreate this error.

<%
sql.commandtext="select col1, col2 from table1 where (col1=? and col2=?"
%>

As you can see in the above Query Statement, we left out the ending ) Parentheses
Resolve Issue
To correctly write out this Query Statement.

<%
sql.commandtext="select col1, col2 from table1 where (col1=? and col2=?)"
%>

As you can see in the above Query Statement, we added in the ending ) Parentheses, unlike the Recreate where we had left it out.

All Topics