- see footer for list info -<
I have just run the query on Query Analyzer and it does the same thing. So
it looks like something is wrong in the way the query groups/counts ....
The query ....
<cfquery name="GetEvents" datasource="#application.CalendarDSN#">
SELECT TOP 100 PERCENT COUNT(dbo.tblEvent.EventName) AS VisitCount,
dbo.tblVisitors.VisitorName
FROM cfpagesSchools.dbo.tblSchools INNER JOIN
dbo.tblEvent ON
cfpagesSchools.dbo.tblSchools.SchoolIDPK = dbo.tblEvent.SchoolIDFK INNER
JOIN
dbo.tblVisitors ON dbo.tblEvent.VisitorIDFK =
dbo.tblVisitors.VisitorIDPK
WHERE (tblevent.StartDateTime BETWEEN CONVERT(DATETIME, #StartDateTime#,
102)AND CONVERT(DATETIME,#EndDateTime#,102))
GROUP BY dbo.tblVisitors.VisitorName
ORDER BY dbo.tblVisitors.VisitorName
</cfquery>
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
