RE: QoQ type comparison bug

2004-06-18 Thread Kola Oyedeji
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

RE: QoQ type comparison bug

2004-06-15 Thread Marlon Moyer
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

RE: QoQ type comparison bug

2004-06-15 Thread Steve Nelson
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

Re: QoQ type comparison bug

2004-06-15 Thread Doug James
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/)#' =