RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Charlie Arehart
Thanks for that, Ed. Again, I appreciate that you're opening yourself to some ridicule for defending my "style". :-) You know, I had a debate about this with someone recently on another list. He felt I was an arrogant windbag. I replied that many people seemed to appreciate my contributions, an

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Szwedo . Ed
I think that you use exactly as many words as needed. Your emails are (in MY opinion) always clear and never verbose. ed __ Ed Szwedo Web Development Team Lead ECS Team - ITS-EPA II Contractor 109 TW Alexander Drive, Building NC

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Charlie Arehart
Sure, an IN clause would work, if the tests were for exact matches. I suspected that the user-agents being tested were long and the words within them to be tested were a subset. That's what makes it a challenge. Of course, then one could argue that a SQL LIKE clause might work, but of course those

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Charlie Arehart
It might seem Clint is joking, but while I have no experience in mind from him to know for sure, I think he’s being totally serious, which would be showing that opposite side I’ve been alluding to. That said, sorry, I just don’t see myself going to writing emails as bullet points. And on a ser

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Charlie Arehart
Sure, many of us feel that way. Sadly, many do not. That said, I realize you may mean that I or others still use more "words than necessary". One man's junk is another man's treasure, I guess. :-) It seems a constant tension (in my mind) on lists. Perhaps helpful to bring it up like this every

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Steve Ross
I was thinking about this... you could create a temp query and use an IN clause (with a QoQ). Would be a lot cleaner than this... On Thu, Aug 25, 2011 at 1:25 PM, Clint Willard wrote: > Long as we're off topic.. > >- No time for long emails >- More than meat of the matter is fat >- I

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Clint Willard
Long as we're off topic.. - No time for long emails - More than meat of the matter is fat - I love bullet points Sentences and paragraphs are so old school. We don't need no stinkin grammar neither. *Clint * On Thu, Aug 25, 2011 at 1:17 PM, wrote: > I also favor using as many words

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Dan Kaufman
And in the words as practiced by another genius: "Make everything as simple as possible, but no simpler." Albert Einstein -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of szwedo...@epamail.epa.gov Sent: Thursday, August 25, 2011 10:18 AM To: discussion@ac

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Szwedo . Ed
I also favor using as many words as necessary to communicate clearly. There really is no reason to compromise clarity for brevity's sake. My keyboard produces just as many words as I need, neither more nor less. ed __ Ed Szwedo

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Charlie Arehart
Sadly, you and I are a dying breed, it seems. :-) There's a definite subset of the culture who decidedly do NOT like any email longer than a couple of sentences-even if it means sacrificing clarity for brevity. Twitter has only exacerbated the problem by catering to that whim. It's clearly a cult

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Derrick Peavy
Well, don't stop. I prefer content over confusion (short). __ Derrick Peavy derr...@derrickpeavy.com 404-786-5036 “Innovation distinguishes between a leader and a follower.” - Steve Jobs "In economics, the majority is always wrong." - John Kenneth Galbraith _

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Charlie Arehart
Me and my "long" emails, I guess. ;-} /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Derrick Peavy Sent: Thursday, August 25, 2011 11:12 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements Charlie: For whatever r

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Derrick Peavy
Charlie: For whatever reason, my eye missed the first link to the UDF and I clicked the cf411.com link. Going back and looking at it now. __ Derrick Peavy derr...@derrickpeavy.com 404-786-5036 “Innovation distinguishes between a leader and a follower.” - Steve Jobs "In economics

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Cameron Childress
On Thu, Aug 25, 2011 at 10:38 AM, Cameron Childress wrote: > Sure. I'd probably actually use it to ass a URL param "badbot=true" or > something CF could consume. Again though, may be a lot of wasted energy for > a relatively minor reward. > ADD - to ADD a URL param. ...where's that coffee...

RE: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Charlie Arehart
As Cam has noted, the problem with this function is that it does only an exact match. That’s why I created the function I provided, to solve just this problem (and I do wish Adobe would add something like it themselves). But I appreciate others noting that you could also solve this specific prob

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Cameron Childress
On Thu, Aug 25, 2011 at 10:34 AM, Mark Fennell wrote: > Just to clarify... .htaccess can also redirect and not just block content. > > http://httpd.apache.org/docs/current/mod/mod_rewrite.html > It could be used to block or just redirect bad guys to a logging page, > suspected bad guys to a limi

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Mark Fennell
Just to clarify... .htaccess can also redirect and not just block content. http://httpd.apache.org/docs/current/mod/mod_rewrite.html It could be used to block or just redirect bad guys to a logging page, suspected bad guys to a limited site index and all others to your regular site. That's all.

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Cameron Childress
On Thu, Aug 25, 2011 at 9:22 AM, Clint Willard wrote: > Quick glance I'd say listFindNoCase(searchTermList,cgi.http_user_agent). > Put the search terms in a list to find. > This will only work if the entire exact case-less user agent matches an item in the list. I don't think it will solve Derr

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Frank Moorman
First, I like Charlie's function, its simple and it looks like it would work well. However, if you are looking for alternatives, you can always use a regular _expression_. There is plenty of information on regular expressions all over the web if y

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Mark Fennell
Depending on how long the list grows, you might see some performance benefits in splitting your list so that you only search a subset of the whole list each time. Maybe something like a list of names that contain the letters "bot", other lists for names containing the word "spider" or "crawler"

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Derrick Peavy
Aggh. Of course!!! Why didn't I think of that? I seem to constantly forget about listFindNoCase. Thank you! Simplicity is best IMO. __ Derrick Peavy derr...@derrickpeavy.com 404-786-5036 “Innovation distinguishes between a leader and a follower.” - Steve Jobs "In economics, t

Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements

2011-08-25 Thread Clint Willard
Quick glance I'd say listFindNoCase(searchTermList,cgi.http_user_agent). Put the search terms in a list to find. *Clint Willard * Senior ColdFusion Programmer Analyst clint...@gmail.com h) 770-965-6074 m) 706-714-5502 On Wed, Aug 24, 2011 at 5:06 PM, Derrick Peavy wrote: > Looking for a clever