Are you having a problem or just don't know how to do the task?
-----Original Message-----
From: Peter Tanswell [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 22, 2007 9:55 AM
To: CF-Talk
Subject: Re: urgent help required - using a users selection to select
specific data
>
> Hi there
>
> I'm really stuck on this issue - have been trying to work it out for
> several hours so would really appreciate some input as to what I need
to do.
>
> I have displayed on screen an option where a user can select a month
> of a year to select specific data.
>
>
> <table>
> <form action="avgHours.cfm" method="post" name="form1">
> <tr class="printhide">
> <td align="center">
> <b>Graph Comparison Month</b>
> <select name="timedate_period"
onChange="document.form1.submit()">
> <cfloop query="CHECK_Periods">
> <option value="#timedate_id#" <cfif
> form.timedate_period eq
Check_Periods.timedate_id>selected</cfif>>#dateformat(dateend, "mmmm
yyyy")#
> </cfloop>
> </select>
> <input type="submit" value="Generate Report"
>
style="font-weight:bold;color:dodgerblue;background-color:white;border:n
one;">
> </td>
> </tr>
> <tr class="printhide"><td> </td></tr>
> </form>
> </table>
<cfloop query="people">
<cfset col_count = col_count + 1>
<!--- get people query --->
<cfquery name="getpeopleData" datasource="#application.vds#">
SET ARITHIGNORE ON
SELECT (peopleSummaryBilledDays*#billable_hoursperday#) +
peopleSummaryBilledHours AS peopleSummaryBilledHours,
people_FirstName,
people_LastName
FROM dbo.peopleSummary AS ps
INNER JOIN dbo.People AS p ON p.people_Id =
ps.peopleSummary_peopleId
WHERE peopleSummaryPeriod = #thisperiod#
AND people_id = #people_id#
ORDER BY people_LastName
</cfquery>
<td>
<!--- Display the hours for each person for each
month -
if no hours then - --->
<table cellpadding="0" cellspacing="0" width="100%">
<tr align="right">
<td style="border-bottom:1 aqua solid">
<cfif IsNumeric(getPeopleData.peopleSummaryBilledHours)>
#getPeopleData.peopleSummaryBilledHours#
<cfset hrstot[col_count] = hrstot[col_count] +
getPeopleData.peopleSummaryBilledHours>
<cfset coltot1[col_count] = coltot1[col_count] + 1>
<cfset hrs = hrs + getPeopleData.peopleSummaryBilledHours>
<cfif whatmonth eq thisperiod>
<cfset comparehrs[col_count] =
getPeopleData.peopleSummaryBilledHours>
</cfif>
<cfelse>
-
</cfif>
</td>
</tr>
</table>
</td>
</cfloop>
Basically what I have - I have a table being displayed on the screen a
bit like the following:
Year 2006
Select Month Aug
People Albert Brown Craig
Totals
Hrs July 20 30
40 90
Hrs Aug 10 20 20
50
Total 30 50
60 140
Avg 15 25
30 70
What I would like to do is let the user select a month - and when they
do this highlight on the table the month which they have selected.
Its probably simply but I am really struggling with this.
I need to try and complete this in the next 6-10 hours so any feedback
and info would be really appreciated.
Thanks in advance.
Toby
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289191
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
