This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I'm trying to retrieve data from an ACCESS database. I have an sql statement that looks like String query = "select * from AuditTrail where CAST(LOGDATE AS DATE) = current_date"; I get the following error
detailMessage= "[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'cast(logdate as Date)'."