link to a display page? <cfoutput query="NumofIntake"> <a href=displayPage.cfm?mm=#TheMonth#> #theCount# </a> </cfoutput>
and in DisplayPage.cfm SELECT * from Intake WHERE datepart(blah blah) = #URL.mm# ----- Original Message ----- From: "Daniel Kang" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Saturday, March 19, 2005 12:43 PM Subject: Re: cfquery -- passing details of counts dynamically > Mike, > > Yes, that is what I am trying to do, but here is the issue. > > Let's say #TheCount# (from the cfoutput below) returns 15 (meaning 15 > cfquery results). > > <cfoutput query="NumofIntake"><cfif> NumofIntake.TheMonth eq 2> > #TheCount#</cfif></cfoutput> > > I want to see the details of 15 cfquery results when #TheCount# (in > this case, "15") is clicked. How can I pass the details of > #TheCount#? > > Tia, > > Daniel > > On Sat, 19 Mar 2005 22:52:34 +0530, Michael Traher > <[EMAIL PROTECTED]> wrote: >> Hi Daniel, Not sure I fully understand. You have a form which the >> user can change, which, when submitted causes CF to run your query and >> generate some results in 'NumofIntake'. >> >> You are then displaying these. >> >> You can certainly use the 'onclick' attribute of some html tag to run >> some javascript to resubmit the form. Or wrap a <a href="yourURL"> >> </a> to create a link. >> >> Am I getting close to your question or just rambling? :-) >> >> MIke >> >> >> On Sat, 19 Mar 2005 11:42:22 -0500, Daniel Kang <[EMAIL PROTECTED]> >> wrote: >> > 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 >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199458 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
