Day of Week in Access

[Scott Brady]

I'm trying to extract rows from an Access database where the row's "date_transaction" field is a specific numeric day of the week (1-7).

Here's my query:
SELECT COUNT(t.transaction_id) AS numAttendees, t.date_transaction FROM practice_transactionTbl t, transaction_typeTbl tt
WHERE t.transaction_type_id = tt.transaction_type_id AND
DatePart("w",t.date_transaction) IN ( 3,5,7 ) GROUP BY t.date_transaction ORDER BY t.date_transaction ASC

Within Access, that query runs fine.  In ColdFusion MX (6.1), however, I get a DB error ("Too few parameters").  

Does the JDBC driver not recognize the DatePart function for Access?  If not, any ideas on how to get around it?

Scott

---------------------------
Scott Brady
http://www.scottbrady.net/

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---