Re: cfquery -- passing details of counts dynamically

2005-03-19 Thread Dave Francis
link to a display page? #theCount# and in DisplayPage.cfm SELECT * from Intake WHERE datepart(blah blah) = #URL.mm# - Original Message - From: "Daniel Kang" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Saturday, March 19, 2005 12:43 PM Subject: Re: cfq

Re: cfquery -- passing details of counts dynamically

2005-03-19 Thread Daniel Kang
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). NumofIntake.TheMonth eq 2> #TheCount# I want to see the details of 15 cfquery results when #TheCount# (in this case, "15") is clicked. How

Re: cfquery -- passing details of counts dynamically

2005-03-19 Thread Michael Traher
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

cfquery -- passing details of counts dynamically

2005-03-19 Thread Daniel Kang
I have a cfquery below: select datepart(mm, DateofReferral) as TheMonth, count(datepart(mm, DateofReferral)) as TheCount from Intake where datepart(mm, DateofReferral) is not null and datepart(yy, DateofReferral) = #form.YearSelection# group by datepart(mm, DateofReferral) order by d