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
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
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
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
4 matches
Mail list logo