- see footer for list info -<
Bugger! - This still isn't quite right .....
I have this code ...
<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>
<cfchart format="flash"
xaxistitle="Visitors"
yaxistitle="No. Vists">
<cfchartseries type="bar"
query="GetEvents"
itemcolumn="VisitorName"
valuecolumn="VisitCount">
</cfchartseries>
</cfchart>
If you look at the calendar say between 1/11/05 and 5/11/05 you will see
that carol pye made two visits (Same school is that the problem?) and HOS4
made 1 visit.
The graph says that carol made 1 and hos4 made 1
Im not sure whats wrong here can anyone help ...
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 -<
