- see footer for list info -<
Hello Steve
The query in query analyser is ....
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 (dbo.tblEvent.StartDateTime BETWEEN CONVERT(DATETIME, '2005-11-01
07:00:00', 102) AND CONVERT(DATETIME, '2005-11-2 23:59:00', 102))
GROUP BY dbo.tblVisitors.VisitorName
ORDER BY dbo.tblVisitors.VisitorName
I have just been changing the end date day to run the query .....
You should be able to see the reports page now (server problems apparently)
Its interesting that runing the query in analyser I get to see the way the
query is runing.
The table that comes back shows carol pye with two entries one with visit
count at 3 (Abbey Catholic School) and one with count at 1 (Rookery). There
must be something wrong with the way that the grouping is working. It
obviuosly sees a school name change outside of the group.
I can see what I think is the problem but I can't fix it ... :(
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 -<
