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 come with a performance cost. In a QofQ it may not be quite so bad, if the resultset is small. Let's see if that proves helpful for Derrick.
/charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Steve Ross Sent: Thursday, August 25, 2011 1:28 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Best way to handle chunk of CFIF statements 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... ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
