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
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/yyyy") in the QuerySetCell().
I then have a QoQ:
<cfquery name="Meeting_Dates" dbType="query">
select Meeting_Date
from Possible_Meeting_Dates
where Meeting_Date >= '#DateFormat(now(),"mm/dd/yyyy")#'
and Meeting_Date > '#query1.Meeting_Date#'
order by Meeting_Date
</cfquery>
The error is tagging the "and Meeting_Date > '#query1.Meeting_Date#'"
line. I have tried everything I can think of including cfqueryparam. The
query1.meeting_date column is a SQL Server smalldatetime column.
Please help!
Thank you.
Doug
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
