It seems as if this part of the SQL statement is what is causing this
WHERE courseoutline.id = iteccourse.courseoutlineid
AND
iteccourse.courseoutlineid ='1'
As when I run the query without below with out the SQL clause above it
works as it should ?? Any ideas ??
<cfquery name="getupcomingevents" datasource="in">
SELECT courseoutline.coursetitle, courseoutline.coursesummary,
courseoutline.coursepath, iteccourse.coursestart,
to_char(coursestart,'YYYY') AS eventYear, to_char(coursestart,'MM') AS
eventMonth, iteccourse.duration,
iteccourse.availability
FROM courseoutline, iteccourse
WHERE
trunc(coursestart) BETWEEN
TO_DATE('#DateFormat(variables.Begindate,"dd/mm/yyyy")#','DD/MM/YYYY')
AND TO_DATE('#DateFormat(variables.Enddate,"dd/mm/yyyy")#','DD/MM/YYYY')
ORDER BY iteccourse.coursestart asc
</cfquery>
________________________________
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: 16 July 2004 13:09
To: CF-Talk
Subject: RE: Problem with SQL WHERE clause and CF ???
You are grouping on coursestart, so it groups on a date (year, month AND
day). Follow the instructions in my previous post.
Pascal
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
