I have the following sql that i'm sending through an objconn.execute statement in asp
select orderid,[orderdate],[customerid],[internalcomments],[howpaid],[ordertotal],[status] from orders where orderdate>='11/2/2006' and orderdate<='28/2/2006'
not if i copy and paste directly into access then it works but if I run it through my webpage using asp I get an error -
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
any idea what could be causing this?