You could simplify it by doing this:
SELECT MIN(CalendarDate) as MinDate, MAX(CalendarDate) as
MaxDate, EventName, GroupID
FROM Calendar
WHERE GroupID IN (
)
GROUP BY EventName, GroupID
On 9/19/05, sp @ who. net sp @ who. net <[EMAIL PROTECTED]> wrote:
> I am having difficulties outputting a
>The PreserveSingleQuotes function stops ColdFusion from automatically
>escaping the apostrophes for you. Try this:
>
>
>SELECT MIN(CalendarDate) as MinDate, MAX(CalendarDate) as
>MaxDate, EventName, GroupID
>FROM Calendar
>WHERE GroupID IN (#PreserveSingleQuotes(MovementList)#)
>GROUP BY EventNa
> BUT when i put the MovementList in the following query
> I get the following error. For some reason the list becomes qualified
> with double quotes. Here is the error
CF automatically escapes single quotes (ie. converts one single quote to two).
Either use the PreserveSingleQuotes() function
The PreserveSingleQuotes function stops ColdFusion from automatically
escaping the apostrophes for you. Try this:
SELECT MIN(CalendarDate) as MinDate, MAX(CalendarDate) as
MaxDate, EventName, GroupID
FROM Calendar
WHERE GroupID IN (#PreserveSingleQuotes(MovementList)#)
GROUP BY EventName, Group
I am having difficulties outputting a ListQualify in a query.
Here is the query
SELECT Distinct(GroupID), EventName
FROM Calendar
WHERE EventType = 'Movement Class'
and CalendarDate > '#TodayDate#'
GROUP BY GroupID, Eventname
ORDER BY EventName ASC
The output
#MovementList# giv
5 matches
Mail list logo