>- see footer for list info -<
What are your values for #StartDateTime# and #EndDateTime# (I mean what
values did you use when you ran it in Query Analyser) ? I can't see your
reports page, btw ...
________________________________
From: Paul Swingewood [mailto:[EMAIL PROTECTED]
Sent: 29 November 2005 11:58
To: [email protected]
Subject: RE: [CF-Dev] graphing
>- 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 -<
************************************************************************
**** Notice: This e-mail and any attachments are confidential and may
contain legally privileged information and/or copyright material of
Hansen Technologies Limited or third parties. Copying, distributing,
disclosing, commercialising or otherwise acting in reliance on this
e-mail and any attachments is strictly prohibited unless you are the
addressee of this e-mail and have written permission to do so. If you
have received this e-mail in error please delete this e-mail (including
any copies and attachments) and contact Hansen Technologies Limited by
return e-mail or by telephone on + 61 39840 3000. Any views expressed
in this e-mail are those of the individual sender and may not
necessarily reflect the views of or be a commitment by the organisation,
except where the individual sender has the authority and expressly
states them to be so.
************************************************************************
****
_______________________________________________
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 -<
