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
