- see footer for list info -<
Well almost anyway ....
I have just run the query between the first and second of november ....
There were 2 visits made by Carol Pye
http://www.bgfl.org/cfpages/calendar (Use Test Test) this will show you
whats in the calendar!
The query returns visits for other visitors.... Bah humbug!
So its not quite right yet ...!
Regards - Paul
From: dominic watson <[EMAIL PROTECTED]>
Reply-To: Coldfusion Development <[email protected]>
To: Coldfusion Development <[email protected]>
Subject: Re: [Spam] [CF-Dev] graphing
Date: Tue, 29 Nov 2005 10:39:07 +0000
- see footer for list info -<
Just doing a similar thing for another part of the DfES. With CFGRAPH the
graph is produced from two columns of data, 'value' and 'item'. With a
query it is used like so:
<cfgraph type="line" query="myQuery" valueColumn="valueColumnInQuery"
itemColumn="LabelColumnInQuery">
I assume CFCHART works the same way. I assume your two columns are nVisits
and LEAseniorStaff, your SQL in that case should be something like:
SELECT count(tblSchools.id)
tblVisitors.VisitorName
FROM tblSchools
...// inner joins
WHERE //
GROUP BY tblVisitors.VisitorName
Paul Swingewood wrote:
- 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
-<
_______________________________________________
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 -<
_______________________________________________
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 -<
