I use the following, if that helps...
<cfset future="#CreateODBCDateTime("#Now()#")#">
<cfparam name="futuredate" default="#DateAdd("ww",2,"#future#")#">
<cfset past ="#Now()#">
<cfparam name="pastdate" default="#DateAdd("ww",-2,"#past#")#">
-- snip ---
<cfquery name="diary" datasource="PS_Scheduler" username="gclsys"
password="bandana" >
select DateID,StartTime,EndTime,Activity,Description from Schedule where
ResourceID = '#id#' and
dateid > #pastdate# and
dateid < #futuredate#
order by DateID desc
</cfquery>
-----Original Message-----
From: Kevin Davis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 3:59 PM
To: CF-Talk
Subject: one hour query
Is it possible to write a query that retrieves data from the data source for
the last hour?
for Ex...
<CFQUERY name="name" datasource="#ds#">
Select * from tablename
where fieldname = fielddata
and createdate >= #Hour(Now())#
and createdate <= #Hour(Now()-1)#
</CFQUERY>
or something like that. (The above query doesn't seem to work for me.)
I have looked though the CF manuals, searched my email achieves and have
been out to Allaires forms site and haven't been able to find anything.
Any help would be greatly appreciated.
Thanks,
Kevin Davis
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
