Oops, I forgot to say that this assumes that the field createdate is a
datetime field.
============================================================
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you eat the bear; some days the bear eats you.
============================================================
> -----Original Message-----
> From: Russel Madere [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 10:24
> To: CF-Talk
> Subject: RE: one hour query
>
>
> Try
>
> <CFQUERY name="name" datasource="#ds#">
> Select * from tablename
> where fieldname = fielddata
> and createdate >= '#DateFormat(Now, "mmm dd, yyyy")# #TimeFormat(Now(),
> "HH:mm:ss")#'
> and createdate <= '#DateFormat(Now, "mmm dd, yyyy")#
> #TimeFormat(DateAdd("h", "-1", Now()), "HH:mm:ss")#'
> </CFQUERY>
>
> ============================================================
> Russel Madere, Jr. Senior Web Developer
> ICQ: 5446158 http://www.TurboSquid.com
>
> Some days you eat the bear; some days the bear eats you.
> ============================================================
>
>
> > -----Original Message-----
> > From: Kevin Davis [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 06, 2001 09:59
> > 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
