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 <[email protected]> /*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:306717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
