I have a cfquery below:
<cfquery name="NumofIntake" datasource="foo">
select
datepart(mm, DateofReferral) as TheMonth,
count(datepart(mm, DateofReferral)) as TheCount
from Intake
where datepart(mm, DateofReferral) is not null
<cfif form.YearSelection eq "select">
<cfelse>
and datepart(yy, DateofReferral) = #form.YearSelection#
</cfif>
group by datepart(mm, DateofReferral)
order by datepart(mm, DateofReferral)
</cfquery>
This cfquery passes "count(datepart(mm, DateofReferral)) as TheCount" to:
<td><div align="right"><b><cfoutput query="NumofIntake"><cfif
NumofIntake.TheMonth eq 1> #TheCount#</cfif></cfoutput></b></div>
</td>
<td> <div align="right"><b><cfoutput query="NumofIntake"><cfif
NumofIntake.TheMonth eq 2> #TheCount#</cfif></cfoutput></b></div>
</td>
Is there a way to display the details of "#TheCount#" when you click
on "#TheCount#"? Please note that "#TheCount#" changes dynamically
because of where clause in the cfquery above.
tia,
Daniel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199453
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
