I tried a few things, and eventually used:
<CFQUERY name="getWF" datasource="#ds#">
Select ObjectID from Objects
WHERE
TypeID = '#application.WorkFlowInstanceTypeID#'
and active = 0
and datetimelastupdated > #val(starttime-0)#
and datetimelastupdated < #val(endtime-0)#
</cfquery>
instead of the cfa_contentObjectFind tag. That seems to solve the problem.
Thank you for your help!
-- Jeni
-----Original Message-----
From: Ken Smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 10:42 AM
To: Spectra-Talk
Subject: RE: Last Updated date?
Hi Jeni,
Can you test with #val(datetimefromdb - 0)#
-----Original Message-----
From: Donovan, Jeni (Contractor) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 2:53 PM
To: Spectra-Talk
Subject: Last Updated date?
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C25A8D.9D6ECF6E
Content-Type: text/plain;
charset="iso-8859-1"
Has anyone ever had a problem with the "datetimelastupdated" field when
updating objects? All of my objects are being set with the
"datetimelastupdated" field being two days into the future. The problem is
NOT the server date on the win2K box or the database server (and it is
reproduced on another box), #now()# returns the correct date.
I'm using CF5, Spectra 1.51, Win2000.
Any ideas??
TIA-
Jeni Donovan
Digicon Corporation
[EMAIL PROTECTED]
------_=_NextPart_001_01C25A8D.9D6ECF6E
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2655.35">
<TITLE>Last Updated date?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Has anyone ever had a problem with the =
"datetimelastupdated" field when updating objects? All =
of my objects are being set with the "datetimelastupdated" =
field being two days into the future. The problem is NOT the =
server date on the win2K box or the database server (and it is =
reproduced on another box), #now()# returns the correct =
date.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I'm using CF5, Spectra 1.51, =
Win2000.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Any ideas??</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">TIA-</FONT>
<BR><B><FONT COLOR=3D"#800000" SIZE=3D2 FACE=3D"Tahoma">Jeni =
Donovan</FONT></B>
<BR><FONT SIZE=3D2 FACE=3D"Tahoma">Digicon Corporation</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Tahoma">[EMAIL PROTECTED]</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C25A8D.9D6ECF6E--
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
