CFMAP and the no longer needed api key
Since version 3 no longer requires an API key for the Google Maps API, does anyone know a way around CF's restriction of needing one for using cfmap? Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Looking for the right SMTP server
I am glad you said that. I thought it was me. I never had a software company be as rude to me as smartertools. They detected that I had the software running on 2 servers and sent me a really rude invoice asking me to pay for the second licence. I wrote back explaining how the licence specifically allows me to use the software for free as a backup mail server as long as it has no real email boxes. (I only have a total of about 10 mail boxes on the first instance! None on the second.) They said they would look into it. 6 months later, I get another nasty letter saying I am in violation. I call them and explain the situation and they said ok.. I am right, ignore it. Then it happened again. Now I just ignore it. I also stopped upgrading and am moving most of the mailboxes to google. At 08:44 PM 9/29/2010, you wrote: >Smartertools used to be great, but the bigger they got the more arrogant >they got and the higher their prices got and the worse the customer service >got, you wouldn't believe how rude they are. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
> agh! Just noticed that techniques developed to capture the > network path no longer work... c:/fakepath Expect that is > because of a security upgrade that has occurred with browsers in the > last few years... as hinted at by Dave Watts when he said... not > possible. To the best of my knowledge, browsers never sent the local path to the file that's uploaded. It would be an "information leakage" vulnerability if they did - it's none of the web site's business where I store files locally. 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 onsit ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
agh! Just noticed that techniques developed to capture the network path no longer work... c:/fakepath Expect that is because of a security upgrade that has occurred with browsers in the last few years... as hinted at by Dave Watts when he said... not possible. Yes perhaps typing it in is easiest but sure to create a lot of pissing and moaning :-( On Mon, Oct 4, 2010 at 5:37 PM, enigment wrote: > > You might be best off just having them type it in, and complain if it > doesn't exist. These are users at a high enough level that they're > configuring things, yes? Maybe the simplest solutions is the best. > > Dave > > On Mon, Oct 4, 2010 at 7:47 PM, William Seiter wrote: >> >> AIR is not the only method, but you can't get it done with just html. You >> will need A java applet or flash or air or some other program that can talk >> to the system as well as your app. >> >> -- >> William Seiter >> >> On Oct 4, 2010, at 4:39 PM, Gonzo Rock wrote: >> >>> >>> Well the purpose is to capture and store the Directory as part of a >>> configuration routine. Then days in the future other users of the >>> application will trigger it to process some datafiles... but >>> coldfusion needs to know where those datafiles are located. The >>> current user has no idea where they are stored... they just want the >>> files in the directory processed. >>> >>> Currently during the configuration session we can capture it by making >>> them point to a file in the directory and then stripping the actual >>> file name from the network path they navigated down... however how to >>> do this when there is NO file in the directory for them to use while >>> configuring the Directory Location for future use... that is the >>> problem... which Dave suggests can only be solved using AIR :-( >>> >>> On Mon, Oct 4, 2010 at 4:18 PM, Russ Michaels wrote: also u do not need to remember the path as this is the default behaviour of windows. When you open a browse window it always takes you to the last location you used. On Tue, Oct 5, 2010 at 12:15 AM, Dave Watts wrote: > >> Using > but how do you let the user browse and point to a Directory? >> >> I am trying to figure out how to let a user browse to a particular >> directory location on their network and then capture that location for >> future use. In this instance the application will always look in this >> location for files that it needs to process for the user. > > There's nothing built into HTML to capture a directory path. Also, > browsers won't let you store a directory path for later use, for > security reasons - the user always has to choose the file directly. > > Adobe AIR is a nice alternative here. Downloadable applications can do > all sorts of things that browsers won't allow. > > 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
You might be best off just having them type it in, and complain if it doesn't exist. These are users at a high enough level that they're configuring things, yes? Maybe the simplest solutions is the best. Dave On Mon, Oct 4, 2010 at 7:47 PM, William Seiter wrote: > > AIR is not the only method, but you can't get it done with just html. You > will need A java applet or flash or air or some other program that can talk > to the system as well as your app. > > -- > William Seiter > > On Oct 4, 2010, at 4:39 PM, Gonzo Rock wrote: > >> >> Well the purpose is to capture and store the Directory as part of a >> configuration routine. Then days in the future other users of the >> application will trigger it to process some datafiles... but >> coldfusion needs to know where those datafiles are located. The >> current user has no idea where they are stored... they just want the >> files in the directory processed. >> >> Currently during the configuration session we can capture it by making >> them point to a file in the directory and then stripping the actual >> file name from the network path they navigated down... however how to >> do this when there is NO file in the directory for them to use while >> configuring the Directory Location for future use... that is the >> problem... which Dave suggests can only be solved using AIR :-( >> >> On Mon, Oct 4, 2010 at 4:18 PM, Russ Michaels wrote: >>> >>> also u do not need to remember the path as this is the default behaviour of >>> windows. When you open a browse window it always takes you to the last >>> location you used. >>> >>> On Tue, Oct 5, 2010 at 12:15 AM, Dave Watts wrote: >>> > Using but how do you let the user browse and point to a Directory? > > I am trying to figure out how to let a user browse to a particular > directory location on their network and then capture that location for > future use. In this instance the application will always look in this > location for files that it needs to process for the user. There's nothing built into HTML to capture a directory path. Also, browsers won't let you store a directory path for later use, for security reasons - the user always has to choose the file directly. Adobe AIR is a nice alternative here. Downloadable applications can do all sorts of things that browsers won't allow. 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
AIR is not the only method, but you can't get it done with just html. You will need A java applet or flash or air or some other program that can talk to the system as well as your app. -- William Seiter On Oct 4, 2010, at 4:39 PM, Gonzo Rock wrote: > > Well the purpose is to capture and store the Directory as part of a > configuration routine. Then days in the future other users of the > application will trigger it to process some datafiles... but > coldfusion needs to know where those datafiles are located. The > current user has no idea where they are stored... they just want the > files in the directory processed. > > Currently during the configuration session we can capture it by making > them point to a file in the directory and then stripping the actual > file name from the network path they navigated down... however how to > do this when there is NO file in the directory for them to use while > configuring the Directory Location for future use... that is the > problem... which Dave suggests can only be solved using AIR :-( > > On Mon, Oct 4, 2010 at 4:18 PM, Russ Michaels wrote: >> >> also u do not need to remember the path as this is the default behaviour of >> windows. When you open a browse window it always takes you to the last >> location you used. >> >> On Tue, Oct 5, 2010 at 12:15 AM, Dave Watts wrote: >> >>> Using >>> but how do you let the user browse and point to a Directory? I am trying to figure out how to let a user browse to a particular directory location on their network and then capture that location for future use. In this instance the application will always look in this location for files that it needs to process for the user. >>> >>> There's nothing built into HTML to capture a directory path. Also, >>> browsers won't let you store a directory path for later use, for >>> security reasons - the user always has to choose the file directly. >>> >>> Adobe AIR is a nice alternative here. Downloadable applications can do >>> all sorts of things that browsers won't allow. >>> >>> 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
Well the purpose is to capture and store the Directory as part of a configuration routine. Then days in the future other users of the application will trigger it to process some datafiles... but coldfusion needs to know where those datafiles are located. The current user has no idea where they are stored... they just want the files in the directory processed. Currently during the configuration session we can capture it by making them point to a file in the directory and then stripping the actual file name from the network path they navigated down... however how to do this when there is NO file in the directory for them to use while configuring the Directory Location for future use... that is the problem... which Dave suggests can only be solved using AIR :-( On Mon, Oct 4, 2010 at 4:18 PM, Russ Michaels wrote: > > also u do not need to remember the path as this is the default behaviour of > windows. When you open a browse window it always takes you to the last > location you used. > > On Tue, Oct 5, 2010 at 12:15 AM, Dave Watts wrote: > >> >> > Using > > but how do you let the user browse and point to a Directory? >> > >> > I am trying to figure out how to let a user browse to a particular >> > directory location on their network and then capture that location for >> > future use. In this instance the application will always look in this >> > location for files that it needs to process for the user. >> >> There's nothing built into HTML to capture a directory path. Also, >> browsers won't let you store a directory path for later use, for >> security reasons - the user always has to choose the file directly. >> >> Adobe AIR is a nice alternative here. Downloadable applications can do >> all sorts of things that browsers won't allow. >> >> 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
also u do not need to remember the path as this is the default behaviour of windows. When you open a browse window it always takes you to the last location you used. On Tue, Oct 5, 2010 at 12:15 AM, Dave Watts wrote: > > > Using > but how do you let the user browse and point to a Directory? > > > > I am trying to figure out how to let a user browse to a particular > > directory location on their network and then capture that location for > > future use. In this instance the application will always look in this > > location for files that it needs to process for the user. > > There's nothing built into HTML to capture a directory path. Also, > browsers won't let you store a directory path for later use, for > security reasons - the user always has to choose the file directly. > > Adobe AIR is a nice alternative here. Downloadable applications can do > all sorts of things that browsers won't allow. > > 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to point to a Directory?
> Using but how do you let the user browse and point to a Directory? > > I am trying to figure out how to let a user browse to a particular > directory location on their network and then capture that location for > future use. In this instance the application will always look in this > location for files that it needs to process for the user. There's nothing built into HTML to capture a directory path. Also, browsers won't let you store a directory path for later use, for security reasons - the user always has to choose the file directly. Adobe AIR is a nice alternative here. Downloadable applications can do all sorts of things that browsers won't allow. 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to point to a Directory?
Using http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Algorithms
I'd say that it is definitely worthwhile to have an understanding of how algorithms work. Programmers should have a rough understanding of whether the way they are tackling a problem is O(n) or O(n^2) for instance. Is it better to solve a problem iteratively or recursively? You probably won't need to write your own sorting algorithm in CF, this is true, but understanding the major approaches to problems and what the trade offs are is probably a useful thing. And there are times when the sorts of issues that are addressed in an algorithms course has absolutely been on my plate as a programmer. For instance, what is the best way to store an arbitrary depth message board sort of structure in a database table? Do you pre-sort it and rearrange everything when you do a new insert because inserts happen rarely? Do you call a recursive function to build a tree starting with an arbitrary 0-depth marker and then go through until every record in the table has been visited and stored in memory? There are lots of options out there and they have real-world impact on the performance and complexity of your application. Cheers, Judah On Mon, Oct 4, 2010 at 3:12 PM, Justin Scott wrote: > >> The topics on that page won't be obviously >> beneficial to most ColdFusion programmers. > > I agree, with a note that these topics appear to be lower-level in nature > than CF programmers have to deal with. CF is essentially an abstraction of > Java at this point, which itself is a high-level language which requires > runtime environments to function. It's always nice to have some > foundational knowledge of how things like sorting and hashing are carried > out way down in the deep levels of the system, but for the most part a CF > developer has no need for that level of detailed knowledge to get through > the day. > > > -Justin > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Algorithms
On Mon, Oct 4, 2010 at 9:25 AM, fun and learning wrote: > This question is not directly related to Coldfusion. I just came across the > below lectures on algorithms from MIT. Does it help to know those concepts to > get better in Coldfusion? > > http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-046j-introduction-to-algorithms-sma-5503-fall-2005/video-lectures/ I don't know that they'd make you a better "ColdFusion programmer" but it never hurts to have some grounding in computer science that may well improve your ability to solve problems in general and therefore make you a better programmer at large. Much as I always recommend learning other programming languages that are substantially different to ColdFusion (I've recommended Prolog and Haskell in the past but these days might point people at Clojure and Scala for 'thinking differently'). -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Algorithms
> The topics on that page won't be obviously > beneficial to most ColdFusion programmers. I agree, with a note that these topics appear to be lower-level in nature than CF programmers have to deal with. CF is essentially an abstraction of Java at this point, which itself is a high-level language which requires runtime environments to function. It's always nice to have some foundational knowledge of how things like sorting and hashing are carried out way down in the deep levels of the system, but for the most part a CF developer has no need for that level of detailed knowledge to get through the day. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Algorithms
The topics on that page won't be obviously beneficial to most ColdFusion programmers. -Mike Chabot On Mon, Oct 4, 2010 at 12:25 PM, fun and learning wrote: > > Hi All- > > This question is not directly related to Coldfusion. I just came across the > below lectures on algorithms from MIT. Does it help to know those concepts to > get better in Coldfusion? > > http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-046j-introduction-to-algorithms-sma-5503-fall-2005/video-lectures/ > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need suggestion to achieve this functionality
Honestly, I think you could get it working in cfgrid but it seems like you are trying to build something that would require more info of scope to hash out how it would work. This is where I step off this thread... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Beta Testers Wanted - TrafficMunkey - A New CF Framework
Good day, CFers, I'm looking for beta testers for a new framework. We've been using it with MillionMunkeys sites for the past year, but now we want to make it available to the entire CF community as a free download, and see if it helps others as much as it helps us, plus how the community could make it grow. The usual question is "Why another framework?" Well, the short answer is that we do a lot of prototyping at MillionMunkeys and we needed something that facilitated faster edits and was more flexible, but still retained the full power of a framework all the way to the end of the product lifecycle. I'll stop there, so as not to take up more space on the list. If you want to know more, visit: http://millionmunkeys.net/TrafficMunkey/ For the more advanced: TrafficMunkey is written using Property-Invocation (Pi) Programming, which is like Implicit-Invocation (as in the II of Mach-II), but centered around properties instead of events. I would love to get feedback on this approach if you're curious about trying out a new approach to Object-Oriented programming. Pi Programming is laid out in more detail here: http://millionmunkeys.net/PiMunkey/ Thanks for your time, Peter Oliver-Krueger http://www.millionmunkeys.net/ "If you take a million programmers and put them in front of a million computers you get ... MillionMunkeys Software!" ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need suggestion to achieve this functionality
> I don't understand your implementation so I can't answer the question > properly. Why the fascination with cfgrid? Are you updating text input > fields in the grid or is it some other functionality that you want to > implement from cfgrid? Sorting, paging, etc? Please explain. Yes, I would be implementing paging, sorting and also a search functionality ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CKFinder.setupCKEditor won't allow a customConfig attribute
For those of you who have used FCKEditor over the years may already know the new CKEditor has split away from the file uploading and creating CKFinder. Both tools so far have been awesome and I've been trying to incorporate them both into our sites with pretty good success except the merging of the two programs along with customizing both to fit our business needs. I posted a thread on the CKFinder blog for details: http://cksource.com/forums/viewtopic.php?f=10&t=19071 I just wanted to post it here to see if my HoF guru's would have some kind of a work around of some sort. It's a known issue so I'm sure they're working on a work around.. I'm just hoping to have this issue solved before they find the work around and since I'm not a guru enough to understand the jquery working I tend to get dizzy and fall off my chair trying to come up with a work around. Thank you for any help to get this working. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: WOT: W3C Validator install on Windows problem
Oh yes! The problem isn't specifically with perl, it is with installing the required Perl Module SGML:Parser:OpenSP. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, October 04, 2010 3:23 PM To: cf-talk Subject: Re: WOT: W3C Validator install on Windows problem I'm definitely not a Perl expert. And I don't want to be one either. But have you added Perl to your path? 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: WOT: W3C Validator install on Windows problem
> I'm trying to install the W3C Validator on a windows machine. It uses > Perl to do the validations, and I have tried both ActivePerl and > Strawberry Perl. I've tried installing one of the needed perl Modules > (SGML:Parser:OpenSP) and I can't seem to get it to work. > > I installed OpenSP (part of the sourceforge OpenJade project) so that I > could get this to work, but I still can't get it to install and run > properly. > > Any perl experts out there with an idea? I'm definitely not a Perl expert. And I don't want to be one either. But have you added Perl to your path? 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
WOT: W3C Validator install on Windows problem
Hi all, I'm trying to install the W3C Validator on a windows machine. It uses Perl to do the validations, and I have tried both ActivePerl and Strawberry Perl. I've tried installing one of the needed perl Modules (SGML:Parser:OpenSP) and I can't seem to get it to work. I installed OpenSP (part of the sourceforge OpenJade project) so that I could get this to work, but I still can't get it to install and run properly. Any perl experts out there with an idea? Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need suggestion to achieve this functionality
I don't understand your implementation so I can't answer the question properly. Why the fascination with cfgrid? Are you updating text input fields in the grid or is it some other functionality that you want to implement from cfgrid? Sorting, paging, etc? Please explain. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Fake URLS
Were you the one asking for a way to generate the url's from the database? Then this may be the solution for you. http://www.helicontech.com/ape/ particularly this feature. http://www.helicontech.com/ape/doc/mod_seo.htm Russ > Subject: Fake URLS > From: Donnie Carvajal > Date: Fri, 1 Oct 2010 11:44:19 -0400 (EDT) > Thread: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:62014#337741 > > I am trying to make my e-Commerce item links for efficient. For example, I would like the link for an IPod Tocuh 32 GB to be http://www.domain.com/ipod_touch_32_gb instead of http://www.domain.com/store.cfm?i=123456&s=789456&p=654321. You get the point. I'm assuming that the url http://www.domain.com/ipod_touch_32_gb will throw some kind of 404 error and I will need to change the web server custom error for this 404 error to run some kind of script. > > Has anyone implemented URLs like this before? If so, how? Are there any scripts out there that I can use? > > Thanks, > > Donnie ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Algorithms
Hi All- This question is not directly related to Coldfusion. I just came across the below lectures on algorithms from MIT. Does it help to know those concepts to get better in Coldfusion? http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-046j-introduction-to-algorithms-sma-5503-fall-2005/video-lectures/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Fake URLS
Donnie, if you have CF8 or higher, you might find TrafficMunkey does the trick. My company is releasing this as a free download today. It's a framework that allows you to use real URLs while still retaining all of the benefits of a framework, like site templates and exit actions. For your issue in particular, you would use regular, old folders. Setup a folder for each product, the webserver will serve up the index.cfm file in each folder. TrafficMunkey intercepts this request, and then lets you configure any page in your site to field that request, regardless of whether it exists in that folder or not. It's what I do for the link below. There are a few peculiarities based on Web server, e.g. Apache just serves up the page but IIS needs an actual empty folder so that the folder can be configured to allow Directory Browsing, but once you know this, it works pretty smoothly. http://www.millionmunkeys.net/TrafficMunkey/ Pete Oliver-Krueger http://www.millionmunkeys.net/ "Ideas for building software. Software for building websites, fast!" > Subject: Fake URLS > From: Donnie Carvajal > Date: Fri, 1 Oct 2010 11:44:19 -0400 (EDT) > Thread: > http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:62014#337741 > > I am trying to make my e-Commerce item links for efficient. For example, I > would like the link for an IPod Tocuh 32 GB to be > http://www.domain.com/ipod_touch_32_gb instead of > http://www.domain.com/store.cfm?i=123456&s=789456&p=654321. You get the > point. I'm assuming that the url http://www.domain.com/ipod_touch_32_gb will > throw some kind of 404 error and I will need to change the web server custom > error for this 404 error to run some kind of script. > > Has anyone implemented URLs like this before? If so, how? Are there any > scripts out there that I can use? > > Thanks, > > Donnie ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337828 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't figure out a query to accomplish this...
In any join query, when you select *, you'll get all columns from both tables you've joined. It doesn't matter if the columns are named the same; since they are in different tables they are providing different data and are returned as separate columns. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 4 October 2010 21:59, Rick Faircloth wrote: > > Yes, once I got the query working (except for the duplicate fields) > I swapped to "select *" to avoid having to type the 50 or so fields > involved. It works elsewhere, so I figured it should here. > > But as soon as I starting specifically naming the fields, the > duplication cleared up. > > I would love to know why, but I guess that's just the way MySQL > works with that particular query. Perhaps it's the way it has > to be done with a left joi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't figure out a query to accomplish this...
Naming all the columns also prevents issues with incorrect pooled statements being cached when you add a column to the DB. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 4 October 2010 22:14, Michael Grant wrote: > SOT: Point of note, regardless of how tedious this task may seem you should > always select only the fields you are using. Unless you know that you are > using all fields in a table and that the table columns will never change for > that table, you should define the fields in your select statement. It's not > only more streamlined, but it makes it easier for other devs to read and > understand your code. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't figure out a query to accomplish this...
> > I swapped to "select *" to avoid having to type the 50 or so > fields involved. SOT: Point of note, regardless of how tedious this task may seem you should always select only the fields you are using. Unless you know that you are using all fields in a table and that the table columns will never change for that table, you should define the fields in your select statement. It's not only more streamlined, but it makes it easier for other devs to read and understand your code. my $0.02 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can't figure out a query to accomplish this...
Yes, once I got the query working (except for the duplicate fields) I swapped to "select *" to avoid having to type the 50 or so fields involved. It works elsewhere, so I figured it should here. But as soon as I starting specifically naming the fields, the duplication cleared up. I would love to know why, but I guess that's just the way MySQL works with that particular query. Perhaps it's the way it has to be done with a left join. Anyway, all is well! Thanks, James! Rick -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Monday, October 04, 2010 9:12 AM To: cf-talk Subject: Re: Can't figure out a query to accomplish this... Are you using select * to get the records? If so, get rid of that and name the select columns from p. select p.area, p.bedrooms, p.bathrooms from ... etc -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 4 October 2010 11:28, Rick Faircloth wrote: > > Spoke (wrote) too soon... > > I'm getting the correct records, but I just realized > I'm getting two of every field returned. I tried > other joins, but can't affect the fields so that I get > just one field. > > How do I modify the query to return just one field ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't figure out a query to accomplish this...
Yes, distinct or a group by. This should work: select * fromproperties p where p.mls_number not in ( select pc.mls_number from properties_copy pc where pc.mls_number is not null and pc.mls='hmls' ) and p.mls = 'hmls' and p.mls_number is not null And if not this should: SELECT pc.mls_number FROM properties_copy pc LEFT OUTER JOIN properties p ON pc.mls = p.mls WHERE p.mls IS NULL AND pc.mls = 'hmls' GROUP BY mls_number, mls On Mon, Oct 4, 2010 at 12:29 AM, Andrew Scott wrote: > > You might need to provide the distinct, or adjust the join correctly. I am > betting the distinct is needed. > > > Regards, > Andrew Scott > http://www.andyscott.id.au/ > > > > -Original Message- > > From: Rick Faircloth [mailto:ric...@whitestonemedia.com] > > Sent: Monday, 4 October 2010 3:16 PM > > To: cf-talk > > Subject: RE: Can't figure out a query to accomplish this... > > > > > > Well, when I run this: > > > > select * > > fromproperties p > > where p.mls_number not in ( select pc.mls_number from > > properties_copy pc ) > > and p.mls = 'hmls' > > and p.mls_number is not null > > > > I get no records returned... > > > > > > > > -Original Message- > > From: Andrew Scott [mailto:andr...@andyscott.id.au] > > Sent: Sunday, October 03, 2010 11:36 PM > > To: cf-talk > > Subject: RE: Can't figure out a query to accomplish this... > > > > > > I was wondering why you are doing an left join and not a sub select, the > > join will create duplicates if not the right way around. > > > > Regards, > > Andrew Scott > > http://www.andyscott.id.au/ > > > > > > > > > -Original Message- > > > From: Rick Faircloth [mailto:ric...@whitestonemedia.com] > > > Sent: Monday, 4 October 2010 2:28 PM > > > To: cf-talk > > > Subject: RE: Can't figure out a query to accomplish this... > > > > > > > > > Spoke (wrote) too soon... > > > > > > I'm getting the correct records, but I just realized I'm getting two of > > every > > > field returned. I tried other joins, but can't affect the fields so > that > > I get just > > > one field. > > > > > > How do I modify the query to return just one field? > > > > > > I'm getting: > > > > > > (record 1) area area bedrooms bedrooms bathrooms bathrooms, etc... > > > > > > When it should be: > > > > > > (record 1) area bedrooms bathrooms, etc... > > > > > > ??? > > > > > > > > > > > > -Original Message- > > > From: Rick Faircloth [mailto:ric...@whitestonemedia.com] > > > Sent: Sunday, October 03, 2010 11:17 PM > > > To: cf-talk > > > Subject: RE: Can't figure out a query to accomplish this... > > > > > > > > > Ok...here's the final solution. > > > (Had to watch some football before I could sort it out :o) > > > > > > select p.mls_number > > > from properties p > > > left joinproperties_copy pc > > > on pc.mls_number = p.mls_number > > > wherepc.mls_number is null > > > and p.mls = 'hmls' > > > and p.mls_number is not null > > > > > > That last line had to be added because there were some > > > records with no mls_number that I didn't know about earlier. > > > > > > I swear it seems like this was one of the first queries > > > I tried. But, whatever, it works! > > > > > > Thanks for the help, everyone! > > > > > > Rick > > > > > > -Original Message- > > > From: Jason Fisher [mailto:ja...@wanax.com] > > > Sent: Sunday, October 03, 2010 7:07 PM > > > To: cf-talk > > > Subject: Re: Can't figure out a query to accomplish this... > > > > > > > > > Ah, then reverse the JOIN (unless MySQL handles this differently) if > > > you want only the ones IN _copy: > > > > > > SELECT pc.mls_number > > > FROM properties_copy pc LEFT OUTER JOIN > > > properties p ON pc.mls = p.mls > > > WHERE p.mls IS NULL > > > AND pc.mls = 'hmls' > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~ > > > ~~~| > > > Order the Adobe Coldfusion Anthology now! > > > http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- > > > Dinowitz/dp/1430272155/?tag=houseoffusion > > > Archive: http://www.houseoffusion.com/groups/cf- > > > talk/message.cfm/messageid:337817 > > > Subscription: http://www.houseoffusion.com/groups/cf- > > talk/subscribe.cfm > > > Unsubscribe: http://www.houseoffusion.com/groups/cf- > > > talk/unsubscribe.cfm > > > > > > > > > > ~~ > > ~~~| > > Order the Adobe Coldfusion Anthology now! > > http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- > > Dinowitz/dp/1430272155/?tag=houseoffusion > > Archive: http://www.houseoffusion.com/groups/cf- > > talk/message.cfm/messageid:337819 > > Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > > Unsubscribe: http://www.houseoffusion.com/groups/cf- > > talk/unsubscribe.cfm > > > ~~~
RE: Can't figure out a query to accomplish this...
I tried the group by, but as I suspected, that only would work to eliminate duplicate *records*. What I was getting is duplicate *fields* within each record. However, James has the solution. See my reply to him... Thanks, Michael! Rick -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Monday, October 04, 2010 6:10 AM To: cf-talk Subject: Re: Can't figure out a query to accomplish this... Yes, distinct or a group by. This should work: select * fromproperties p where p.mls_number not in ( select pc.mls_number from properties_copy pc where pc.mls_number is not null and pc.mls='hmls' ) and p.mls = 'hmls' and p.mls_number is not null And if not this should: SELECT pc.mls_number FROM properties_copy pc LEFT OUTER JOIN properties p ON pc.mls = p.mls WHERE p.mls IS NULL AND pc.mls = 'hmls' GROUP BY mls_number, mls On Mon, Oct 4, 2010 at 12:29 AM, Andrew Scott wrote: > > You might need to provide the distinct, or adjust the join correctly. I am > betting the distinct is needed. > > > Regards, > Andrew Scott > http://www.andyscott.id.au/ > > > > -Original Message- > > From: Rick Faircloth [mailto:ric...@whitestonemedia.com] > > Sent: Monday, 4 October 2010 3:16 PM > > To: cf-talk > > Subject: RE: Can't figure out a query to accomplish this... > > > > > > Well, when I run this: > > > > select * > > fromproperties p > > where p.mls_number not in ( select pc.mls_number from > > properties_copy pc ) > > and p.mls = 'hmls' > > and p.mls_number is not null > > > > I get no records returned... > > > > > > > > -Original Message- > > From: Andrew Scott [mailto:andr...@andyscott.id.au] > > Sent: Sunday, October 03, 2010 11:36 PM > > To: cf-talk > > Subject: RE: Can't figure out a query to accomplish this... > > > > > > I was wondering why you are doing an left join and not a sub select, the > > join will create duplicates if not the right way around. > > > > Regards, > > Andrew Scott > > http://www.andyscott.id.au/ > > > > > > > > > -Original Message- > > > From: Rick Faircloth [mailto:ric...@whitestonemedia.com] > > > Sent: Monday, 4 October 2010 2:28 PM > > > To: cf-talk > > > Subject: RE: Can't figure out a query to accomplish this... > > > > > > > > > Spoke (wrote) too soon... > > > > > > I'm getting the correct records, but I just realized I'm getting two of > > every > > > field returned. I tried other joins, but can't affect the fields so > that > > I get just > > > one field. > > > > > > How do I modify the query to return just one field? > > > > > > I'm getting: > > > > > > (record 1) area area bedrooms bedrooms bathrooms bathrooms, etc... > > > > > > When it should be: > > > > > > (record 1) area bedrooms bathrooms, etc... > > > > > > ??? > > > > > > > > > > > > -Original Message- > > > From: Rick Faircloth [mailto:ric...@whitestonemedia.com] > > > Sent: Sunday, October 03, 2010 11:17 PM > > > To: cf-talk > > > Subject: RE: Can't figure out a query to accomplish this... > > > > > > > > > Ok...here's the final solution. > > > (Had to watch some football before I could sort it out :o) > > > > > > select p.mls_number > > > from properties p > > > left joinproperties_copy pc > > > on pc.mls_number = p.mls_number > > > wherepc.mls_number is null > > > and p.mls = 'hmls' > > > and p.mls_number is not null > > > > > > That last line had to be added because there were some > > > records with no mls_number that I didn't know about earlier. > > > > > > I swear it seems like this was one of the first queries > > > I tried. But, whatever, it works! > > > > > > Thanks for the help, everyone! > > > > > > Rick > > > > > > -Original Message- > > > From: Jason Fisher [mailto:ja...@wanax.com] > > > Sent: Sunday, October 03, 2010 7:07 PM > > > To: cf-talk > > > Subject: Re: Can't figure out a query to accomplish this... > > > > > > > > > Ah, then reverse the JOIN (unless MySQL handles this differently) if > > > you want only the ones IN _copy: > > > > > > SELECT pc.mls_number > > > FROM properties_copy pc LEFT OUTER JOIN > > > properties p ON pc.mls = p.mls > > > WHERE p.mls IS NULL > > > AND pc.mls = 'hmls' > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~ > > > ~~~| > > > Order the Adobe Coldfusion Anthology now! > > > http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- > > > Dinowitz/dp/1430272155/?tag=houseoffusion > > > Archive: http://www.houseoffusion.com/groups/cf- > > > talk/message.cfm/messageid:337817 > > > Subscription: http://www.houseoffusion.com/groups/cf- > > talk/subscribe.cfm > > > Unsubscribe: http://www.houseoffusion.com/groups/cf- > > > talk/unsubscribe.cfm > > > > > > > > > > ~~ > > ~~~| > > Order the Adobe Coldfusion Anthology now!
Re: Can't figure out a query to accomplish this...
Are you using select * to get the records? If so, get rid of that and name the select columns from p. select p.area, p.bedrooms, p.bathrooms from ... etc -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 4 October 2010 11:28, Rick Faircloth wrote: > > Spoke (wrote) too soon... > > I'm getting the correct records, but I just realized > I'm getting two of every field returned. I tried > other joins, but can't affect the fields so that I get > just one field. > > How do I modify the query to return just one field ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm