Re: Application Scoped CFC's and the Request Scope
I could see issues. In thinking about standard app flow, the app is instantiated, calling onApplicationStart (where most of your application vars would get created), the onSessionStart, and only then onRequestStart. In that model, reffing the request scope in your application vars would always cause a problem, since the request vars would not yet exist. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 5/1/2012 2:33 PM, Brook Davies wrote: Hey Guys, While I know its not best practice, I am setting some variables in the request scope that are then referenced by several application scoped CFCs. Can this lead to collisions? I am seeing some strange errors that only happen when I run multiple requests at the same time and seem to involve the request scoped data. Could this potentially be the issue? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Blocking IPs
I have a host who, for the most part, I am satisfied with. However, he is in the habit of blocking IP ranges for various reasons... DDOS attacks, repeated port scans, etc. I've had complaints from some of my clients who do international business that some people cannot access their sites other parts of the world, like places in Asia, the Middle East, South and Central America, etc. I'm not surprised at the complaints. Is this a normal practice, or is this host over-zealous? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
Sounds over-zealous. Before I even block a single IP, I'll query my DB to try to determine whether valid traffic *ever* came from that IP. And, in general, blocking IP's is a last resort. I've never blocked a range. There're better ways to prevent the stuff he's trying to prevent. He should have a firewall that's smart/configurable enough to detect and prevent that stuff at a granular level. On Wed, May 2, 2012 at 7:51 AM, Robert Harrison rob...@austin-williams.comwrote: I have a host who, for the most part, I am satisfied with. However, he is in the habit of blocking IP ranges for various reasons... DDOS attacks, repeated port scans, etc. I've had complaints from some of my clients who do international business that some people cannot access their sites other parts of the world, like places in Asia, the Middle East, South and Central America, etc. I'm not surprised at the complaints. Is this a normal practice, or is this host over-zealous? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
The problem with IP blocking is that 99% of the time the IP is a fake IP, and that means that legitimate IP's are and do get blocked for no good reason. Who is the Hosting Provider? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Wed, May 2, 2012 at 10:51 PM, Robert Harrison rob...@austin-williams.com wrote: I have a host who, for the most part, I am satisfied with. However, he is in the habit of blocking IP ranges for various reasons... DDOS attacks, repeated port scans, etc. I've had complaints from some of my clients who do international business that some people cannot access their sites other parts of the world, like places in Asia, the Middle East, South and Central America, etc. I'm not surprised at the complaints. Is this a normal practice, or is this host over-zealous? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
The problem with IP blocking is that 99% of the time the IP is a fake IP, I'm not a protocol specialist, just curious, but how can an IP be forged? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
http://en.wikipedia.org/wiki/IP_address_spoofing On Wed, May 2, 2012 at 8:29 AM, wrote: The problem with IP blocking is that 99% of the time the IP is a fake IP, I'm not a protocol specialist, just curious, but how can an IP be forged? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) Blocking IPs
I run a SmarterMail server, and have blocked a few IPs, very selectively, only after I notice that consistent spam comes from those IPs that Barracuda or the other RBLs do not catch. No complaints from clients so far. I don't block entire countries or regions, though I have heard of administrators who do so. Some of my clients travel a lot, so I don't block countries. I send out friendly reminders to my clients to teach them how to recognize spam and use spam filters in MS Outlook. I hope at least a few people read them. =) Perhaps you can have a conversation with your hosting provider about using RBLs and configuring a firewall to do the spam blocking that he needs. Eric -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: Wednesday, May 02, 2012 7:58 AM To: cf-talk Subject: Re: (ot) Blocking IPs The problem with IP blocking is that 99% of the time the IP is a fake IP, and that means that legitimate IP's are and do get blocked for no good reason. Who is the Hosting Provider? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Wed, May 2, 2012 at 10:51 PM, Robert Harrison rob...@austin-williams.com wrote: I have a host who, for the most part, I am satisfied with. However, he is in the habit of blocking IP ranges for various reasons... DDOS attacks, repeated port scans, etc. I've had complaints from some of my clients who do international business that some people cannot access their sites other parts of the world, like places in Asia, the Middle East, South and Central America, etc. I'm not surprised at the complaints. Is this a normal practice, or is this host over-zealous? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
http://en.wikipedia.org/wiki/IP_address_spoofing Thanks. I can't believe it is that simple. It would be so simple if the protocol was something like: - sender: I have a message for you my IP is x.x.x.x - receiver: Ok, here is the key: (UUID) - sender: Ok, your key is (UUID), here is the message:... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to get IIS7 to redirect with query string
So, I finally finished this project up. Thanks to Jonah and Andrew for their suggestions on this. The info was quite helpful. --RR On Wed, Apr 4, 2012 at 8:38 PM, .jonah jonah@creori.com wrote: In the rules section of your web.config it'd be something like: rule name=favorite color rewrite match url=((?:[a-z][a-z0-9_]*))\/((**?:[a-z][a-z0-9_]*))\/((?:[a-z]** [a-z0-9_]*))\/((?:[a-z][a-z0-**9_]*))\/((?:[a-z][a-z0-9_]*)) / action type=Rewrite url=index.cfm?q=favorite.** colorsamp;{R:2}={R:3}amp;{R:**4}={R:5} appendQueryString=false / /rule On 4/4/12 5:22 PM, Robert Rhodes wrote: Anyone out there know how to set up IIS7 to pass a query string? Any url construct is probably fine as long as I can pass four variables and it does not have a ? or a in it (per client's requirements). I am trying to get something like... http://mydomain.com/redir/a/**red/b/greenhttp://mydomain.com/redir/a/red/b/green to redirect to: http://mydomain.com/index.cfm?**q=favorite.colorsa=redb=**greenhttp://mydomain.com/index.cfm?q=favorite.colorsa=redb=green Any Ideas? -RR ~~**~~** ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-**Coldfusion-Anthology/dp/** 1430272155/?tag=houseoffusionhttp://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/**groups/cf-talk/message.cfm/** messageid:350638http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350638 Subscription: http://www.houseoffusion.com/**groups/cf-talk/subscribe.cfmhttp://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/** groups/cf-talk/unsubscribe.cfmhttp://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
The problem with IP blocking is that 99% of the time the IP is a fake IP, This is not true. If you receive a message from an IP address, and the attacker's action relies on a response to that IP address, it will not be a fake IP address. It may not be the original IP address of the attacker, but it is definitely the IP address of the host connecting to you. and that means that legitimate IP's are and do get blocked for no good reason. This is true, in the sense that they may well be on the same range. But blocking individual addresses doesn't scale very well, to be honest. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
The problem with IP blocking is that 99% of the time the IP is a fake IP, and that means that legitimate IP's are and do get blocked for no good reason. It really depends on the type of attack. If they're just flodding as part of a DDOS attack then spoofing is viable, but for something like a SQL injection attack the IP can't be spoofed per se. In those cases the biggest problem, in my opinion, is that it is ridiculously easy to reroute (think TOR) and come from a different, unrelated IP in a matter of seconds. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
http://en.wikipedia.org/wiki/IP_address_spoofing That is only useful for very specific, limited sorts of things. You can't carry on a conversation with a remote server using a spoofed IP address, because the server would have no way to respond. If you're concerned about blocking spam email, for example, you don't have to worry about people sending email through a spoofed IP address, because SMTP is a TCP application, and TCP requires sequence numbers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) Blocking IPs
Well, I've checked with some contacts I have who are experts in security. One of them works in internet security for the DOD in Arlington, VA, one is the Security Director at a fortune 100 company, and one owns a large nationwide hosting company. All frowned on the practice of blocking port 80 by range of IP and said it's rare and extreme to totally block even a specific IP, but that it does happen. All thought that blocking mail traffic by IP was very normal. I'm having conversations with my ISP about removing the blocks now. He is resistant, but the consensus is against blanket IP blocking. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
I'm having conversations with my ISP about removing the blocks now. He is resistant, but the consensus is against blanket IP blocking. Well, one thing to note here is that it's easier for big ISPs to not block IP blocks than small ones - big ISPs, by having more bandwidth, more hosts to respond, etc, may have higher tolerance for higher amounts of traffic (whether that traffic is legitimate or not). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Video Streaming Provider
My next project involves a bunch of streaming videos (mp4) for an organization's users. Each user will need to have access to a different set of videos. So, user 1 might have access to videos 100, 211, and 513, while user 2 has access to videos 21, 100, 513 and 624. So I'll need obviously need a different login, password, and access list for each user. I don't want to stream these videos on the organization's site, but rather from an external provider. Either I would just use this provider to stream the videos through a player on the organization's site (preferred), or move the user off to the video vendor's site and have the login and streaming happen there. In that case, I would need to set up the user specific video streaming lists at the provider. Either way, I am hoping to find a streaming video provider that has a straightforward API that I can use to stream the videos and possible to set up users, their passwords, and perhaps their access permissions to specific videos. Any suggestions? Thanks to all, as always. :) -RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Video Streaming Provider
Brightcove... It's cool also because the Allaire guys launched it. On Wed, May 2, 2012 at 12:26 PM, Robert Rhodes rrhode...@gmail.com wrote: My next project involves a bunch of streaming videos (mp4) for an organization's users. Each user will need to have access to a different set of videos. So, user 1 might have access to videos 100, 211, and 513, while user 2 has access to videos 21, 100, 513 and 624. So I'll need obviously need a different login, password, and access list for each user. I don't want to stream these videos on the organization's site, but rather from an external provider. Either I would just use this provider to stream the videos through a player on the organization's site (preferred), or move the user off to the video vendor's site and have the login and streaming happen there. In that case, I would need to set up the user specific video streaming lists at the provider. Either way, I am hoping to find a streaming video provider that has a straightforward API that I can use to stream the videos and possible to set up users, their passwords, and perhaps their access permissions to specific videos. Any suggestions? Thanks to all, as always. :) -RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Video Streaming Provider
Brightcove... It's cool also because the Allaire guys launched it. I'll second that - we're a very happy Brightcove partner. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: Video Streaming Provider
We use Amazon: S3 for storage and CloudFront to stream out the hosted videos from edge locations all over the world. Over the past year, Amazon has added granular permissions at the level of CloudFront 'buckets', so I would think you could manage your permissions right there. Very inexpensive and excellent service over several years now. - Jason From: Robert Rhodes rrhode...@gmail.com Sent: Wednesday, May 02, 2012 12:27 PM To: cf-talk cf-talk@houseoffusion.com Subject: Video Streaming Provider My next project involves a bunch of streaming videos (mp4) for an organization's users. Each user will need to have access to a different set of videos. So, user 1 might have access to videos 100, 211, and 513, while user 2 has access to videos 21, 100, 513 and 624. So I'll need obviously need a different login, password, and access list for each user. I don't want to stream these videos on the organization's site, but rather from an external provider. Either I would just use this provider to stream the videos through a player on the organization's site (preferred), or move the user off to the video vendor's site and have the login and streaming happen there. In that case, I would need to set up the user specific video streaming lists at the provider. Either way, I am hoping to find a streaming video provider that has a straightforward API that I can use to stream the videos and possible to set up users, their passwords, and perhaps their access permissions to specific videos. Any suggestions? Thanks to all, as always. :) -RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Blocking IPs
We've certainly never done this as a permanent solution. Blocking IPs or ranges at the firewall wouldn't do much under a heavy DDOS, by the time the traffic is there it's probably saturating other parts of the hosts network. Better avenue would be to null route the destination IP on the edge routers and work with upstream providers to determine the source and have them block and/or shutdown the source. Null routing mitigates most of the effect of the DDOS on the rest of your network. Either way blocking at the firewall or null routing destinations would be temporary until the upstream provider could deal with things. I'd bet $1.50 that your host really doesn't understand mitigation or is hosting in another providers data center and doesn't have access to the core network gear. Also sounds like maybe they've had other customers complain about spam from specific IPs and did this as a quick fix. Byron Mann Lead Engineer and Architect HostMySite.com On Wed, May 2, 2012 at 8:51 AM, Robert Harrison rob...@austin-williams.comwrote: I have a host who, for the most part, I am satisfied with. However, he is in the habit of blocking IP ranges for various reasons... DDOS attacks, repeated port scans, etc. I've had complaints from some of my clients who do international business that some people cannot access their sites other parts of the world, like places in Asia, the Middle East, South and Central America, etc. I'm not surprised at the complaints. Is this a normal practice, or is this host over-zealous? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350968 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Checking for a duplicate value question
Got an app that sends out email to various lists - CF8 I'm checking to be sure there are any duplicates between the two lists req.this list - usually pretty small - ten or so email addresses req.groupLIST - is the problem - it could be a500 or more addresses at times. cfloop list=#req.thisLIST# index=i cfif NOT listfindnocase(req.groupLIST,#i#) DO MY STUFF HERE /cfif /cfloop Is there a more efficient way to do the above? If req.groupLIST ends up being a HUGE list - at what point will this choke down and time out? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Checking for a duplicate value question
When getting the information out of the database, us distinct on the field. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Thu, May 3, 2012 at 2:37 PM, Les Mizzell lesm...@bellsouth.net wrote: Got an app that sends out email to various lists - CF8 I'm checking to be sure there are any duplicates between the two lists req.this list - usually pretty small - ten or so email addresses req.groupLIST - is the problem - it could be a500 or more addresses at times. cfloop list=#req.thisLIST# index=i cfif NOT listfindnocase(req.groupLIST,#i#) DO MY STUFF HERE /cfif /cfloop Is there a more efficient way to do the above? If req.groupLIST ends up being a HUGE list - at what point will this choke down and time out? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm