With queryparam you don't need the createODBCDate() function:
SELECT blah....
FROM tblCalendar
WHERE EventDate BETWEEN <cfqueryparam cfsqltype="CF_SQL_DATE"
value="#form.someStartDate#" />
AND <cfqueryparam cfsqltype="CF_SQL_DATE" value="#form.someEndDate#" />
Also, note that in SQL Server, the assumption is midnight, so that the end
date is really the day before, so you could do this before your query:
<cfset endDate = dateAdd("d", 1, form.someEndDate) />
and then use that in the query:
...
AND <cfqueryparam cfsqltype="CF_SQL_DATE" value="#endDate#" />
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329230
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
