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