Did you try using cfqueryparam? I've seen this suggested as a possible
solution elsewhere
Kola
-Original Message-
From: Doug James [mailto:[EMAIL PROTECTED]
Sent: 15 June 2004 18:03
To: CF-Talk
Subject: Re: QoQ type comparison bug
Steve,
Thanks for the suggestion, it got me
You might try
and Meeting_Date '#query1.Meeting_Date[1]#'
or assign the query1.meetingdate to a variable first.
--
Marlon Moyer, Sr. Internet Developer
American Contractors Insurance Group
phone: 972.687.9445
fax: 972.687.0607
mailto:[EMAIL PROTECTED]
www.acig.com
-Original
It's probably because it's treating it like a string instead of a datetime
since you used dateformat in the querysetcell. Is tmp_date already a date?
Try removing the dateformat().
Steve Nelson
_
From: Doug James [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 15, 2004 12:01 PM
To: CF-Talk
Steve,
Thanks for the suggestion, it got me closer. I ended up having to put
everything into a date format to get it to work.
cfquery name=Meeting_Dates dbType=query
select Meeting_Date
from Possible_Meeting_Dates
where
'#DateFormat(Possible_Meeting_Dates.Meeting_Date,mm/dd/)#' =
4 matches
Mail list logo