I am trying to do a query of a SQL Server query with ColdFusion 8 but I am
having trouble getting it to filter on dates. I have tried a few different
things, but nothing seems to work. It doesn't throw an error, it just doesn't
select records that I think it should find. I want it to get records that have
a date/time of a given day. My latest iteration is using BETWEEN, but its not
working either:
<CFQUERY name="getTaskQuery" dbtype="query">
SELECT *
FROM toDoQuery
WHERE reminderDate between <cfqueryparam cfsqltype="cf_sql_date"
value="#createodbcdatetime(createDateTime(year(now()),month(now()),day(now()),0,0,0))#">
and <cfqueryparam cfsqltype="cf_sql_date"
value="#createodbcdatetime(createDateTime(year(now()),month(now()),day(now()),11,59,59))#">
</CFQUERY>
Thank you
---------------------------------
Don't let your dream ride pass you by. Make it a reality with Yahoo! Autos.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290877
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
