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/yyyy")#' >=
'#DateFormat(now(),"mm/dd/yyyy")#'
and
'#DateFormat(Possible_Meeting_Dates.Meeting_Date,"mm/dd/yyyy")#' >
'#DateFormat(query1.meeting_date,"mm/dd/yyyy")#'
order by Meeting_Date
</cfquery>
If there is a better way please let me know.
Doug
Steve 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 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]
