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 g

Re: QoQ type comparison bug

2004-06-15 Thread Doug James
teve Nelson wrote: >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

RE: QoQ type comparison bug

2004-06-15 Thread Steve Nelson
PM To: CF-Talk Subject: QoQ type comparison bug Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166693 --- HELP! I am getting the old: Query Of Queries runtime error. Unsupported type comparison. I have a db query then I build a QoQ using DateFormat(tmp_Date,"mm/dd/") in th

RE: QoQ type comparison bug

2004-06-15 Thread Marlon Moyer
Original Message- > From: Doug James [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 15, 2004 11:01 AM > To: CF-Talk > Subject: QoQ type comparison bug > > Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166693 > --- > HELP! > I am getting the old: > Quer

QoQ type comparison bug

2004-06-15 Thread Doug James
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166693---HELP! I am getting the old: Query Of Queries runtime error. Unsupported type comparison. I have a db query then I build a QoQ using DateFormat(tmp_Date,"mm/dd/") in the QuerySetCell(). I then have a QoQ:   select Meeting_Date