I'd like to thank every one on the list that replied to my email. With your
suggestions I was able to get my query working correctly.
Thanks again.
----- Original Message -----
From: "Thomas Chiverton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 10:35 AM
Subject: RE: one hour query
> 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
