You need whole dates that are an hour different... not just the "Hour()"
part. Use CreateODBCDateTime to create a date that's an hour behind the
current hour, and then say "WHERE createdate >= #HourPastDate# AND
createdate <= #CreateODBCDateTime(Now())#" or somesuch. Don't quote me on
exact syntax - it's early here and I haven't had a full cup of coffee yet.
:)
--Scott
----- Original Message -----
From: "Kevin Davis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 8:59 AM
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
