>- see footer for list info -<
visits on the y axis - presumably you mean number of visits? how about
something like:
<cfquery name="GetEvents" datasource="#application.CalendarDSN#">
SELECT 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, #StartDate#, 102)AND
CONVERT(DATETIME,#EndDateTime#,102))
GROUP BY visitCount
ORDER BY VisitorName
</cfquery>
Duncan Cumming
New Media Developer
Customer Relations Management / Education
Fife Council
700 4105 / 01592 414105
>>> [EMAIL PROTECTED] 29/11/2005 10:20:55 >>>
>- see footer for list info -<
Hello.
I am trying to develop a reporting page that shows reports fetched between
two dates.
The idea is to show a graph of visits to schools by LEA senior staff.
I have been reading up on cfchart (mx6.1) and it seems ffairly straight
forward however ....
The database is a sort of calendar which holds school visits.
I want the user to be able to select 2 dates start and end and show a graph
which displays the visitors on the x axis and vists on the y axis.
I think the cfchart needs this data presented correctly to work (I think) so
how do I 'group' the number of visits for each visitor?
I have a query like this ....
<cfquery name="GetEvents" datasource="#application.CalendarDSN#">
SELECT cfpagesSchools.dbo.tblSchools.SchoolName,
cfpagesSchools.dbo.tblSchools.SchoolIDPK,
dbo.tblEvent.EventIDPK,
dbo.tblEvent.SchoolIDFK,
dbo.tblEvent.EventName,
dbo.tblEvent.StartDateTime,
dbo.tblEvent.EndDateTime,
Day(tblEvent.StartDateTime) AS EventStartDay,
Day(tblEvent.EndDateTime) AS EventEndDay,
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, #StartDate#, 102)AND
CONVERT(DATETIME,#EndDateTime#,102))
ORDER BY StartDateTime
</cfquery>
What do I need to do to get this into cfchart ...?
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 -<
**********************************************************************
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed and
should not be disclosed to any other party.
If you have received this email in error please notify your system manager and
the sender of this message.
This email message has been swept for the presence of computer viruses but no
guarantee is given that this e-mail message and any attachments are free from
viruses.
Fife Council
Tel: +44 (0) 1592 414141
**********************************************************************
_______________________________________________
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 -<
