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