I have this query which runs fine directly within Access:
SELECT
u.preferred_name + ' ' + u.last_name + '''s Birthday' AS eventString,
'Birthday' AS eventType,
false AS publicView,
u.birthday AS eventDate
FROM
usersTbl u
WHERE
Month(u.birthday) = 11
ORDER BY
u.birthday
The query is supposed to get all of the users who have a birthday in a
given month (November, in this case). In Access, it returns 3 rows.
Running it in a CF page returns no rows. I'm guessing that it's
something to do with the Month() function in Access. I've tried using
"DatePart" in the SQL instead, but that just throws an error in CF.
SELECT
u.preferred_name + ' ' + u.last_name + '''s Birthday' AS eventString, '
Birthday' AS eventType,
false AS publicView,
birthday AS eventDate
FROM
usersTbl u
WHERE
DatePart("m",u.birthday) = 11
ORDER BY
u.birthday
Is there some other Access workaround I could use?
This is on MX 6.1 on Win2k in a hosted environment (so I have to use
whatever Access driver the host uses).
Thanks!
Scott
--
---------------------------
Scott Brady
http://www.scottbrady.net/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
