#val(Hour(Now())-1)#
-----Original Message-----
From: Kevin Davis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 10:59 AM
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 <= #val(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
