You can use CFQueryParam on a query of queries.
...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 23, 2007 10:37 AM To: CF-Talk Subject: Re: Date < now() +1? It's on a Query of Queries, so no cfqueryparam - boooo... :( T On 23 May 2007, at 15:33, Ben Nadel wrote: > You should also check out CFQueryParam for timestamp in combo with > date > math: > > Date < <cfquaryparam value="#Fix( Now() + 1)#" > cfsqltype="CF_SQL_TIMESTAMP" /> > > The Now() + 1 will get you into tomorrow. > > The Fix() on that date will strip out the time and create an integer > date. > > The CFQueryParam will convert your integer back into a SQL date/time > stamp (with zeroed out time). > > This way has been awesome for me in the past. Here are some > potentially useful date posts: > > > http://www.bennadel.com/blog/226-ColdFusion-Date-Math-Faster-Than- > Date-M > ethods-And-Other-Date-Math-Ramblings.htm > > http://www.bennadel.com/blog/193-Adding-Numbers-To-Date-Time- > Values.htm > > http://www.bennadel.com/blog/150-Ask-Ben-Appending-Times-To-Date- > Time-Ob > jects.htm > > > ...................... > Ben Nadel > Certified Advanced ColdFusion MX7 Developer www.bennadel.com > > Need ColdFusion Help? > www.bennadel.com/ask-ben/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
