---
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]
