Erik, why can't you just exclude those records in the SQL? select hours,minutes from TimesOnline where empID=#EID# and coursename like 'Activity Programming%' and (hours != 0 and minutes != 0)
?? On Tue, Jun 3, 2008 at 1:19 PM, Eric Roberts <[EMAIL PROTECTED]> wrote: > Please ignore the buttheads Katrina...it is still like that. > > Eric > > /*-----Original Message----- > /*From: Katrina Chapman [mailto:[EMAIL PROTECTED] > /*Sent: Tuesday, June 03, 2008 1:17 PM > /*To: CF-Talk > /*Subject: Re: do not increase counter is returns 0 > /* > /*I haven't been a member of this list for a few years now, but I remember > /*it being a place where even the most beginning person could come for > /*advice. This is a community and not a place for you to show how much more > /*you know than the next guy. > /*I really don't think this response is appropriate and I'm sure that most > /*of the community feels the same way. How about next time instead of > /*saying "You're an idiot," you either give some good advice or don't > /*respond? That way there's no "waste of everyone else's time" reading > /*posts that aren't helpful. You might also find that you'll get better > /*responses to any questions you have if you're nice. > /**Down off my soap box now* > /* Thank you, > /*Katrina > /* > /*If people knew how hard I worked to gain my mastery, > /*it wouldn't seem so wonderful after all. > /*--Michelangelo > /* > /* > /* > /*----- Original Message ---- > /*From: Brian Kotek <[EMAIL PROTECTED]> > /*To: CF-Talk <cf-talk@houseoffusion.com> > /*Sent: Tuesday, June 3, 2008 9:37:46 AM > /*Subject: Re: do not increase counter is returns 0 > /* > /*If Erik would bother to read even the most basic book on SQL he could > /*answer > /*this himself since this could all be done in a couple of lines of SQL with > /*no loops and no CFML at all. But he'd rather waste everyone else's time > /*instead of spending 10 dollars. So please don't encourage him, Tom. ;-) > /* > /* > /*On Tue, Jun 3, 2008 at 11:26 AM, Tom Chiverton > /*<[EMAIL PROTECTED]> > /*wrote: > /* > /*> On Friday 30 May 2008, erik tom wrote: > /*> > not return returns a record then do not increase the counter (this > /*part > /*> is > /*> > working) Also if the query.hours eq 0 and query.minutes eq 0 also > /*should > /*> > not increase the counter > /*> > <cfif getTimeAvg1.recordcount gt 0> > /*> > /*> <cfif getTimeAvg1.recordcount gt 0 and query.hours neq 0 and > /*query.mineutes > /*> neq 0> ? > /*> -- > /*> Tom Chiverton > /*> > /*> **************************************************** > /*> > /*> This email is sent for and on behalf of Halliwells LLP. > /*> > /*> Halliwells LLP is a limited liability partnership registered in England > /*and > /*> Wales under registered number OC307980 whose registered office address > /*is at > /*> Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A > /*> list of members is available for inspection at the registered office. > /*Any > /*> reference to a partner in relation to Halliwells LLP means a member of > /*> Halliwells LLP. Regulated by The Solicitors Regulation Authority. > /*> > /*> CONFIDENTIALITY > /*> > /*> This email is intended only for the use of the addressee named above and > /*> may be confidential or legally privileged. If you are not the addressee > /*you > /*> must not read it and must not use any information contained in nor copy > /*it > /*> nor inform any person other than Halliwells LLP or the addressee of its > /*> existence or contents. If you have received this email in error please > /*> delete it and notify Halliwells LLP IT Department on 0870 365 2500. > /*> > /*> For more information about Halliwells LLP visit www.halliwells.com. > /*> > /*> > /* > /* > /* > /* > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4