do not increase counter is returns 0

I have a problem calculating the average. What i need is if the query does 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 <cfset empCnt2=0>     <cfset empCnt=0>     <cfset scoreCnt=0>     <cfset tAvg=0>     <cfset scoreCnt2=0>     <cfset tAvg2=0>        <cfloop query="getAvg">     <cfquery name="getTimeAvg1" datasource="cfelsunrise" dbtype="ODBC">       select hours,minutes from TimesOnline where empID=#EID# and coursename like 'Activity Programming%'     </cfquery>       <cfif getTimeAvg1.recordcount gt 0>         <cfset Hours = getTimeAvg1.hours>                  <Cfset minutes=getTimeAvg1.minutes>         <cfset Hours2=Hours*60>         <cfset Hours1=Hours2+minutes>         <cfset scoreCnt=scoreCnt+Hours1>                 <cfset empCnt=empCnt+1>                     </cfif> <cfset tAvg=scoreCnt/empCnt> <td align="center"><cfoutput>#Round(tAvg)#</cfoutput></td> Please help

> 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.

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. ;-) ----- Excess quoted text cut - see Original Post for more -----

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 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. ;-)----- Excess quoted text cut - see Original Post for more -----

Please ignore the buttheads Katrina...it is still like that. Eric /*-----Original Message----- /* /*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 <brian428@gmail.com> /*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 /*<tom.chiverton@halliwells.com> /*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. /*> /*> /* /* /* /*

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) ?? ----- Excess quoted text cut - see Original Post for more -----

That's the whole point. If he actually spent a fraction of the time that he does asking these kinds of questions and instead just read a book, everyone would benefit. ----- Excess quoted text cut - see Original Post for more -----

As your post clearly indicates. On Tue, Jun 3, 2008 at 2:19 PM, Eric Roberts < owner@threeravensconsulting.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

> 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* ok so this is just my $0.02... It's not unreasonable to expect that when somebody asks for help (asks for you to give up your own time) that they've already made *reasonable* efforts to solve the problem on their own.  The "How To Ask Questions The Smart Way" page (http://www.catb.org/~esr/faqs/smart-questions.html) is pretty well known for illustrating... well, how to ask questions the smart way. That being said, the person in question has posted numerous times to this list and his questions never seem to indicate that he's even put forth the smallest amount of effort to learn how to do what needs doing.  In Brian's defense, he (Brian) has responded to questions posed by Erik numerous times in what I considered to be a fairly courteous manner.  He's pointed out the link that I referenced above, he's tried to teach Erik how to figure things out on his own.  When you've been doing this for a while (answering questions on mailing lists), you get a sense for who is genuinely making an effort and who is just looking for a quick answer.  When it's the latter, you're hesitant to provide that quick answer because you *know* that person will just keep coming back for the quick answer, expecting others to spend their time answering his/her question. Brian's advice (again, IMHO) *has* been good.  Very good.  Assuming that the person actually has an interest in learning. I like to believe the purpose of lists like this is to teach people. Not to answer questions for (e.g. do the work for) people who don't want to learn. /me passes the soapbox to the next person in line. -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off."

I think the thing to remember is not everyone reading mailing lists as things come in or worse later down the road in some sort of archives, is not going to always be familiar with the history of users.  So depending on the person lashing out, it could bite them in the butt later on.  Obviously someone more known in the community though it would be doubtful to bite them but guess it depends on how often they do it.  So with that said, sometimes it is best just not to say anything at all if someone is asking questions that "annoy" people. ----- Excess quoted text cut - see Original Post for more -----

Then the better option would be to just not reply instead of giving the impression that the list is not friendly to people who ask questions. Eric /*-----Original Message----- /* /*Sent: Tuesday, June 03, 2008 1:43 PM /*To: CF-Talk /*Subject: Re: do not increase counter is returns 0 /* /*On Tue, Jun 3, 2008 at 11:17 AM, Katrina Chapman <katrinajoy@yahoo.com> /*wrote: /*> 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* /* /*ok so this is just my $0.02... /* /*It's not unreasonable to expect that when somebody asks for help (asks /*for you to give up your own time) that they've already made /**reasonable* efforts to solve the problem on their own.  The "How To /*Ask Questions The Smart Way" page /*(http://www.catb.org/~esr/faqs/smart-questions.html) is pretty well /*known for illustrating... well, how to ask questions the smart way. /* /*That being said, the person in question has posted numerous times to /*this list and his questions never seem to indicate that he's even put /*forth the smallest amount of effort to learn how to do what needs /*doing.  In Brian's defense, he (Brian) has responded to questions /*posed by Erik numerous times in what I considered to be a fairly /*courteous manner.  He's pointed out the link that I referenced above, /*he's tried to teach Erik how to figure things out on his own.  When /*you've been doing this for a while (answering questions on mailing /*lists), you get a sense for who is genuinely making an effort and who /*is just looking for a quick answer.  When it's the latter, you're /*hesitant to provide that quick answer because you *know* that person /*will just keep coming back for the quick answer, expecting others to /*spend their time answering his/her question. /* /*Brian's advice (again, IMHO) *has* been good.  Very good.  Assuming /*that the person actually has an interest in learning. /* /*I like to believe the purpose of lists like this is to teach people. /*Not to answer questions for (e.g. do the work for) people who don't /*want to learn. /* /*/me passes the soapbox to the next person in line. /* /* /*-- /*A byte walks into a bar and orders a pint. Bartender asks him "What's /*wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I /*thought you looked a bit off." /* /*

> Then the better option would be to just not reply instead of giving the > impression that the list is not friendly to people who ask questions. Not answering is not helpful.  Suggesting that reading a book on SQL is helpful (as Dave says, even if it's not the answer the poster wants to hear). -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off."

> Then the better option would be to just not reply instead of giving the > impression that the list is not friendly to people who ask questions. I'll further point out that Brian didn't call anybody names.  You, on the other hand, referred to him so eloquently as a "butthead".  You might want to look at a person's overall contributions to the community before making such a statement on a public forum. -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off."

The list is and should be friendly to people who ask questions. The list should not, however, be friendly to people who repeatedly ignore help and advice and instead continue to ask the same class of questions over and over, relying on the charity of others rather than spending any effort resolving the underlying problem. On Tue, Jun 3, 2008 at 3:24 PM, Eric Roberts < owner@threeravensconsulting.com> wrote: > Then the better option would be to just not reply instead of giving the > impression that the list is not friendly to people who ask questions. > > Eric > >

Thank you, Charlie. Yes, as you point out, I have tried over and over to explain things to Erik as well as reiterate that what he asks about are things that would be explained in the first few chapters of any book (or even website tutorial) on the subject. Instead, he absolutely refuses to try to learn himself and instead keeps on asking questions. Why? Because people keep answering them. I'm trying to help him AND the list because the current situation is harming both. But to be honest, the fact that Mr. Roberts misses the point completely and resorts to the very ad hominid attacks he condemns is not shocking in the slightest. ----- Excess quoted text cut - see Original Post for more -----

Hominid: Any member of the biological family Hominidae (the "great apes"), including the extinct and extant humans, chimpanzees, gorillas, and orangutans. Thank you. Adrian :OD Thank you, Charlie. Yes, as you point out, I have tried over and over to explain things to Erik as well as reiterate that what he asks about are things that would be explained in the first few chapters of any book (or even website tutorial) on the subject. Instead, he absolutely refuses to try to learn himself and instead keeps on asking questions. Why? Because people keep answering them. I'm trying to help him AND the list because the current situation is harming both. But to be honest, the fact that Mr. Roberts misses the point completely and resorts to the very ad hominid attacks he condemns is not shocking in the slightest.

Given the nature of this thread, "ad hominid attacks" is one of the best Freudian/spell check slip(s) in hominid history. ~G~ ----- Excess quoted text cut - see Original Post for more -----

>> 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. -------------- Normally I do not get involved with this sort of thing but I feel the need to offer my unsolicited opinion. ;) Katrina I agree with you 100% in spirit. There are a lot of ugly "communities" on the web where people are flat out mean to each other, and I hate that with a passion. All in all, this is a very good group of people. IMHO, the CF community is one of the best on the net. There is some bickering here and there but in general most everyone here is extremely helpful and very polite. Often time people go *way out their way* to help people. Not to mention that some people here are down right brilliant. With that said, before you pass judgment on Brian, please take a moment to review at the questions that Erik Tom posts here. I think you will find that nearly all of them are poorly thought out, poorly worded, full of horrendous grammar and spelling errors and at times don't even make sense. It is as if he doesn't care. Look, we are talking about a guy who forwarded a Nigerian Lotto scam email to this list. People come here to learn and share their knowledge with the community. This list is a two way street. If you expect someone to take the time to answer your question please be respectful enough to take the time to ask a thoughtful, well worded question. Or at least Google it or crack open a book or RTM before post to a list. We are talking Netiquette 101. Respectfully, Gerald -- "The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them." - Sir William Bragg

Gerald, Regarding grammar and writing skill (and forgive me because I don't know this) but is it possible there is a language barrier here? The subject line above reminds me of someone for whom English is possibly a second language. I don't know Erick but I certainly don't want to chase people away from the community on the basis of grammar if they already know (at least) one more language than I do :) -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com >> 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. -------------- Normally I do not get involved with this sort of thing but I feel the need to offer my unsolicited opinion. ;) Katrina I agree with you 100% in spirit. There are a lot of ugly "communities" on the web where people are flat out mean to each other, and I hate that with a passion. All in all, this is a very good group of people. IMHO, the CF community is one of the best on the net. There is some bickering here and there but in general most everyone here is extremely helpful and very polite. Often time people go *way out their way* to help people. Not to mention that some people here are down right brilliant. With that said, before you pass judgment on Brian, please take a moment to review at the questions that Erik Tom posts here. I think you will find that nearly all of them are poorly thought out, poorly worded, full of horrendous grammar and spelling errors and at times don't even make sense. It is as if he doesn't care. Look, we are talking about a guy who forwarded a Nigerian Lotto scam email to this list. People come here to learn and share their knowledge with the community. This list is a two way street. If you expect someone to take the time to answer your question please be respectful enough to take the time to ask a thoughtful, well worded question. Or at least Google it or crack open a book or RTM before post to a list. We are talking Netiquette 101. Respectfully, Gerald -- "The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them." - Sir William Bragg

True. I have wondered that too. I actually thought the same thing right after I sent the email.  I don't want to chase off ppl either. ----- Excess quoted text cut - see Original Post for more ----- -- "The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them." - Sir William Bragg

My point is that if you are not going to be nice about your response, and you wish to respond in that manner, then either don't respond or respond privately.  I wasn't following the thread nor do I remember any of the posts Erik has made, but if you were to look at Brian's posting, that would give the impression that this is an unfriendly list and might scare away newbies that would other gain a lot of knowledge from the guru's here.  That has nothing to do with how much one has contributed to the community or not but rather how this list appears to a new person.  Whether it was warranted or not, I thought Brian's response was very rude.  I do appreciate Brain's contributions and I have learned a lot from his posts, but that doesn't excuse being rude to someone asking a question in a professional community. If this wasn't a professional community I would say fire up the flame throwers...I enjoy a good argument as much as the next guy, but this just isn't an appropriate place for it.  We also don't know whatever resources he access to as far as books or what his level of proficiency is.  When we first got started, I bet many of us asked the same questions in our effort to learn. Eric /*-----Original Message----- /* /*Sent: Tuesday, June 03, 2008 4:15 PM /*To: CF-Talk /*Subject: Re: do not increase counter is returns 0 /* /*True. I have wondered that too. I actually thought the same thing right /*after I sent the email.  I don't want to chase off ppl either. /* /* /*On Tue, Jun 3, 2008 at 5:02 PM, Mark Kruger <mkruger@cfwebtools.com> /*wrote: /* /*> Gerald, /*> /*> Regarding grammar and writing skill (and forgive me because I don't know /*> this) but is it possible there is a language barrier here? The subject /*line /*> above reminds me of someone for whom English is possibly a second /*language. /*> I don't know Erick but I certainly don't want to chase people away from /*the /*> community on the basis of grammar if they already know (at least) one /*more /*> language than I do :) /*> /*> -Mark /*> /*> Mark A. Kruger, CFG, MCSE /*> (402) 408-3733 ext 105 /*> www.cfwebtools.com /*> www.coldfusionmuse.com /*> www.necfug.com /*> /*> /* /*-- /*"The important thing in science is not so much to obtain new facts as to /*discover new ways of thinking about them." /*- Sir William Bragg /* /* /*

And in your quest to keep the list professional and make it seem like a friendly place you opted to refer to Brian as a butthead.  Nicely done. Not for nothing, but whether it was warranted or not, it was very rude. Pot... meet kettle. ----- Excess quoted text cut - see Original Post for more -----

I want to thank Gerald for his thoughtful post to this discussion.  I did not understand the history behind these emails and this discussion was very unsettling.  Gerald's email helped me better understand what led up to today's discussion. The only thing I want to add is that while a post may be directed at one person, it can be read by everyone and misunderstood by anyone.  And not only can anyone read every post, any post can be making a first impression to a new visitor.  I nearly didn't ask my first question a month ago because I was intimidated by a similar exchange. I personally appreciate every question asked and every answer provided in assistance.  Since joining this list I have learned a lot from the simple questions that people post.  I occasionally see a question that I can answer and then I will see an answer that is better than one I would have given or did give. I would like to thank you all for the assistance you provide. Brian >> 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. -------------- Normally I do not get involved with this sort of thing but I feel the need to offer my unsolicited opinion. ;) Katrina I agree with you 100% in spirit. There are a lot of ugly "communities" on the web where people are flat out mean to each other, and I hate that with a passion. All in all, this is a very good group of people. IMHO, the CF community is one of the best on the net. There is some bickering here and there but in general most everyone here is extremely helpful and very polite. Often time people go *way out their way* to help people. Not to mention that some people here are down right brilliant. With that said, before you pass judgment on Brian, please take a moment to review at the questions that Erik Tom posts here. I think you will find that nearly all of them are poorly thought out, poorly worded, full of horrendous grammar and spelling errors and at times don't even make sense. It is as if he doesn't care. Look, we are talking about a guy who forwarded a Nigerian Lotto scam email to this list. People come here to learn and share their knowledge with the community. This list is a two way street. If you expect someone to take the time to answer your question please be respectful enough to take the time to ask a thoughtful, well worded question. Or at least Google it or crack open a book or RTM before post to a list. We are talking Netiquette 101. Respectfully, Gerald -- "The important thing in science is not so much to obtain new facts as to discover new ways of thinking about them." - Sir William Bragg

Katrina, I held off responding to you to wait for the other replies that I knew would be coming. Hopefully by this point you realize that your comments to me were rather far off the mark, and that folks with knowledge of this ongoing situation actually agree with me. I assume you must not have known what has gone on with Erik and hopefully these additional postings have supplied the context that my initial reply did not. But even still, I neither called him an idiot nor attempted to show "how much more I know than the next guy". I would humbly ask that in the future, before you condemn me or put words in my mouth that you please make sure you aren't missing essential background information. I promise to do the same. ;-) Thanks, Brian ----- Excess quoted text cut - see Original Post for more -----

----- Excess quoted text cut - see Original Post for more ----- Sometimes, the best advice is to say "read a book". Brian didn't call Erik an idiot, he just advised Erik to read an SQL book. That might not be the advice the poster wants to receive, but I think it's a fair piece of advice. If you post one or two simple SQL questions to a list, that might not a very appropriate response. If you frequently post similar questions that indicate a basic lack of knowledge of a subject, you should expect responses like that on any list, no matter how much of a community it is. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information!

This thread and all associated threads end NOW! Your admin