Re: Auto-Login to Google Analytics
On Tue, Mar 9, 2010 at 11:23 PM, Donnie Carvajal wrote: Is it possible to authenticate to Google using the AuthSub and then pass the token in a GET/POST to Analytics? On an intranet you could do some DNS voodoo to hijack a google DNS name and set some cookies from that DNS name. But if you go that way you should take a moment to consider the security consequences of messing with Google accounts. I realize that this problem is the same trying to access any Google services and this is not just Analytics specific. Which is why I don't think your clients will be happy if you do this. Imagine having Gmail open in one tab with an almost complete message, clicking your intranet link for the statistics and suddenly being logged out from your own Gmail account and into another Google account for the analytics. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Make HomeSite+ Open Source? (WAS: RE: Development Apps - Does anyone use homesite still?)
On Tue, Mar 9, 2010 at 6:50 PM, Christian N. Abad wrote: ColdFusion 9 Extensions for HomeSite+ 2) If not, is there someone in the community who would be willing to do this? How much would you be willing to pay for that? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto-Login to Google Analytics
Ben Nadel's CFHttpSession.cfc may be able to do this, I have not tried it yet-- but it mimics browser sessions. http://www.bennadel.com/projects/cfhttp-session.htm logged out from your own Gmail account and into another Google account for the analytics. Just as a side note: You can log into 2 gmail accounts in the same browser as once as long as one of them is a business account. :) I do it all the time. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Make HomeSite+ Open Source? (WAS: RE: Development Apps - Does anyone use homesite still?)
I've been planning to update Homesite's expression builder and docs to ColdFusion 9 for a while now. It's just been on the back burner while I do paying projects. I'll eventually get around to it but if it was for pay rather than for community support, it would get done a LOT faster. Either way, it'll still get done though. If someone does step up to the plate to do this, I can dig up a copy of Nate Weiss's visual VTML editor for them to use (I usually edit VTML by hand). I can also comment a bit on where things are under the hood in Homesite and what has to be done. Once you know where everything is and how to alter it, all you have to do is write some regex to parse the docs and build the files. Yes, I make it sound easy because it is. :) How much would you be willing to pay for that? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Development and Testing Environment Recommendations
We are fortunate enough to operate in an environment where we are alotted ample hardware resources, so we can operate separate physical servers if that's the recommendation. The point about development failures affecting our test environment is well-taken. To date, we've not needed to run load testing on our sites; our sites don't typically experience heavy traffic. Moving forward, we are open to doing things differently or implementing virtualization if the flexibility it allows outweighs the issue raised by Dave. In an ideal world, everything is on a separate physical server, with a redundant backup. But using a single machine or VMs can be suitable. There are, of course, different considerations for all of these scenarios. For example, if you use a single machine, what's the likelihood that a failure in your development environment could cause a resource-based denial of service in your test environment? Do you plan to run load tests in your testing environment? 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. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfspreadsheet write problem within function
Leigh, Thanks for the reply and sorry for the slow response on my part. Somehow I missed your reply. On Fri, Mar 5, 2010 at 8:49 PM, Leigh cfsearch...@yahoo.com wrote: Can someone just confirm that I'm not crazy You are not crazy. A very quick test produced the same results for me. Interestingly, the error disappeared if I removed the VAR declaration for the ss variable. Obviously not a viable solution though. Thanks. Good to know. I'll file a bug report. Weird that the VAR declaration would make a difference. Try using the SpreadSheetWrite() function instead. Thanks. I will. By the way, have you confirmed that the SpreadsheetWrite() function works inside a cffunction? (I'm not being lazy. I just won't have a chance to get back to this for a couple of days.) -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Make HomeSite+ Open Source? (WAS: RE: Development Apps - Does anyone use homesite still?)
I'll raise my hand for this. I probably won't be able to do it all, but if a few of us all work on it then it should get done pretty quick. Let me know what I need to do. Steve -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Wednesday, March 10, 2010 8:19 AM To: cf-talk Subject: Re: Make HomeSite+ Open Source? (WAS: RE: Development Apps - Does anyone use homesite still?) I've been planning to update Homesite's expression builder and docs to ColdFusion 9 for a while now. It's just been on the back burner while I do paying projects. I'll eventually get around to it but if it was for pay rather than for community support, it would get done a LOT faster. Either way, it'll still get done though. If someone does step up to the plate to do this, I can dig up a copy of Nate Weiss's visual VTML editor for them to use (I usually edit VTML by hand). I can also comment a bit on where things are under the hood in Homesite and what has to be done. Once you know where everything is and how to alter it, all you have to do is write some regex to parse the docs and build the files. Yes, I make it sound easy because it is. :) How much would you be willing to pay for that? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
Well, I think I know why I didn't use that originally. It is not working. I am probably doing something dumb but I haven't been able to Google this problem away. It tried two things. Neither of them worked. In my .cfm view I replaced cflocation url=#local.desiredEvent# addToken=Yes / Which works with cfhttp method=get url=#local.desiredEvent# Which does not work I also tried adding this to my .cfc bypassing the .cfm entirely cfhttp method=get url=#local.desiredEventValues.desiredEvent# With these code changes nothing happens. There is no indication that the URL is being called. So what am I doing wrong? And thanks for the help. Bryan -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Tuesday, March 09, 2010 4:11 PM To: cf-talk Subject: Re: Phantom Scheduled Tasks Cflocation within a scheduled task would be the first thing I'd toss while testing. Doesn't sit well with me. I'd replace it with a CFHTTP call (you're generating a url already) and if I really wanted to decouple the two I may put it in a CFTHREAD. Just some testing ideas. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Phantom Scheduled Tasks
Dump cfhttp after the call and it will show you useful information (run the page in the browser so you can see the dump). Look at the status values and response for clues as to what's going. - Gabriel On Wed, Mar 10, 2010 at 9:23 AM, Bryan S bryansgroup...@gmail.com wrote: Well, I think I know why I didn't use that originally. It is not working. I am probably doing something dumb but I haven't been able to Google this problem away. It tried two things. Neither of them worked. In my .cfm view I replaced cflocation url=#local.desiredEvent# addToken=Yes / Which works with cfhttp method=get url=#local.desiredEvent# Which does not work I also tried adding this to my .cfc bypassing the .cfm entirely cfhttp method=get url=#local.desiredEventValues.desiredEvent# With these code changes nothing happens. There is no indication that the URL is being called. So what am I doing wrong? And thanks for the help. Bryan -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Tuesday, March 09, 2010 4:11 PM To: cf-talk Subject: Re: Phantom Scheduled Tasks Cflocation within a scheduled task would be the first thing I'd toss while testing. Doesn't sit well with me. I'd replace it with a CFHTTP call (you're generating a url already) and if I really wanted to decouple the two I may put it in a CFTHREAD. Just some testing ideas. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto-Login to Google Analytics
Just as a side note: You can log into 2 gmail accounts in the same browser as once as long as one of them is a business account. :) I do it all the time. ... unless both accounts share the same email address. For example, I have two Google accounts with the email address dwa...@figleaf.com. One is a GAFYD account, the other is a regular Google account with Gmail and Calendar not activated. This allows me to use public Google services like Analytics but have the email sent to my domain account, and is a somewhat common thing for people to do if they have a domain account. In my experience, I can't log into both of those simultaneously from the same browser. 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. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto-Login to Google Analytics
How do you create a business account on google? I googled and just got the local business stuff. On Wed, Mar 10, 2010 at 6:21 AM, Kevin Pepperman chorno...@gmail.comwrote: Ben Nadel's CFHttpSession.cfc may be able to do this, I have not tried it yet-- but it mimics browser sessions. http://www.bennadel.com/projects/cfhttp-session.htm logged out from your own Gmail account and into another Google account for the analytics. Just as a side note: You can log into 2 gmail accounts in the same browser as once as long as one of them is a business account. :) I do it all the time. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
chossing a methodolgy
I've been coding CF for around 12 years now. I've been using fusebox 3 since it came out and love it. I can do a site pretty quick with it and I'm very comfortable there. So comfortable that I haven't looked any further. Not a good thing for growth. As I've grown as a developer, my applications have become more comlex, and the way some things are done in fusebox 3 feel a bit kludgy to me now. So, It's time to try something new. I tried fusebox 4 for a few days when it came out, couldn't get the basic app to work, and gave up. I'm willing to give it another go, and noticed they are up to 5.5.1 now. I'm considering investing the time to give it another try. The documentation link under Learning Fusebox for 5.5 is broken. Only tutorials are for fusebox 4 and earlier. The book is $40, a bit much I think. So, before I spend $40 and, even more valuable to me, time, any recommendations? Is fusebox 5.5.1 worth it or should I go to something else? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: chossing a methodolgy
You're likely to get as many opinions as there are people on this list. I haven't used Fusebox in a while (for no particular reason). ColdBox is a good modern MVC framework that comes with a lot of out-of-the-box tools if you want to try something new. http://www.coldboxframework.com/ If you want something uber-light weight and simple, try Sean's FW/1. http://fw1.riaforge.org/ If you want to play Framework Roulette, go to Charlie's framework list, close your eyes, and point your finger at the screen. :) http://www.carehart.org/cf411/#cffw_app ~Brad Original Message Subject: chossing a methodolgy From: Matthew Smith chedders...@gmail.com Date: Wed, March 10, 2010 10:52 am To: cf-talk cf-talk@houseoffusion.com I've been coding CF for around 12 years now. I've been using fusebox 3 since it came out and love it. I can do a site pretty quick with it and I'm very comfortable there. So comfortable that I haven't looked any further. Not a good thing for growth. As I've grown as a developer, my applications have become more comlex, and the way some things are done in fusebox 3 feel a bit kludgy to me now. So, It's time to try something new. I tried fusebox 4 for a few days when it came out, couldn't get the basic app to work, and gave up. I'm willing to give it another go, and noticed they are up to 5.5.1 now. I'm considering investing the time to give it another try. The documentation link under Learning Fusebox for 5.5 is broken. Only tutorials are for fusebox 4 and earlier. The book is $40, a bit much I think. So, before I spend $40 and, even more valuable to me, time, any recommendations? Is fusebox 5.5.1 worth it or should I go to something else? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Pretty XML
I've updated the UDF on my blog to deal with the closing-tag-on-same-line issue, as well as submitted it to cflib.org. cheers, banreyb On Sat, Mar 6, 2010 at 3:13 PM, Scott McAllister stmcallis...@gmail.com wrote: Got it! Thanks to all that replied and helped! Barney, I used your UDF and it worked as a fantastic starting point. The XML displayed to the screen and was formatted almost perfectly. The one issue that I had, which I think you mention in your blog post, was that it was increasing the indent on every line until it came across a closing tag at the start of a line. I added a fix that worked for my use case and would be more than willing to share. As you mentioned in your blog post the Googles didn't really help when I looked around for things. Have you ever thought of posting the UDF up on Riaforge.org or cflib.org? I found it highly useful. Thanks again! -Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Forms Processing: Updating Only Changed Data
We have several lengthy forms that are going to be used for updating records and various data. We are also looking at recording which form fields have been updated. Is there a means for updating only those records which have changed? I was thinking of looping through a form collection, comparing submitted vs. existing database values, storing any changed values and then having a CFC process the SQL update. If this is a good starting point, how would I be able to update only those fields that need to be changed? For example if I have 100 fields and only 10 have been updated, how can I write a query to update only those 10 fields? Thanks in advance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Phantom Scheduled Tasks
Its a bit of a kludge - but could you add some cfif code to check the time and if it didn't meet the criteria it wouldn't process? I.e. if the task is supposed to fire every 12 minutes - check the time when running the task and if it isn't :12, :24, :36, :48, or :00 - then don't execute. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: choosing a methodology
Fusebox seems to be end of life what with FW/1 and Coldbox really being the frameworks to know now. I'm certainly no FB hater. I used it for years and was once an elected advisory board member. My personal preference is FW/1. Lighter and less to learn than Coldbox. That being said these are not procedural frameworks and you're going to need to understand MVC and OO principles. -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Wednesday, March 10, 2010 11:52 AM To: cf-talk Subject: chossing a methodolgy I've been coding CF for around 12 years now. I've been using fusebox 3 since it came out and love it. I can do a site pretty quick with it and I'm very comfortable there. So comfortable that I haven't looked any further. Not a good thing for growth. As I've grown as a developer, my applications have become more comlex, and the way some things are done in fusebox 3 feel a bit kludgy to me now. So, It's time to try something new. I tried fusebox 4 for a few days when it came out, couldn't get the basic app to work, and gave up. I'm willing to give it another go, and noticed they are up to 5.5.1 now. I'm considering investing the time to give it another try. The documentation link under Learning Fusebox for 5.5 is broken. Only tutorials are for fusebox 4 and earlier. The book is $40, a bit much I think. So, before I spend $40 and, even more valuable to me, time, any recommendations? Is fusebox 5.5.1 worth it or should I go to something else? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: choosing a methodology
If you like procedural, fb3lite is a extra-super-lightweight combination of FB3 and FB5 that I built a few years ago. http://www.barneyb.com/barneyblog/projects/fb3lite/ The framework is a whopping 72 lines long, but I use it for pretty much everything I do, and after I used it for a couple projects at work, it's pretty much taken over everything we do because of it's simplicity. It's unapologetically bare-bones, and only handles front-controller responsibilities, but if that's what you're looking for it's a great tool. cheers, barneyb On Wed, Mar 10, 2010 at 10:14 AM, LRS Scout lrssc...@gmail.com wrote: Fusebox seems to be end of life what with FW/1 and Coldbox really being the frameworks to know now. I'm certainly no FB hater. I used it for years and was once an elected advisory board member. My personal preference is FW/1. Lighter and less to learn than Coldbox. That being said these are not procedural frameworks and you're going to need to understand MVC and OO principles. -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Wednesday, March 10, 2010 11:52 AM To: cf-talk Subject: chossing a methodolgy I've been coding CF for around 12 years now. I've been using fusebox 3 since it came out and love it. I can do a site pretty quick with it and I'm very comfortable there. So comfortable that I haven't looked any further. Not a good thing for growth. As I've grown as a developer, my applications have become more comlex, and the way some things are done in fusebox 3 feel a bit kludgy to me now. So, It's time to try something new. I tried fusebox 4 for a few days when it came out, couldn't get the basic app to work, and gave up. I'm willing to give it another go, and noticed they are up to 5.5.1 now. I'm considering investing the time to give it another try. The documentation link under Learning Fusebox for 5.5 is broken. Only tutorials are for fusebox 4 and earlier. The book is $40, a bit much I think. So, before I spend $40 and, even more valuable to me, time, any recommendations? Is fusebox 5.5.1 worth it or should I go to something else? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Upgrading Multi-home CF8 to CF9 on a Solaris 10 server
What do I need to know about upgrading from CF8 to CF9 on a Solaris 10 server? Do I dare to try some type of upgrade path? Much of what I have read on the 'internets' say that archive, uninstall, install clean, and restore archive is a more recommended path. Do the members of CF-Talk agree with this? If so, how does one go about uninstalling CF8 from a Solaris 10 machine, I've never done that before. I see the following instructions in the documentation: Uninstall ColdFusion from UNIX 1. Log in as root. 2. Enter the following command to go to the cf_webapp_root/uninstall directory: cd cf_webapp_root/uninstall 3. Enter the following command: ./uninstall.sh 4. When the program completes, remove any remaining files and directories in the cf_webapp_root directory. Does the cf_webapp_root indicate I need to do this once for each ColdFusion instance|server in the JRun directory? If so, what does this do with the JRun - if anything? Does JRun need to be uninstalled separately or not at all? *** *OR* *** Am I looking at this completely wrong, do I install CF9 just as new sever(s) under my existing JRun? Is CF9 expecting to use an upgraded JVM then came with the original CF8? If it wants new can I upgrade the JVM without bothering the CF8 servers and then install new CF9 server. As you can see, I have many questions since I am such a newbe at this Solaris flavor of CF and I suspect little of my decade of experience with installing, uninstalling and upgrading Windows flavors apply to this new situation. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: choosing a methodology
Documentation for Fusebox 5.1 can be found at : http://trac.fusebox.org/fusebox/ Its not complete and at this point I don't think anyone has any intention of working with it. But it is available. Fusebox is still good if you are looking to write procedural code and transition to oo. It works well both ways. You can also incorporate Coldspring and/or Transfer. If you are comfortable with OO, then a whole other slew of confroller frameworks are now available. On Wed, Mar 10, 2010 at 1:14 PM, LRS Scout lrssc...@gmail.com wrote: Fusebox seems to be end of life what with FW/1 and Coldbox really being the frameworks to know now. I'm certainly no FB hater. I used it for years and was once an elected advisory board member. My personal preference is FW/1. Lighter and less to learn than Coldbox. That being said these are not procedural frameworks and you're going to need to understand MVC and OO principles. -Original Message- From: Matthew Smith [mailto:chedders...@gmail.com] Sent: Wednesday, March 10, 2010 11:52 AM To: cf-talk Subject: chossing a methodolgy I've been coding CF for around 12 years now. I've been using fusebox 3 since it came out and love it. I can do a site pretty quick with it and I'm very comfortable there. So comfortable that I haven't looked any further. Not a good thing for growth. As I've grown as a developer, my applications have become more comlex, and the way some things are done in fusebox 3 feel a bit kludgy to me now. So, It's time to try something new. I tried fusebox 4 for a few days when it came out, couldn't get the basic app to work, and gave up. I'm willing to give it another go, and noticed they are up to 5.5.1 now. I'm considering investing the time to give it another try. The documentation link under Learning Fusebox for 5.5 is broken. Only tutorials are for fusebox 4 and earlier. The book is $40, a bit much I think. So, before I spend $40 and, even more valuable to me, time, any recommendations? Is fusebox 5.5.1 worth it or should I go to something else? Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
-The good news... The cfhttp call is working now. When I tried it in the .cfc I disabled the .cfm view. When that didn't work I put the cfhttp call in the .cfm but forgot to reenable the view. -The bad news... The cfhttp call did not fix the problem. Cold Fusion Scheduled Task calls Event1 Event1 calls Event2 Five minutes exactly passes and Event2 gets fired again Event1 does not get called again No Cold Fusion Scheduled Task can be found to fire Event2. In any event how would it know to fire five minutes after Event1 is called. -The weird news... This code failed to stop and let me look at the values in cfhttp. cfhttp method=get url=#local.desiredEvent# cfhttp = cfdump var=#cfhttp# var=cfhttp cfabort / This problem is killing me. Bryan -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Wednesday, March 10, 2010 9:32 AM To: cf-talk Subject: Re: Phantom Scheduled Tasks Dump cfhttp after the call and it will show you useful information (run the page in the browser so you can see the dump). Look at the status values and response for clues as to what's going. - Gabriel On Wed, Mar 10, 2010 at 9:23 AM, Bryan S bryansgroup...@gmail.com wrote: Well, I think I know why I didn't use that originally. It is not working. I am probably doing something dumb but I haven't been able to Google this problem away. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Phantom Scheduled Tasks
Also, what version of CF are you running? - Gabriel On Wed, Mar 10, 2010 at 1:43 PM, Bryan S bryansgroup...@gmail.com wrote: -The good news... The cfhttp call is working now. When I tried it in the .cfc I disabled the .cfm view. When that didn't work I put the cfhttp call in the .cfm but forgot to reenable the view. -The bad news... The cfhttp call did not fix the problem. Cold Fusion Scheduled Task calls Event1 Event1 calls Event2 Five minutes exactly passes and Event2 gets fired again Event1 does not get called again No Cold Fusion Scheduled Task can be found to fire Event2. In any event how would it know to fire five minutes after Event1 is called. -The weird news... This code failed to stop and let me look at the values in cfhttp. cfhttp method=get url=#local.desiredEvent# cfhttp = cfdump var=#cfhttp# var=cfhttp cfabort / This problem is killing me. Bryan -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Wednesday, March 10, 2010 9:32 AM To: cf-talk Subject: Re: Phantom Scheduled Tasks Dump cfhttp after the call and it will show you useful information (run the page in the browser so you can see the dump). Look at the status values and response for clues as to what's going. - Gabriel On Wed, Mar 10, 2010 at 9:23 AM, Bryan S bryansgroup...@gmail.com wrote: Well, I think I know why I didn't use that originally. It is not working. I am probably doing something dumb but I haven't been able to Google this problem away. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
In event 2, put in something that saves off all the CGI/form/url variables to a file before it does any other processing. Then you can look at the file for the second run and see what kicked it off. -Original Message- From: Bryan S [mailto:bryansgroup...@gmail.com] Sent: Wednesday, March 10, 2010 1:43 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks -The good news... The cfhttp call is working now. When I tried it in the .cfc I disabled the .cfm view. When that didn't work I put the cfhttp call in the .cfm but forgot to reenable the view. -The bad news... The cfhttp call did not fix the problem. Cold Fusion Scheduled Task calls Event1 Event1 calls Event2 Five minutes exactly passes and Event2 gets fired again Event1 does not get called again No Cold Fusion Scheduled Task can be found to fire Event2. In any event how would it know to fire five minutes after Event1 is called. -The weird news... This code failed to stop and let me look at the values in cfhttp. cfhttp method=get url=#local.desiredEvent# cfhttp = cfdump var=#cfhttp# var=cfhttp cfabort / This problem is killing me. Bryan -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Wednesday, March 10, 2010 9:32 AM To: cf-talk Subject: Re: Phantom Scheduled Tasks Dump cfhttp after the call and it will show you useful information (run the page in the browser so you can see the dump). Look at the status values and response for clues as to what's going. - Gabriel On Wed, Mar 10, 2010 at 9:23 AM, Bryan S bryansgroup...@gmail.com wrote: Well, I think I know why I didn't use that originally. It is not working. I am probably doing something dumb but I haven't been able to Google this problem away. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Phantom Scheduled Tasks
Did you declare var twice in your cfdump like posted? I'd remove the second var as it may not like that. - Gabriel On Wed, Mar 10, 2010 at 1:43 PM, Bryan S bryansgroup...@gmail.com wrote: -The good news... The cfhttp call is working now. When I tried it in the .cfc I disabled the .cfm view. When that didn't work I put the cfhttp call in the .cfm but forgot to reenable the view. -The bad news... The cfhttp call did not fix the problem. Cold Fusion Scheduled Task calls Event1 Event1 calls Event2 Five minutes exactly passes and Event2 gets fired again Event1 does not get called again No Cold Fusion Scheduled Task can be found to fire Event2. In any event how would it know to fire five minutes after Event1 is called. -The weird news... This code failed to stop and let me look at the values in cfhttp. cfhttp method=get url=#local.desiredEvent# cfhttp = cfdump var=#cfhttp# var=cfhttp cfabort / This problem is killing me. Bryan -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Wednesday, March 10, 2010 9:32 AM To: cf-talk Subject: Re: Phantom Scheduled Tasks Dump cfhttp after the call and it will show you useful information (run the page in the browser so you can see the dump). Look at the status values and response for clues as to what's going. - Gabriel On Wed, Mar 10, 2010 at 9:23 AM, Bryan S bryansgroup...@gmail.com wrote: Well, I think I know why I didn't use that originally. It is not working. I am probably doing something dumb but I haven't been able to Google this problem away. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Forms Processing: Updating Only Changed Data
The first thing that jumps out at me would be to have hidden form fields in the form that contain the original values. Then, when you're processing the form any value that doesn't match its corresponding hidden value has been changed. thanks, eric cobb ecar technologies, llc http://www.cfgears.com Blizzm wrote: We have several lengthy forms that are going to be used for updating records and various data. We are also looking at recording which form fields have been updated. Is there a means for updating only those records which have changed? I was thinking of looping through a form collection, comparing submitted vs. existing database values, storing any changed values and then having a CFC process the SQL update. If this is a good starting point, how would I be able to update only those fields that need to be changed? For example if I have 100 fields and only 10 have been updated, how can I write a query to update only those 10 fields? Thanks in advance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
Gabriel O.K. I fixed the problem with the cfdump having two vars and no label but prior to reading your post showing my oversight I tried to do some file logging as shown below. The results of the top call to logEntry show in the file but the results of the second call do not. This occurred with cflocation as well. Once it gets to that line it doesn't go past it in the .cfm cfset local.logEntry = specialDebugging-local.desiredEvent-from-redirect-scheduled-task.cfm= local.desiredEvent / cfset logEntry(flexcomm-schedule-results,specialDebugging,local.logEntry) / cfhttp method=get url=#local.desiredEvent# cfset local.logEntry = specialDebugging-AFTER CFHTTP-from-redirect-scheduled-task.cfm= / cfset logEntry(flexcomm-schedule-results,specialDebugging,local.logEntry) / cfhttp = cfdump var=#cfhttp# label=cfhttp cfabort / Bryan Did you declare var twice in your cfdump like posted? I'd remove the second var as it may not like that. - Gabriel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
Thanks for trying John but this won't help me. There are only certain conditions when I don't want another report to start. When the server has sufficient resources to process another report I want multiple reports to run simultaneously. Event1 checks if those conditions exist. Bryan -Original Message- From: John Drake [mailto:char...@ohmss.info] Sent: Wednesday, March 10, 2010 12:53 PM To: cf-talk Subject: Re: Phantom Scheduled Tasks Its a bit of a kludge - but could you add some cfif code to check the time and if it didn't meet the criteria it wouldn't process? I.e. if the task is supposed to fire every 12 minutes - check the time when running the task and if it isn't :12, :24, :36, :48, or :00 - then don't execute. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
Gabriel We are running Cold Fusion 7 and there is no indication that is going to change any time soon. Thanks very much for trying to help. Bryan -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Wednesday, March 10, 2010 2:00 PM To: cf-talk Subject: Re: Phantom Scheduled Tasks Also, what version of CF are you running? - Gabriel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
I have code that dumps any exception to a file. Previously I put a cfthrow in Event2 just after it started the report. This dumped the stack trace to a file. There was nothing before the call to Event2 besides the normal Mach-II event handling stuff. Bryan -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, March 10, 2010 1:54 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks In event 2, put in something that saves off all the CGI/form/url variables to a file before it does any other processing. Then you can look at the file for the second run and see what kicked it off. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Forms Processing: Updating Only Changed Data
Some of the answer depends on your overall architecture. The first step would be to retrieve the relevant database record using the ID passed from your form. That would give you, in some manner (a query record, a bean, whatever) a representation of the existing data. Then you could write a routine that compares the values of the retrieved record/bean with those submitted in the form. You might also think of this as two different tasks: 1) updating the record, and 2) recording (elsewhere) the changes. The second task is the audit, of course. That's why you're doing the comparison. As for the first, there's no particular reason to worry about which fields have been changed when you're updating the record. Just use all the form fields and do an update. By definition, the changes will be recorded and the data that has not changed will remain the same. That avoids the necessity of writing a complex dynamic update statement, which could be a big benefit with as many fields as you seem to have. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
Bryan, I'm just talking about a simple file with this information. Have it save for every call not just exceptions. Then you can see things like the browser used. If it is the cf scheduler that is somehow kicking it off then cfscheduler will be listed as the browser (or something similar). If it's a cflocation from another page, then it should show the http-referrer of the page. Just starting with the basics to make sure that it isn't something simple that would *NEVER* happen. You know those things that bite you in the A** because every time you thought well it's not that. (Happens to me quite often) Steve -Original Message- From: Bryan S [mailto:bryansgroup...@gmail.com] Sent: Wednesday, March 10, 2010 2:15 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks I have code that dumps any exception to a file. Previously I put a cfthrow in Event2 just after it started the report. This dumped the stack trace to a file. There was nothing before the call to Event2 besides the normal Mach-II event handling stuff. Bryan -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, March 10, 2010 1:54 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks In event 2, put in something that saves off all the CGI/form/url variables to a file before it does any other processing. Then you can look at the file for the second run and see what kicked it off. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Pretty XML
Cool! http://cflib.org/udf/indentXml ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Forms Processing: Updating Only Changed Data
After reading my answer, I realize the way I worded it may be confusing. Here's an example. On your form: input type=hidden name=Val1_orig value=#val1# input type=text name=Val1 value=#val1# On your processing page. cfif form.Val1 neq form.Val1_orig !--- this element has been changed. --- /cfif That's the basics of what I was trying to get at. thanks, eric cobb ecar technologies, llc http://www.cfgears.com Eric Cobb wrote: The first thing that jumps out at me would be to have hidden form fields in the form that contain the original values. Then, when you're processing the form any value that doesn't match its corresponding hidden value has been changed. thanks, eric cobb ecar technologies, llc http://www.cfgears.com Blizzm wrote: We have several lengthy forms that are going to be used for updating records and various data. We are also looking at recording which form fields have been updated. Is there a means for updating only those records which have changed? I was thinking of looping through a form collection, comparing submitted vs. existing database values, storing any changed values and then having a CFC process the SQL update. If this is a good starting point, how would I be able to update only those fields that need to be changed? For example if I have 100 fields and only 10 have been updated, how can I write a query to update only those 10 fields? Thanks in advance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
Steve I already have logging code in there and it is storing the cgi.remote-addr the logged in user and information about the report it just started. As mentioned previously, I know what the stack trace is. It will be easy for me to add other variables but I can't think of any that would be useful in debugging this. Which variables do you think will help in this situation? I will add them to my existing logging. Bryan -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, March 10, 2010 2:35 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks Bryan, I'm just talking about a simple file with this information. Have it save for every call not just exceptions. Then you can see things like the browser used. If it is the cf scheduler that is somehow kicking it off then cfscheduler will be listed as the browser (or something similar). If it's a cflocation from another page, then it should show the http-referrer of the page. Just starting with the basics to make sure that it isn't something simple that would *NEVER* happen. You know those things that bite you in the A** because every time you thought well it's not that. (Happens to me quite often) Steve -Original Message- From: Bryan S [mailto:bryansgroup...@gmail.com] Sent: Wednesday, March 10, 2010 2:15 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks I have code that dumps any exception to a file. Previously I put a cfthrow in Event2 just after it started the report. This dumped the stack trace to a file. There was nothing before the call to Event2 besides the normal Mach-II event handling stuff. Bryan -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, March 10, 2010 1:54 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks In event 2, put in something that saves off all the CGI/form/url variables to a file before it does any other processing. Then you can look at the file for the second run and see what kicked it off. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Data pivot problem (brain isn't working right today)
Hi all, Got a problem trying to convert a many to many relationship to a grid. There are three tables (defined below), and I need the output in a certain way (also defined below). I've done this before, but for the life of me I can't remember how. Table 1 (Target_Stratifications): Stratification varchar(100) not null primary key Strat_owner varchar(100) not null Table 2 (Target_Types): Target_type varchar(15) not null primary key Target_default numeric(9, 4) not null default 0 Target_Tolerance numeric(9, 4) not null default 0 Table 3 (Target_Targets): Stratification varchar(100) not null Target_type varchar(15) not null Target numeric(9, 4) not null default 0 *Primary Key (stratification, target_type) * [Stratification] References Target_Stratifications.stratification [on update cascade, on delete cascade] * [target_type] References Target_Types.target_type [on update cascade, on delete cascade] It's a pretty normalized set of tables. In stratifications is a list of proper names, and in target types is the Proper name for the target of the measure that is being worked on along with default values and tolerances. I need to get the data in this format (| used just to separate the columns, the actual result will be put in a cfgrid): Stratification|Target_Type(1)|Target_Type(2)|Target_Type(3)|Target_Type( 4)|...|Target_Type(n) Steve|100|50|25|10|...|15 Mike|25|75|2|100|...|75 Can someone push me in the right direction? Thanks, Steve ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
Bryan, I normally save all of CGI/Form/URL. The main CGI ones to look at though are: Cgi.http_referer, cgi.http_user_agent, cgi.remote_addr, cgi.request_method, cgi.script_name If cgi.remote_addr is the ip of the server then the server made the call. User agent helps to see if it was the scheduler or not. Script_name ensures that it isn't some old version (name_old.cfm) laying around that is getting called somehow. Request method helps if this comes from a form, if the method is get, then something looped around and called it. Steve -Original Message- From: Bryan S [mailto:bryansgroup...@gmail.com] Sent: Wednesday, March 10, 2010 2:48 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks Steve I already have logging code in there and it is storing the cgi.remote-addr the logged in user and information about the report it just started. As mentioned previously, I know what the stack trace is. It will be easy for me to add other variables but I can't think of any that would be useful in debugging this. Which variables do you think will help in this situation? I will add them to my existing logging. Bryan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Pretty XML
On Wed, Mar 10, 2010 at 2:31 PM, Scott McAllister stmcallis...@gmail.comwrote: Cool! http://cflib.org/udf/indentXml Nice one!!! I'm testing new API calls today, this was already worth the time to download and add to my utilities LOL ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Phantom Scheduled Tasks
Steve Thanks very much. I've added those to my code and will run another series of tests to see if anything useful shows up. The logging that I'm doing only works with string so I can't just dump the whole cgi form and url scopes to a file without specifying each one and then the log gets kind of unwieldy with all of that in there. Bryan -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Wednesday, March 10, 2010 3:33 PM To: cf-talk Subject: RE: Phantom Scheduled Tasks Bryan, I normally save all of CGI/Form/URL. The main CGI ones to look at though are: Cgi.http_referer, cgi.http_user_agent, cgi.remote_addr, cgi.request_method, cgi.script_name If cgi.remote_addr is the ip of the server then the server made the call. User agent helps to see if it was the scheduler or not. Script_name ensures that it isn't some old version (name_old.cfm) laying around that is getting called somehow. Request method helps if this comes from a form, if the method is get, then something looped around and called it. Steve ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto-Login to Google Analytics
http://www.google.com/services/ It is a paid service-- We recently converted a company I work for from Exchange to Google business-- They are all very happy with it. -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: chossing a methodolgy
There are so many really good frameworks out now that I would use almost anything before fighting with yet another version of Fusebox. I'm moving everything to FW/1 as it is clean, simple and easy to use. On Wed, Mar 10, 2010 at 8:52 AM, Matthew Smith chedders...@gmail.com wrote: So, before I spend $40 and, even more valuable to me, time, any recommendations? Is fusebox 5.5.1 worth it or should I go to something else ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading Multi-home CF8 to CF9 on a Solaris 10 server
What do I need to know about upgrading from CF8 to CF9 on a Solaris 10 server? Do I dare to try some type of upgrade path? Much of what I have read on the 'internets' say that archive, uninstall, install clean, and restore archive is a more recommended path. Do the members of CF-Talk agree with this? There is no upgrade path for multi-server. There is only uninstall and reinstall, if you want to replace one multi-server version with another. If so, how does one go about uninstalling CF8 from a Solaris 10 machine, I've never done that before. I see the following instructions in the documentation: Uninstall ColdFusion from UNIX 1. Log in as root. 2. Enter the following command to go to the cf_webapp_root/uninstall directory: cd cf_webapp_root/uninstall 3. Enter the following command: ./uninstall.sh 4. When the program completes, remove any remaining files and directories in the cf_webapp_root directory. Does the cf_webapp_root indicate I need to do this once for each ColdFusion instance|server in the JRun directory? If so, what does this do with the JRun - if anything? Does JRun need to be uninstalled separately or not at all? Fortunately, there isn't much that can go wrong uninstalling. Just follow those instructions, and this will uninstall JRun along with your CF instances. If you have /CFIDE files in your web root, you can go ahead and delete those as well manually. Since you're using Apache, you can simply edit httpd.conf to remove the connection between Apache and CF if the uninstaller doesn't do that for you (and if you're using multiple Apache virtual hosts, you'll almost certainly end up editing this manually anyway). Am I looking at this completely wrong, do I install CF9 just as new sever(s) under my existing JRun? Is CF9 expecting to use an upgraded JVM then came with the original CF8? If it wants new can I upgrade the JVM without bothering the CF8 servers and then install new CF9 server. You could install a CF9 EAR into your existing CF8/JRun install, but CF9 does use a newer JVM, which you'd need to set up separately if you took this approach. Upgrading your JVM will, by default, bother your CF8 servers, since by default all JRun instances use the same JVM. You can, of course, change that, but I think the simplest approach is just to uninstall the whole thing. Make sure you save whatever settings you want to preserve by creating a CAR file before uninstalling. 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 cente ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto-Login to Google Analytics
http://www.google.com/services/ It is a paid service-- We recently converted a company I work for from Exchange to Google business-- They are all very happy with it. Actually, for Apps specifically, you can go directly there: http://www.google.com/a/ We've been using this for figleaf.com for quite a while, after migrating from Exchange. Fig Leaf Software is also a Google Enterprise partner, and we provide implementation and official Google Enterprise training on Apps end-user functionality, Apps administration, and Google Message Security/Google Message Discovery (aka Postini). Feel free to get in touch with me if you have any questions about Apps! 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. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data pivot problem (brain isn't working right today)
Syntax not exact, but this is the process. cfquery name=getStrats Select Stratification from Target_Stratifications /cfquery cfquery name=getTargets Select Target_Type from Target_Types /cfquery table !--- Set headings --- tr tdName/td cfloop query = getTargets td#Target_Type#/td /cfloop /tr !--- Do Table --- cfloop query = getStrats tr td#Stratification#/td cfloop query = getTarget cfquery name= getTargetTargets select * from Target_Targets where Stratification = getStrats.Stratification and Target_type = getTargets.Target_type /cfquery td#getTargetTargets.Target#/td /cfloop /tr /cfloop /table On Wed, Mar 10, 2010 at 12:12 PM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Hi all, Got a problem trying to convert a many to many relationship to a grid. There are three tables (defined below), and I need the output in a certain way (also defined below). I've done this before, but for the life of me I can't remember how. Table 1 (Target_Stratifications): Stratification varchar(100) not null primary key Strat_owner varchar(100) not null Table 2 (Target_Types): Target_type varchar(15) not null primary key Target_default numeric(9, 4) not null default 0 Target_Tolerance numeric(9, 4) not null default 0 Table 3 (Target_Targets): Stratification varchar(100) not null Target_type varchar(15) not null Target numeric(9, 4) not null default 0 *Primary Key (stratification, target_type) * [Stratification] References Target_Stratifications.stratification [on update cascade, on delete cascade] * [target_type] References Target_Types.target_type [on update cascade, on delete cascade] It's a pretty normalized set of tables. In stratifications is a list of proper names, and in target types is the Proper name for the target of the measure that is being worked on along with default values and tolerances. I need to get the data in this format (| used just to separate the columns, the actual result will be put in a cfgrid): Stratification|Target_Type(1)|Target_Type(2)|Target_Type(3)|Target_Type( 4)|...|Target_Type(n) Steve|100|50|25|10|...|15 Mike|25|75|2|100|...|75 Can someone push me in the right direction? Thanks, Steve ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: chossing a methodolgy
so two people mention fw/1. Haven't had a chance to look at it yet but will today. Any tips for someone coming from fb3? On Wed, Mar 10, 2010 at 4:21 PM, Maureen mamamaur...@gmail.com wrote: There are so many really good frameworks out now that I would use almost anything before fighting with yet another version of Fusebox. I'm moving everything to FW/1 as it is clean, simple and easy to use. On Wed, Mar 10, 2010 at 8:52 AM, Matthew Smith chedders...@gmail.com wrote: So, before I spend $40 and, even more valuable to me, time, any recommendations? Is fusebox 5.5.1 worth it or should I go to something else ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: chossing a methodolgy
Expect to accomplish a lot more with less work. ;-. On Wed, Mar 10, 2010 at 4:10 PM, Matthew Smith chedders...@gmail.com wrote: so two people mention fw/1. Haven't had a chance to look at it yet but will today. Any tips for someone coming from fb ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Make HomeSite+ Open Source? (WAS: RE: Development Apps - Does anyone use homesite still?)
I still use HOMESITE. I tried CFECLIPSE and I tried the beta version of Adobes CF developer thing. Both are nice, both are a drain on system resources, slow, and bloated. Yes there are some nice features, but there is something to be said for just have a nice straight up, low burden code editing tool with insight, and a good search/replace routine. And yes, I use Dreamweaver too... but it's also slow and bloated. That sums up my feelings exactly, except that I have tried dreamweaver, but don't use it. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
