The correct solution to this problem is...
In MSSQL Server when you want all of the orders from today:
<cfset variables.Today = CreateDate(year(NOW()), month(NOW()),
day(NOW()))>
<cfquery>
SELECT *
FROM ORDERS
WHERE OrderDate BETWEEN
<cfqueryparam cfsqltype="cf_sql_timestamp" value="#CreateODBCDateTime(
variables.Today 00:00:01)#">
AND
<cfqueryparam cfsqltype="cf_sql_timestamp" value="#CreateODBCDateTime(
variables.Today 23:59:59)#">
</cfquery>
HTH
--
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250528
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
