RE: urgent help required - using a users selection to select specific data

2007-09-23 Thread Bobby Hartsfield
Lol! Please let us know that you have not been "staked" Toby!

Sincerely worried,
The Community

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: Greg Morphis [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

reminds me of
http://www.homestarrunner.com/sbemail10.html




On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> One issue, is your probably getting an error from: 
> FORM.TIMEDATE_PERIOD does not exist.
> Unless the form is being submitted from a previous form.
>
> Are you submitting the form right back to itself?
>
> If not, then why do you need the  statement in the OPTIONs
>
> If so, add a form parameter at the top of the page:
> 
>
>
>
> -Original Message-
> From: Toby King [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:27 AM
> To: CF-Talk
> Subject: 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.
>
>
> 
>   class="printhide">  Graph Comparison Month 
> 
> 
>  Check_Periods.timedate_id>selected>#dateformat(dateend, " 
> ")#style="font-weight:bold;color:dodgerblue;background-color:white;border
> :n
> one;">
> 
> 
>  
> 
> 
>
>
>
>
>
>
>
> 



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289213
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread DataPacks.com
Peter

How about passing the date (mm yy) as the URL variable instead of the date
id, then just compare them. Use a cfparam above all this set to the current
month and year so it display today by default. Then in your calendar table
use the URL var and the query value to see if they're the same. If so
display the style you want for that particular  tag.

Bill 

-Original Message-
From: Peter Tanswell [mailto:[EMAIL PROTECTED] 
Sent: September 22, 2007 10:09 AM
To: CF-Talk
Subject: Re: urgent help required - using a users selection to select
specific data

Nope not getting any error - its actually working the first part - can I
email you off list and show you




On 9/23/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> Ok are you getting an error when you first come to the page?
>
>
>
> -Original Message-
> From: Peter Tanswell [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:03 AM
> To: CF-Talk
> Subject: Re: urgent help required - using a users selection to select 
> specific data
>
> Hi yes - the form is being resubmitted to itself.
>
>
>
>
> On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> >
> > One issue, is your probably getting an error from:
> > FORM.TIMEDATE_PERIOD does not exist.
> > Unless the form is being submitted from a previous form.
> >
> > Are you submitting the form right back to itself?
> >
> > If not, then why do you need the  statement in the OPTIONs
> >
> > If so, add a form parameter at the top of the page:
> > 
> >
> >
> >
> > -Original Message-
> > From: Toby King [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, September 22, 2007 10:27 AM
> > To: CF-Talk
> > Subject: 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.
> >
> >
> > 
> >   > class="printhide">  Graph Comparison Month 
> > 
> > 
> >  > Check_Periods.timedate_id>selected>#dateformat(dateend, " 
> > ")#> style="font-weight:bold;color:dodgerblue;background-color:white;bord
> > er
> > :n
> > one;">
> > 
> > 
> >  
> > 
> > 
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> 



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289198
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Greg Morphis
If I'm reading it right..
set up a form variable


I'd define a CSS clss for hightlightedTD that alters the background
color, or something

Then during the output..
#foo.data#



make sense?





On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> Ok are you getting an error when you first come to the page?
>
>
>
> -Original Message-
> From: Peter Tanswell [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:03 AM
> To: CF-Talk
> Subject: Re: urgent help required - using a users selection to select
> specific data
>
> Hi yes - the form is being resubmitted to itself.
>
>
>
>
> On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> >
> > One issue, is your probably getting an error from:
> > FORM.TIMEDATE_PERIOD does not exist.
> > Unless the form is being submitted from a previous form.
> >
> > Are you submitting the form right back to itself?
> >
> > If not, then why do you need the  statement in the OPTIONs
> >
> > If so, add a form parameter at the top of the page:
> > 
> >
> >
> >
> > -Original Message-
> > From: Toby King [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, September 22, 2007 10:27 AM
> > To: CF-Talk
> > Subject: 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.
> >
> >
> > 
> >   > class="printhide">  Graph Comparison Month
> > 
> > 
> >  > Check_Periods.timedate_id>selected>#dateformat(dateend, "
> > ")#> style="font-weight:bold;color:dodgerblue;background-color:white;border
> > :n
> > one;">
> > 
> > 
> >  
> > 
> > 
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> 

~|
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:289197
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Peter Tanswell
Nope not getting any error - its actually working the first part - can I
email you off list and show you




On 9/23/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> Ok are you getting an error when you first come to the page?
>
>
>
> -Original Message-
> From: Peter Tanswell [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:03 AM
> To: CF-Talk
> Subject: Re: urgent help required - using a users selection to select
> specific data
>
> Hi yes - the form is being resubmitted to itself.
>
>
>
>
> On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> >
> > One issue, is your probably getting an error from:
> > FORM.TIMEDATE_PERIOD does not exist.
> > Unless the form is being submitted from a previous form.
> >
> > Are you submitting the form right back to itself?
> >
> > If not, then why do you need the  statement in the OPTIONs
> >
> > If so, add a form parameter at the top of the page:
> > 
> >
> >
> >
> > -Original Message-
> > From: Toby King [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, September 22, 2007 10:27 AM
> > To: CF-Talk
> > Subject: 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.
> >
> >
> > 
> >   > class="printhide">  Graph Comparison Month
> > 
> > 
> >  > Check_Periods.timedate_id>selected>#dateformat(dateend, "
> > ")#> style="font-weight:bold;color:dodgerblue;background-color:white;border
> > :n
> > one;">
> > 
> > 
> >  
> > 
> > 
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289196
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Peter Tanswell
I guess a bit of both - I know what I need to but have been struggling with
what to do to get it working.

Perhaps what I have asked is a bit over the top - if it is I apologise - if
necessary if its more than a 5-10 min fix solution to agree a small
consulting fee to get pointer to the right answer.


On 9/23/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> 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.
> >
> >
> > 
> > 
> >
> >   
> >  Graph Comparison Month
> >  onChange="document.form1.submit()">
> > 
> > > form.timedate_period eq
> Check_Periods.timedate_id>selected>#dateformat(dateend, "
> ")#
> > 
> > 
> >   >
> style="font-weight:bold;color:dodgerblue;background-color:white;border:n
> one;">
> >  
> >  
> >   
> > 
> > 
>
>
> 
>
>
>
> 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
>
>
>
>
>
>
>
>   
>
> #getPeopleData.peopleSummaryBilledHours#
>  getPeopleData.peopleSummaryBilledHours>
> 
> 
> 
>   getPeopleData.peopleSummaryBilledHours>
> 
>
> - 
>
>   
>  
>
> 
>
>   
>
>
> Basically what I have - I have a table being displayed on the screen a
> bit like the following:
>
> Year  2006
> Select Month   Aug
>
> PeopleAlbertBrownCraig
> Totals
> Hrs July 20  30
> 4090
> Hrs Aug 10  20 20
> 50
>
> Total  30 50
> 60   140
> Avg15 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
>
>
>
>
> 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289194
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
Ok are you getting an error when you first come to the page? 



-Original Message-
From: Peter Tanswell [mailto:[EMAIL PROTECTED] 
Sent: Saturday, September 22, 2007 10:03 AM
To: CF-Talk
Subject: Re: urgent help required - using a users selection to select
specific data

Hi yes - the form is being resubmitted to itself.




On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> One issue, is your probably getting an error from: 
> FORM.TIMEDATE_PERIOD does not exist.
> Unless the form is being submitted from a previous form.
>
> Are you submitting the form right back to itself?
>
> If not, then why do you need the  statement in the OPTIONs
>
> If so, add a form parameter at the top of the page:
> 
>
>
>
> -Original Message-
> From: Toby King [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:27 AM
> To: CF-Talk
> Subject: 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.
>
>
> 
>   class="printhide">  Graph Comparison Month 
> 
> 
>  Check_Periods.timedate_id>selected>#dateformat(dateend, " 
> ")#style="font-weight:bold;color:dodgerblue;background-color:white;border
> :n
> one;">
> 
> 
>  
> 
> 
>
>
>
>
>
>
>
> 



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289193
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Peter Tanswell
Hi yes - the form is being resubmitted to itself.




On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD
> does not exist.
> Unless the form is being submitted from a previous form.
>
> Are you submitting the form right back to itself?
>
> If not, then why do you need the  statement in the OPTIONs
>
> If so, add a form parameter at the top of the page:
> 
>
>
>
> -Original Message-
> From: Toby King [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:27 AM
> To: CF-Talk
> Subject: 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.
>
>
> 
>   class="printhide">  Graph Comparison Month
> 
> 
>  Check_Periods.timedate_id>selected>#dateformat(dateend, "
> ")#style="font-weight:bold;color:dodgerblue;background-color:white;border:n
> one;">
> 
> 
>  
> 
> 
>
>
>
>
>
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289192
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
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.
>
>
> 
> 
>
>   
>  Graph Comparison Month
> 
> 
> form.timedate_period eq
Check_Periods.timedate_id>selected>#dateformat(dateend, "
")#
> 
> 
>  
style="font-weight:bold;color:dodgerblue;background-color:white;border:n
one;">
>  
>  
>   
> 
> 






 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







   

 #getPeopleData.peopleSummaryBilledHours#
 
 
 
 
  
 

 - 

   
  

 

   


Basically what I have - I have a table being displayed on the screen a
bit like the following:

Year  2006
Select Month   Aug

PeopleAlbertBrownCraig
Totals
Hrs July 20  30
4090
Hrs Aug 10  20 20
50

Total  30 50
60   140
Avg15 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


RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
I agree :-) I forgot about that site 

-Original Message-
From: Greg Morphis [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

reminds me of
http://www.homestarrunner.com/sbemail10.html




On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> One issue, is your probably getting an error from: 
> FORM.TIMEDATE_PERIOD does not exist.
> Unless the form is being submitted from a previous form.
>
> Are you submitting the form right back to itself?
>
> If not, then why do you need the  statement in the OPTIONs
>
> If so, add a form parameter at the top of the page:
> 
>
>
>
> -Original Message-
> From: Toby King [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:27 AM
> To: CF-Talk
> Subject: 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.
>
>
> 
>   class="printhide">  Graph Comparison Month 
> 
> 
>  Check_Periods.timedate_id>selected>#dateformat(dateend, " 
> ")#style="font-weight:bold;color:dodgerblue;background-color:white;border
> :n
> one;">
> 
> 
>  
> 
> 
>
>
>
>
>
>
>
> 



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289190
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Greg Morphis
reminds me of
http://www.homestarrunner.com/sbemail10.html




On 9/22/07, Adkins, Randy <[EMAIL PROTECTED]> wrote:
> One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD
> does not exist.
> Unless the form is being submitted from a previous form.
>
> Are you submitting the form right back to itself?
>
> If not, then why do you need the  statement in the OPTIONs
>
> If so, add a form parameter at the top of the page:
> 
>
>
>
> -Original Message-
> From: Toby King [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 22, 2007 10:27 AM
> To: CF-Talk
> Subject: 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.
>
>
> 
>   class="printhide">  Graph Comparison Month
> 
> 
>  Check_Periods.timedate_id>selected>#dateformat(dateend, "
> ")#style="font-weight:bold;color:dodgerblue;background-color:white;border:n
> one;">
> 
> 
>  
> 
> 
>
>
>
>
>
>
>
> 

~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289189
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: urgent help required - using a users selection to select specific data

2007-09-22 Thread Peter Tanswell
>
> 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.
>
>
> 
> 
>
>   
>  Graph Comparison Month
> 
> 
> Check_Periods.timedate_id>selected>#dateformat(dateend, " ")#
> 
> 
>   style="font-weight:bold;color:dodgerblue;background-color:white;border:none;">
>  
>  
>   
> 
> 






 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







   

 #getPeopleData.peopleSummaryBilledHours#
 
 
 
 
  
 

 - 

   
  

 

   


Basically what I have - I have a table being displayed on the screen a bit
like the following:

Year  2006
Select Month   Aug

PeopleAlbertBrownCraig   Totals
Hrs July 20  30
4090
Hrs Aug 10  20 20
50

Total  30 50
60   140
Avg15 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


~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289188
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
One issue, is your probably getting an error from: FORM.TIMEDATE_PERIOD
does not exist.
Unless the form is being submitted from a previous form.

Are you submitting the form right back to itself?

If not, then why do you need the  statement in the OPTIONs

If so, add a form parameter at the top of the page:


 

-Original Message-
From: Toby King [mailto:[EMAIL PROTECTED] 
Sent: Saturday, September 22, 2007 10:27 AM
To: CF-Talk
Subject: 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.



   Graph Comparison Month


selected>#dateformat(dateend, "
")#   


 









~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289187
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread DataPacks.com
OK, and you need help with what??

 

-Original Message-
From: Toby King [mailto:[EMAIL PROTECTED] 
Sent: September 22, 2007 10:27 AM
To: CF-Talk
Subject: 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.



   Graph Comparison Month 

selected>#dateformat(dateend, " ")#
  


 









~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289185
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: urgent help required - using a users selection to select specific data

2007-09-22 Thread Adkins, Randy
Ok so what's the problem ?

-Original Message-
From: Toby King [mailto:[EMAIL PROTECTED] 
Sent: Saturday, September 22, 2007 10:27 AM
To: CF-Talk
Subject: 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.



   Graph Comparison Month


selected>#dateformat(dateend, "
")#   


 









~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289186
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4