Re: SQL Server and Nulls
dbfield = cfqueryparam cfsqltype=cf_sql_tinyint value=#mydatefield# null=#yesnoformat(mydatefield is '')# On Fri, Apr 17, 2015 at 3:58 PM, Robert Harrison rharri...@aimg.com wrote: In an update query, to a tinyint field which allows nulls, I have the update dbfield=#mydatefield# If mydatefield has no value, sql is throwing an error. The field allows nulls. I've never had to say if then NULL before. What the heck? Robert Harrison Full Stack Developer AIMG rharri...@aimg.com Main Office: 704-321-1234 ext.118 Direct Line: 516-302-4345 www.aimg.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Microsoft update breaks ACF10 admin?
Thanks. Restarting the CF service fixed the issue(!) Scary/weird. On Sat, Apr 11, 2015, 5:44 PM M.A. Kruger mkru...@cfwebtools.com wrote: john. my ops team says to be sure you have upgraded your connectors after patching your cf 10 server to the latest patch level. Sent from my iPhone On Apr 11, 2015, at 2:09 PM, John M Bliss bliss.j...@gmail.com wrote: Hello. Yesterday, I installed Microsoft Updates for Windows Server 2012 and today, from Internet Explorer on server, I can no longer surf to: http://127.0.0.1/CFIDE/administrator/ It just spins and spins. Any ideas? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Microsoft update breaks ACF10 admin?
Hello. Yesterday, I installed Microsoft Updates for Windows Server 2012 and today, from Internet Explorer on server, I can no longer surf to: http://127.0.0.1/CFIDE/administrator/ It just spins and spins. Any ideas? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I/O Exception: Name in certificate does not match host name
I think you'll need to update the hosts file so that: prerelease-api.anotherdomain.com ...points to the right IP and then refer to: prerelease-api.anotherdomain.com ...in your code. That should make everything line up. On Wed, Apr 8, 2015 at 5:23 AM, Ian Chapman ian.chap...@melodimedia.co.uk wrote: Hi Guys, Some time ago I posted a question about an error we were getting with MX7.1 http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353955 I have a similar problem but I believe the client is using a widlcard certificate so I get the error: I/O Exception: Name in certificate `*.domain.net' does not match host name `prerelease-api.anotherdomain.com' The difference this time is the '*.domain.net', previously it was for a determined sub domain so an aaddition to the host file resolved it. I've trid a number of things with the host file but as it's a wildcard I don't see what I would add to the hosts as any number of subdomains on domain.net could resovle to a number of IP's. Any ideas? Regards, Ian. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I/O Exception: Name in certificate does not match host name
What Dave said. On Wed, Apr 8, 2015 at 10:01 AM, Dave Watts dwa...@figleaf.com wrote: I think you'll need to update the hosts file so that: prerelease-api.anotherdomain.com ...points to the right IP and then refer to: prerelease-api.anotherdomain.com ...in your code. That should make everything line up. I think this is nearly right, except that you'll need to find the IP address for prerelease-api.anotherdomain.com and create a hosts entry for prerelease-api.domain.com that points to this IP address. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business (SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ACF10 mail and Windows Server 2012
Working on configuring ACF10 mail on Windows Server 2012. I followed these steps: http://blog.hyperfive.com/2013/07/how-to-setup-internal-smtp-service-for.html ...but, in ACF10 admin interface Server Settings Mail when I set Mail Server to localhost, check Verify mail server connection, and click Submit, I get Connection Verification Failed! Any ideas what I'm missing? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360410 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ACF10 mail and Windows Server 2012
In the SMTP Server properties, I changed the IP from one of the IP's on the box to all unassigned and it worked. Next question: resulting plaintext emails appear to have carriage returns / line feeds stripped out. Any idea how to get those back? On Tue, Apr 7, 2015 at 7:52 AM, John M Bliss bliss.j...@gmail.com wrote: Working on configuring ACF10 mail on Windows Server 2012. I followed these steps: http://blog.hyperfive.com/2013/07/how-to-setup-internal-smtp-service-for.html ...but, in ACF10 admin interface Server Settings Mail when I set Mail Server to localhost, check Verify mail server connection, and click Submit, I get Connection Verification Failed! Any ideas what I'm missing? -- John Bliss - http://www.linkedin.com/in/jbliss -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ACF10 mail and Windows Server 2012
Yes. The code didn't change. Just moved from 32 bit Windows Server 2003 to 64 bit Windows Server 2012 and 32 bit ACF10 to 64 bit ACF10. On Tue, Apr 7, 2015 at 10:49 AM, Russ Michaels r...@michaels.me.uk wrote: are you sure you do not have the emails set to send as HTML ? On Tue, Apr 7, 2015 at 1:19 PM, John M Bliss bliss.j...@gmail.com wrote: In the SMTP Server properties, I changed the IP from one of the IP's on the box to all unassigned and it worked. Next question: resulting plaintext emails appear to have carriage returns / line feeds stripped out. Any idea how to get those back? On Tue, Apr 7, 2015 at 7:52 AM, John M Bliss bliss.j...@gmail.com wrote: Working on configuring ACF10 mail on Windows Server 2012. I followed these steps: http://blog.hyperfive.com/2013/07/how-to-setup-internal-smtp-service-for.html ...but, in ACF10 admin interface Server Settings Mail when I set Mail Server to localhost, check Verify mail server connection, and click Submit, I get Connection Verification Failed! Any ideas what I'm missing? -- John Bliss - http://www.linkedin.com/in/jbliss -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ACF10 mail and Windows Server 2012
No. Interestingly, it appears that some carriage returns / line feeds remain. The ones that got stripped out are ones inside of: cfmail cfloop#loop.output# /cfloop /cfmail ...where that carriage return / line feed between #loop.output# and /cfloop is not coming through and all elements of the loop are output on one line. This worked in my 32 bit environment. Encoding issue? On Tue, Apr 7, 2015 at 2:43 PM, Dean Lawrence dean...@gmail.com wrote: Have you looked at the raw source of the email to make sure that CF is not placing the text in an html mailpart? On Tue, Apr 7, 2015 at 1:21 PM John M Bliss bliss.j...@gmail.com wrote: Yes. The code didn't change. Just moved from 32 bit Windows Server 2003 to 64 bit Windows Server 2012 and 32 bit ACF10 to 64 bit ACF10. On Tue, Apr 7, 2015 at 10:49 AM, Russ Michaels r...@michaels.me.uk wrote: are you sure you do not have the emails set to send as HTML ? On Tue, Apr 7, 2015 at 1:19 PM, John M Bliss bliss.j...@gmail.com wrote: In the SMTP Server properties, I changed the IP from one of the IP's on the box to all unassigned and it worked. Next question: resulting plaintext emails appear to have carriage returns / line feeds stripped out. Any idea how to get those back? On Tue, Apr 7, 2015 at 7:52 AM, John M Bliss bliss.j...@gmail.com wrote: Working on configuring ACF10 mail on Windows Server 2012. I followed these steps: http://blog.hyperfive.com/2013/07/how-to-setup-internal- smtp-service-for.html ...but, in ACF10 admin interface Server Settings Mail when I set Mail Server to localhost, check Verify mail server connection, and click Submit, I get Connection Verification Failed! Any ideas what I'm missing? -- John Bliss - http://www.linkedin.com/in/jbliss -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Test
Yes. On Mon, Mar 30, 2015 at 10:29 PM, wrote: Is this list working? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sudden error with CFHTTP ans SSL
I also once solved this by editing the hosts file on the server and adding lines to force the name on the cert to point to the right IP. On Tue, Mar 31, 2015 at 8:51 AM, Byron Mann byronos...@gmail.com wrote: What is the URL and does the domain name match the certificate exactly, meaning not a wildcard certificate. Could be PayPal updated their SSL certificate and is either a wildcard certificate or multi-site/domain certificate (not sure what these are really called). CF will not like it if the domain is www.domain.com, but the certificate is *.domain.com. In this case, you need to import the certificate to the java cacerts as a trusted certificate to by-pass the security matching. You can either do this from the command line, or by far the easier route is this extension to CF admin. http://certman.riaforge.org/ https://www.google.com/webhp?sourceid=chrome-instantion=1espv=2ie=UTF-8#q=import+ssl+certificate+coldfusion+9+to+cacerts ~Byron On Mon, Mar 30, 2015 at 12:34 PM, wrote: Hi, I have an application under CF 9 with a paiment module using Paypal. At the end of the process, Paypal acknowledges the paiement and my app calls a Paypal page to validate the whole operation. This is done with a CFHTTP call This application has been working fine for years with no modification, bur all of a sudden starting March 23rd, I get this error: I/O Exception: peer not authenticated It appears to be an error with the SSL certificate, but how come ? The Paypal site is verified by Verisign. What ca I do? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ACF10 32 - 64 bit
Hi. So we're moving from ACF10 32 bit to ACF10 64 bit. On ACF10 32 bit, we settled on: Minimum JVM Heap Size (in MB)1369 Maximum JVM Heap Size (in MB)1369 On the ACF10 64 bit box, we have 32 GB of RAM to play with. Given that this box is just: ACF10 The OS (Windows Server 2012) FusionReactor ...what's the best recommendation(s) for min/max heap to guarantee ACF10 always has as much RAM as it could possible want/need? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 404
I think it did. Then I deleted it. Genius. On Thu, Mar 5, 2015 at 3:54 PM, Dave Watts dwa...@figleaf.com wrote: Found it, I think: I was missing the IIS virtual directory /jakarta mapped to C:\ColdFusion10\config\wsconfig\1 Does that look right? Yes, you will need that. The web server configuration tool should have created that for you. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business (SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 404
In IIS, the handler for *.cfm is: C:\ColdFusion10\config\wsconfig\1\isapi_redirect.dll Does that look right...? Could this be a permissions issue...? On Thu, Mar 5, 2015 at 2:28 PM, John M Bliss bliss.j...@gmail.com wrote: Hi. I'm moving an ACF10 / FuseBox 5 site from Windows Server 2003 (32 bit) to Windows Server 2012 (64 bit) with new IIS, etc. My default fuse seems to work fine but whenever I specify another fuse like: http://www.domain.com/index.cfm?fuseaction=User.ShowLoginForm ...I'm getting the generic IIS 404 error. What am I missing...? -- John Bliss - http://www.linkedin.com/in/jbliss -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
404
Hi. I'm moving an ACF10 / FuseBox 5 site from Windows Server 2003 (32 bit) to Windows Server 2012 (64 bit) with new IIS, etc. My default fuse seems to work fine but whenever I specify another fuse like: http://www.domain.com/index.cfm?fuseaction=User.ShowLoginForm ...I'm getting the generic IIS 404 error. What am I missing...? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: 404
Found it, I think: I was missing the IIS virtual directory /jakarta mapped to C:\ColdFusion10\config\wsconfig\1 Does that look right? On Thu, Mar 5, 2015 at 3:14 PM, Dave Watts dwa...@figleaf.com wrote: In IIS, the handler for *.cfm is: C:\ColdFusion10\config\wsconfig\1\isapi_redirect.dll Does that look right...? Yes. Could this be a permissions issue...? Are you able to run any CF pages? If so, probably not. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business (SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ACF10 32 - 64 bit
In the old days, the wisdom was to make min and max match so that CF wasn't spending horsepower constantly re-sizing the heap. Is that no longer true? On Thu, Mar 5, 2015 at 7:08 PM, Dave Watts dwa...@figleaf.com wrote: Hi. So we're moving from ACF10 32 bit to ACF10 64 bit. On ACF10 32 bit, we settled on: Minimum JVM Heap Size (in MB)1369 Maximum JVM Heap Size (in MB)1369 On the ACF10 64 bit box, we have 32 GB of RAM to play with. Given that this box is just: ACF10 The OS (Windows Server 2012) FusionReactor ...what's the best recommendation(s) for min/max heap to guarantee ACF10 always has as much RAM as it could possible want/need? This question requires more information. How much memory did your application use in the 32-bit environment? Were you having out-of-memory issues in the old enviroment? Just because you have loads of memory doesn't mean you want CF to have to manage it all, unless it's going to use it. In the last week, we maxed out at 960 MB. OK, so maybe you'd leave the minimum heap size right around where it is now, and increase the maximum by 1.5 or 2 times the current value - these are just guesses, of course. See how that works, then change accordingly. If you're using Java 8 (which you can with the latest CF patches), you might want to look at your PermGen settings, as Java 8 doesn't really have a permanent generation any more. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business (SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ACF10 32 - 64 bit
In the last week, we maxed out at 960 MB. On Thu, Mar 5, 2015 at 5:35 PM, Dave Watts dwa...@figleaf.com wrote: Hi. So we're moving from ACF10 32 bit to ACF10 64 bit. On ACF10 32 bit, we settled on: Minimum JVM Heap Size (in MB)1369 Maximum JVM Heap Size (in MB)1369 On the ACF10 64 bit box, we have 32 GB of RAM to play with. Given that this box is just: ACF10 The OS (Windows Server 2012) FusionReactor ...what's the best recommendation(s) for min/max heap to guarantee ACF10 always has as much RAM as it could possible want/need? This question requires more information. How much memory did your application use in the 32-bit environment? Were you having out-of-memory issues in the old enviroment? Just because you have loads of memory doesn't mean you want CF to have to manage it all, unless it's going to use it. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business (SDVOSB) on GSA Schedule, and provides the highest caliber vendor- authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ACF10 and IIS8
So I'm looking at this: http://blogs.coldfusion.com/post.cfm/cautions-for-configuring-cf-10-with-iis-8-on-windows-2012-server ...and I'm here: 4) If all the above steps have been followed and if you are still getting the error, please verify that update 8 is installed properly by checking the log file under \cfusion\hf-updates\hf-10- 8\Adobe_ColdFusion_10_Update_8*.log The problem is that I can't figure out how to install update 8 without first having the IIS connector setup so that I can use the CFAdmin. Is there a way to install update 8 without logging in to the CFAdmin? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ACF10 and IIS8
I can't even find where to download the .jar. On Thu, Feb 26, 2015 at 3:01 PM, Russ Michaels r...@michaels.me.uk wrote: in most cases it is just a jar files that you stick in the updates folder. Have you tried manually downloading the update and seeing what it contains and if there are any manual install instructions On Thu, Feb 26, 2015 at 7:59 PM, John M Bliss bliss.j...@gmail.com wrote: So I'm looking at this: http://blogs.coldfusion.com/post.cfm/cautions-for-configuring-cf-10-with-iis-8-on-windows-2012-server ...and I'm here: 4) If all the above steps have been followed and if you are still getting the error, please verify that update 8 is installed properly by checking the log file under \cfusion\hf-updates\hf-10- 8\Adobe_ColdFusion_10_Update_8*.log The problem is that I can't figure out how to install update 8 without first having the IIS connector setup so that I can use the CFAdmin. Is there a way to install update 8 without logging in to the CFAdmin? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ACF10 and IIS8
Thanks! On Thu, Feb 26, 2015 at 3:02 PM, Wil Genovese jugg...@trunkful.com wrote: Configure the ColdFusion internal web server on port 8500 and then you have access to the CFAdmin without IIS. http://www.carehart.org/blog/client/index.cfm/2012/7/23/the-builtin-web-server-in-coldfusion-10-enabling-it-configuring-it-reconsidering-it Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Feb 26, 2015, at 1:59 PM, John M Bliss bliss.j...@gmail.com wrote: So I'm looking at this: http://blogs.coldfusion.com/post.cfm/cautions-for-configuring-cf-10-with-iis-8-on-windows-2012-server ...and I'm here: 4) If all the above steps have been followed and if you are still getting the error, please verify that update 8 is installed properly by checking the log file under \cfusion\hf-updates\hf-10- 8\Adobe_ColdFusion_10_Update_8*.log The problem is that I can't figure out how to install update 8 without first having the IIS connector setup so that I can use the CFAdmin. Is there a way to install update 8 without logging in to the CFAdmin? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ACF10 Mandatory Update
Working on this: https://helpx.adobe.com/coldfusion/kb/coldfusion-10-mandatory-update.html I have the update saved to: C:\ColdFusion10\cfusion\hf-updates\cf10_mdt_updt.zip ...and then, from: C:\ColdFusion10\jre\bin ...I run: java -jar C:\ColdFusion10\cfusion\hf-updates\cf10_mdt_updt.zip ...and get: Leaving javaSEA.main ...but nothing else happen. What am I missing? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion_10_WWEJ_win64.exe error
That's why I: ;-) I'm constantly posting dumb questions here. :-) On Feb 25, 2015 2:42 PM, Russ Michaels r...@michaels.me.uk wrote: Hey everyone does something dumb occasionally ð On Wed, Feb 25, 2015 at 19:38 PM, John M Bliss bliss.j...@gmail.com wrote: No. Come on, Russ, you've known me for, like, a decade on here! ;-) On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk javascript:; wrote: Not trying to install it on a 32bit os are you? On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com javascript:; wrote: Reinstalling ACF10 64 bit from physical media from Adobe and getting this when I run the installer: Fatal Application Error This Application has Unexpectedly Quit Invocation of this Java Application has caused an InvocationTargetException. This application will now exit. (LAX) Anyone else seen this? Fix? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360158 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion_10_WWEJ_win64.exe error
Reinstalling ACF10 64 bit from physical media from Adobe and getting this when I run the installer: Fatal Application Error This Application has Unexpectedly Quit Invocation of this Java Application has caused an InvocationTargetException. This application will now exit. (LAX) Anyone else seen this? Fix? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion_10_WWEJ_win64.exe error
No. Come on, Russ, you've known me for, like, a decade on here! ;-) On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk wrote: Not trying to install it on a 32bit os are you? On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com wrote: Reinstalling ACF10 64 bit from physical media from Adobe and getting this when I run the installer: Fatal Application Error This Application has Unexpectedly Quit Invocation of this Java Application has caused an InvocationTargetException. This application will now exit. (LAX) Anyone else seen this? Fix? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion_10_WWEJ_win64.exe error
Do you know where that's located? On Wed, Feb 25, 2015 at 4:13 PM, Russ Michaels r...@michaels.me.uk wrote: Try running as administrator. Take a look at the installer log for more info. On Wed, Feb 25, 2015 at 19:44 PM, John M Bliss bliss.j...@gmail.com wrote: That's why I: ;-) I'm constantly posting dumb questions here. :-) On Feb 25, 2015 2:42 PM, Russ Michaels r...@michaels.me.uk javascript:; wrote: Hey everyone does something dumb occasionally ð On Wed, Feb 25, 2015 at 19:38 PM, John M Bliss bliss.j...@gmail.com javascript:; wrote: No. Come on, Russ, you've known me for, like, a decade on here! ;-) On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk javascript:; javascript:; wrote: Not trying to install it on a 32bit os are you? On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com javascript:; javascript:; wrote: Reinstalling ACF10 64 bit from physical media from Adobe and getting this when I run the installer: Fatal Application Error This Application has Unexpectedly Quit Invocation of this Java Application has caused an InvocationTargetException. This application will now exit. (LAX) Anyone else seen this? Fix? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion_10_WWEJ_win64.exe error
Thanks. I installed 32 bit Java and edited that .lax file with: lax.installer.win32.internal.property.0=C:\\Program Files (x86)\\Java\\jre1.8.0_31\\bin\\java.exe lax.nl.current.vm=C:\\Program Files (x86)\\Java\\jre1.8.0_31\\bin\\java.exe ...and I'm getting the same error. What did I do wrong? On Wed, Feb 25, 2015 at 4:37 PM, Mark A Kruger mkru...@cfwebtools.com wrote: Sorry this one! http://www.coldfusionmuse.com/index.cfm/2010/2/24/CF8-Install-Windows-2003-64bit -mark -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, February 25, 2015 3:15 PM To: cf-talk Subject: Re: ColdFusion_10_WWEJ_win64.exe error Do you know where that's located? On Wed, Feb 25, 2015 at 4:13 PM, Russ Michaels r...@michaels.me.uk wrote: Try running as administrator. Take a look at the installer log for more info. On Wed, Feb 25, 2015 at 19:44 PM, John M Bliss bliss.j...@gmail.com wrote: That's why I: ;-) I'm constantly posting dumb questions here. :-) On Feb 25, 2015 2:42 PM, Russ Michaels r...@michaels.me.uk javascript:; wrote: Hey everyone does something dumb occasionally ðŸËÅ On Wed, Feb 25, 2015 at 19:38 PM, John M Bliss bliss.j...@gmail.com javascript:; wrote: No. Come on, Russ, you've known me for, like, a decade on here! ;-) On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk javascript:; javascript:; wrote: Not trying to install it on a 32bit os are you? On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com javascript:; javascript:; wrote: Reinstalling ACF10 64 bit from physical media from Adobe and getting this when I run the installer: Fatal Application Error This Application has Unexpectedly Quit Invocation of this Java Application has caused an InvocationTargetException. This application will now exit. (LAX) Anyone else seen this? Fix? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion_10_WWEJ_win64.exe error
Thanks, guys. This fixed it: http://www.instructables.com/id/How-to-install-coldfusion-10-64-bit-on-Windows-Ser/?ALLSTEPS On Wed, Feb 25, 2015 at 5:37 PM, Russ Michaels r...@michaels.me.uk wrote: did you already have a JRE installed ? it may be that CF is trying to use your pre-installed java to do the install, try removing it from your environment variables so that the cfinstaller can't find it and might not try to use it On Wed, Feb 25, 2015 at 10:07 PM, John M Bliss bliss.j...@gmail.com wrote: Thanks. I installed 32 bit Java and edited that .lax file with: lax.installer.win32.internal.property.0=C:\\Program Files (x86)\\Java\\jre1.8.0_31\\bin\\java.exe lax.nl.current.vm=C:\\Program Files (x86)\\Java\\jre1.8.0_31\\bin\\java.exe ...and I'm getting the same error. What did I do wrong? On Wed, Feb 25, 2015 at 4:37 PM, Mark A Kruger mkru...@cfwebtools.com wrote: Sorry this one! http://www.coldfusionmuse.com/index.cfm/2010/2/24/CF8-Install-Windows-2003-64bit -mark -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, February 25, 2015 3:15 PM To: cf-talk Subject: Re: ColdFusion_10_WWEJ_win64.exe error Do you know where that's located? On Wed, Feb 25, 2015 at 4:13 PM, Russ Michaels r...@michaels.me.uk wrote: Try running as administrator. Take a look at the installer log for more info. On Wed, Feb 25, 2015 at 19:44 PM, John M Bliss bliss.j...@gmail.com wrote: That's why I: ;-) I'm constantly posting dumb questions here. :-) On Feb 25, 2015 2:42 PM, Russ Michaels r...@michaels.me.uk javascript:; wrote: Hey everyone does something dumb occasionally ðŸËÅ On Wed, Feb 25, 2015 at 19:38 PM, John M Bliss bliss.j...@gmail.com javascript:; wrote: No. Come on, Russ, you've known me for, like, a decade on here! ;-) On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk javascript:; javascript:; wrote: Not trying to install it on a 32bit os are you? On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com javascript:; javascript:; wrote: Reinstalling ACF10 64 bit from physical media from Adobe and getting this when I run the installer: Fatal Application Error This Application has Unexpectedly Quit Invocation of this Java Application has caused an InvocationTargetException. This application will now exit. (LAX) Anyone else seen this? Fix? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion_10_WWEJ_win64.exe error
To be fair, ACF11 might be better...? On Wed, Feb 25, 2015 at 5:49 PM, Russ Michaels r...@michaels.me.uk wrote: I guess the installer still has not improved then, MEH! I haven't really bothered with CF since v9, I am well and truly in the Railo (Lucee) camp now. On Wed, Feb 25, 2015 at 10:39 PM, John M Bliss bliss.j...@gmail.com wrote: Thanks, guys. This fixed it: http://www.instructables.com/id/How-to-install-coldfusion-10-64-bit-on-Windows-Ser/?ALLSTEPS On Wed, Feb 25, 2015 at 5:37 PM, Russ Michaels r...@michaels.me.uk wrote: did you already have a JRE installed ? it may be that CF is trying to use your pre-installed java to do the install, try removing it from your environment variables so that the cfinstaller can't find it and might not try to use it On Wed, Feb 25, 2015 at 10:07 PM, John M Bliss bliss.j...@gmail.com wrote: Thanks. I installed 32 bit Java and edited that .lax file with: lax.installer.win32.internal.property.0=C:\\Program Files (x86)\\Java\\jre1.8.0_31\\bin\\java.exe lax.nl.current.vm=C:\\Program Files (x86)\\Java\\jre1.8.0_31\\bin\\java.exe ...and I'm getting the same error. What did I do wrong? On Wed, Feb 25, 2015 at 4:37 PM, Mark A Kruger mkru...@cfwebtools.com wrote: Sorry this one! http://www.coldfusionmuse.com/index.cfm/2010/2/24/CF8-Install-Windows-2003-64bit -mark -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, February 25, 2015 3:15 PM To: cf-talk Subject: Re: ColdFusion_10_WWEJ_win64.exe error Do you know where that's located? On Wed, Feb 25, 2015 at 4:13 PM, Russ Michaels r...@michaels.me.uk wrote: Try running as administrator. Take a look at the installer log for more info. On Wed, Feb 25, 2015 at 19:44 PM, John M Bliss bliss.j...@gmail.com wrote: That's why I: ;-) I'm constantly posting dumb questions here. :-) On Feb 25, 2015 2:42 PM, Russ Michaels r...@michaels.me.uk javascript:; wrote: Hey everyone does something dumb occasionally ðŸËÅ On Wed, Feb 25, 2015 at 19:38 PM, John M Bliss bliss.j...@gmail.com javascript:; wrote: No. Come on, Russ, you've known me for, like, a decade on here! ;-) On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk javascript:; javascript:; wrote: Not trying to install it on a 32bit os are you? On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com javascript:; javascript:; wrote: Reinstalling ACF10 64 bit from physical media from Adobe and getting this when I run the installer: Fatal Application Error This Application has Unexpectedly Quit Invocation of this Java Application has caused an InvocationTargetException. This application will now exit. (LAX) Anyone else seen this? Fix? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Builder 3
I'll add: while you're checking stuff out, be sure to check out: http://brackets.io Has a CFML extension, is super-fast lightweight, has great find-and-replace, and has amazing front-end dev tools. On Sat, Jan 10, 2015 at 12:23 PM, Rob Voyle robvo...@voyle.com wrote: Hi Steve I use cfbuilder 3 on my local development of applications (Win 7 machine). Having migrated from using Homesite (which I still use for its ease of extended find/replace across entire web projects) I am not very impressed with cfbuilder. It could be very useful and has some promise but I would not pay money for it again, and if you already have a template editor you like don't waste your time trying to get a free version working. While you can select a range of editor preferences color coding etc. You will have varying and frustrating results with many preferences not sticking after you close and reopen the program. The syntax error reporting and color coding is insanely erroneous and unhelpful. Many of these bugs have had multiple bug reports made at Adobe but nothing has been done The built in FTP is so complex to setup, I gave up and went back to an external FileZilla program. For a relative beginner to the deeper complexity and power of CF (despite having used it for many years) I found it very difficult to find the settings that control many of the preferences. Seemed like I am using confusion builder rather than coldfusion builder Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 On 6 Jan 2015 at 18:18, Steve LaBadie wrote: We just purchased CF 11 and we also received a license for Builder 3. I don't know anything about the product and wanted to know if it something that should be installed. Does it get installed on the server or desktop? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bad Gateway!
An anomaly with a remote API was causing my CF server to attempt to instantiate ten thousand objects, crashing the server. On Wed, Dec 31, 2014 at 9:36 AM, Byron Mann byronos...@gmail.com wrote: I would look to the code then. Something running well today does not mean it will run well tomorrow. I would maybe run the process and watch fusion reactor to see when things go bad. Also check the CF logs for any exceptions. Byron ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359898 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Bad Gateway!
I have a process which used to run fine. Now, it produces: Bad Gateway! There is a problem with the page you are looking for, and it cannot be displayed. When the Web server (while acting as a gateway or proxy) contacted the upstream content server, it received an invalid response from the content server. Jakarta/ISAPI/isapi_redirector/1.2.40 Copyright © 1999-2014 Apache Software Foundation All Rights Reserved ...and the ACF 10,0,15,292549 server service restarts (i.e. all sessions go away and FusionReactor shows Server Started as now). Any ideas? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bad Gateway!
That's exactly what's happening. Thanks. On Tue, Dec 30, 2014 at 3:30 PM, Byron Mann byronos...@gmail.com wrote: This is the kind of error you might get when the CF service is down. First impression is something you are running is crashing the CF service. Anything in the logs that might indicate this is the case? Byron ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Picasa and CF
Starting point...? http://picasacfc.riaforge.org On Thu, Dec 18, 2014 at 4:37 PM, Les Irvin les.cft...@gmail.com wrote: I'm trying to write a CF script to automate the creation of a photo slideshow video in Picasa. I want to programatically take, say, a folder of JPGs, convert them to a slideshow video, and upload the result to YouTube - without any human intervention. Has anyone had any experience with the Picasa api to know if this is possible? Thanks in advance for any help, Les ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFqueryParam Coldfusion 11
Does the line number on that error indicate that the query is what's timing out? On Fri, Nov 28, 2014 at 11:46 AM, Don danfar...@hotmail.com wrote: The errors getting back are all The request has exceeded the allowable time limit Tag Seems that the whole server eventually crashes/slows to crawl, even though other websites on that same server are fine. CF Version 11 / SQL Server Express Looking at the JVM free memory, it always seems to be going down. not sure what this points toany ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFqueryParam Coldfusion 11
Were you getting an error? On Thu, Nov 27, 2014 at 3:08 AM, Don danfar...@hotmail.com wrote: Does anyone know of any supposed issues with CF 11 and cfqueryparam ? I had a few of them in a query. One by one I removed them to see if I could get the query working and then, adding them in. All but one work. Any ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sending SMS
http://smsgateway.riaforge.org On Tue, Nov 18, 2014 at 6:09 PM, Rick Sanders r...@webenergy.ca wrote: Hey guys, Does anyone know a service I can use for sending sms messages from cold fusion? I want to make an app that notifies someone by sms when their product is ready. Kind Regards, Rick Sanders Canada: USA: 171 Main St 1205 N. Second Ave Dartmouth, NS Siler City, NC T: 902-401-7689 T: 919-799-9076 W: www.webenergy.cahttp://www.webenergy.ca/ W: www.webenergyusa.comhttp://www.webenergyusa.com/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled Tasks Error
Only by restoring from backup. No clue as to root-cause / preventing it from happening again. On Sun, Nov 9, 2014 at 6:37 PM, Sebastian Powell bas...@gmail.com wrote: [crickets] :-) -- John Bliss - http://www.linkedin.com/in/jbliss I am experiencing the same issue on CF 11, neo-cron.xml all the scedheuled task vanished. and its an empty file. Did you manage to resolve this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Redirects
Not sure I understand your question. Check out https://wikidocs.adobe.com/wiki/display/coldfusionen/cflocation On Mon, Nov 10, 2014 at 3:39 PM, Steve LaBadie slaba...@po-box.esu.edu wrote: We are currently using a meta date redirect from a UNIX box. The redirects currently sit on www and the production server sit at www4. We are taking down www so the redirects have to be recreated on our new production server which will be taking www. Current redirect structure: HTML BODY META HTTP-EQUIV=REFRESH CONTENT=1;URL= http://www4.esu.edu/about/offices/police/index.cfm; /BODY /HTML When the user types in www.esu.edu/policehttp://www.esu.edu/police it takes you to the correct page. We use this format to avoid long URLs on marketing pieces. Can someone give me directions for best practices using CF. The new production server currently runs CF9 but looking to upgrade to CF11. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edumailto:slaba...@esu.edu [facebook-16x16]http://www.facebook.com/eaststroudsburguniversity [twitter-16x16] http://twitter.com/esuniversity [youtube-16x16] http://www.youtube.com/user/esuedu ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Non-profit donation providers
...? https://merchant.paypal.com/us/cgi-bin/?cmd=_render-contentcontent_ID=merchant%2Fdonations On Tue, Oct 28, 2014 at 2:26 PM, Rob Voyle robvo...@voyle.com wrote: Hi Folks Any recommendations for church/non-profit online donations, especially recurring donations? Thanks Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adobe is just a spammer now
That's the way it's always looked for me... On Thu, Oct 23, 2014 at 9:29 PM, Eric Roberts ow...@threeravensconsulting.com wrote: Here's the screenshot: https://www.diigo.com/item/image/50m7r/eyn5 Look at the center column Eric -Original Message- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: Thursday, October 23, 2014 7:12 PM To: cf-talk Subject: RE: Adobe is just a spammer now Sorry to hear that. Wish I was more surprised. Adobe .. -Original Message- From: Mike K [mailto:afpwebwo...@gmail.com] Sent: 23 October 2014 22:56 To: cf-talk Subject: Re: Adobe is just a spammer now Jenny, thank you for your contribution. I hate to disagree with you, but since I knew the flash installer was going to try to force McAfee on me as it did last time (and really made a mess of my Norton - I had to reinstall that too as a result), I was looking for the checkbox or button so I could decline to install it. . And it didnt appear. I had no choice to not install McAfee. I think there are different versions of the installer, or it offers the choice in some circumstances and not in others.But i DID NOT have the choice to decline installing McAfee. On Fri, Oct 24, 2014 at 1:42 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Yes you were. It's just not very obvious. It's in the middle of the top area of the screen. Regardless, it should default to unclicked. I wrote to Adobe about this and got a prompt reply promising a change. No change made, no change accepted. But when have Adobe ever listened to user feedback? -Original Message- From: Mike K [mailto:afpwebwo...@gmail.com] Sent: 18 October 2014 21:08 To: cf-talk Subject: Re: Adobe is just a spammer now You can say whatever you like, Eric but i was given NO OPPORTUNITY TO DESELECT the installation of the McAfee product which I definitely DO NOT WANT. I downloaded the flash installer, then ran the installer, and it went right ahead and installed two items - the flash player and then without pause the McAfee crap. Because of the treatment I received from McAfee a few years back, I resolved never EVER to do business with McAfee again, and so it's doubly bad that Adobe force it on me. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, Oct 19, 2014 at 3:51 AM, Eric Roberts ow...@threeravensconsulting.com wrote: Yes...you can deselect it...it is a detestable practice that should default to not checked rather than checked. -- ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: XMLRPC Request with CFHTTP
Helpful...? http://www.houseoffusion.com/groups/xml/thread.cfm/threadid:108 On Tue, Oct 14, 2014 at 4:08 PM, Donnie Carvajal donnie.carva...@transformyx.com wrote: I'm having an issue with a XMLRPC webservice using CFHTTP. I am getting text/html responses instead of xml. A successful non-CFHTTP request's raw header are sends as POST /XMLRPC HTTP/1.0. The CFHTTP request's header sends as POST / HTTP/1.1. I believe the issue is the missing /XMLRPC. Does anyone know how to get CFHTTP to include this in the POST request? Thanks, Donnie Carvajal ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFML restart ACF 10 app server service
I came to the same conclusion. Thanks. On Wed, Oct 8, 2014 at 9:46 PM, Al Musella, DPM muse...@virtualtrials.com wrote: It doesn't make sense to do it from cf scheduler because if CF is locked up it won't execute. The windows scheduler always will! At 07:21 PM 10/1/2014, Russ Michaels wrote: Just use the previously mentioned commands that is all you need On Wed, Oct 1, 2014 at 22:57 PM, John M Bliss bliss.j...@gmail.com wrote: Care to share the batch file? On Oct 1, 2014 5:56 PM, Russ Michaels r...@michaels.me.uk javascript:; wrote: we have a batch file which we run via a windows scheduled task, we don't do it via CF. On Wed, Oct 1, 2014 at 7:10 PM, John M Bliss bliss.j...@gmail.com javascript:; wrote: And do you do it the way Gerald recommended...? On Wed, Oct 1, 2014 at 12:16 PM, Russ Michaels r...@michaels.me.uk javascript:; wrote: we have a scheduled task setup to restart CF every morning. Since we have done this we have hardly any cf issues any more. On Wed, Oct 1, 2014 at 3:46 PM, Gerald Guido gerald.gu...@gmail.com javascript:; wrote: I don't know if this is the best way but you can put the following text in a .bat file and run it using cfexecute. net stop ColdFusion 10 Application Server net start ColdFusion 10 Application Server cfexecute name = C:\somefolder\yourbatfile.bat /cfexecute HTH G! *Gerald Anthony Guido* Nullius in verba http://en.wikipedia.org/wiki/Nullius_in_verba -- Horace learn.geraldguido.com Twitter https://twitter.com/CozmoTrouble Facebook https://www.facebook.com/gerald.guido.9 On Wed, Oct 1, 2014 at 9:22 AM, John M Bliss bliss.j...@gmail.com javascript:; wrote: Hi. What's the current best way to use CFML to restart ACF 10 app server service (on Windows server)? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFML restart ACF 10 app server service
Hi. What's the current best way to use CFML to restart ACF 10 app server service (on Windows server)? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFML restart ACF 10 app server service
And do you do it the way Gerald recommended...? On Wed, Oct 1, 2014 at 12:16 PM, Russ Michaels r...@michaels.me.uk wrote: we have a scheduled task setup to restart CF every morning. Since we have done this we have hardly any cf issues any more. On Wed, Oct 1, 2014 at 3:46 PM, Gerald Guido gerald.gu...@gmail.com wrote: I don't know if this is the best way but you can put the following text in a .bat file and run it using cfexecute. net stop ColdFusion 10 Application Server net start ColdFusion 10 Application Server cfexecute name = C:\somefolder\yourbatfile.bat /cfexecute HTH G! *Gerald Anthony Guido* Nullius in verba http://en.wikipedia.org/wiki/Nullius_in_verba -- Horace learn.geraldguido.com Twitter https://twitter.com/CozmoTrouble Facebook https://www.facebook.com/gerald.guido.9 On Wed, Oct 1, 2014 at 9:22 AM, John M Bliss bliss.j...@gmail.com wrote: Hi. What's the current best way to use CFML to restart ACF 10 app server service (on Windows server)? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFML restart ACF 10 app server service
Care to share the batch file? On Oct 1, 2014 5:56 PM, Russ Michaels r...@michaels.me.uk wrote: we have a batch file which we run via a windows scheduled task, we don't do it via CF. On Wed, Oct 1, 2014 at 7:10 PM, John M Bliss bliss.j...@gmail.com wrote: And do you do it the way Gerald recommended...? On Wed, Oct 1, 2014 at 12:16 PM, Russ Michaels r...@michaels.me.uk wrote: we have a scheduled task setup to restart CF every morning. Since we have done this we have hardly any cf issues any more. On Wed, Oct 1, 2014 at 3:46 PM, Gerald Guido gerald.gu...@gmail.com wrote: I don't know if this is the best way but you can put the following text in a .bat file and run it using cfexecute. net stop ColdFusion 10 Application Server net start ColdFusion 10 Application Server cfexecute name = C:\somefolder\yourbatfile.bat /cfexecute HTH G! *Gerald Anthony Guido* Nullius in verba http://en.wikipedia.org/wiki/Nullius_in_verba -- Horace learn.geraldguido.com Twitter https://twitter.com/CozmoTrouble Facebook https://www.facebook.com/gerald.guido.9 On Wed, Oct 1, 2014 at 9:22 AM, John M Bliss bliss.j...@gmail.com wrote: Hi. What's the current best way to use CFML to restart ACF 10 app server service (on Windows server)? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359380 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
isvalid(url) issue
ACF 10's isvalid(url) says that this is not a valid URL. What's your favorite alternative to isvalid(url)? http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isvalid(url) issue
This seems better: http://cflib.org/udf/isURL On Wed, Aug 27, 2014 at 2:19 PM, Russ Michaels r...@michaels.me.uk wrote: you are better off using your own regex to define what you consider to be valid. you may find something specific on cflib.org or riaforge.org or there is always http://www.validatethis.org/ On Wed, Aug 27, 2014 at 7:02 PM, John M Bliss bliss.j...@gmail.com wrote: ACF 10's isvalid(url) says that this is not a valid URL. What's your favorite alternative to isvalid(url)? http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled Tasks Error
[crickets] :-) On Sat, Aug 23, 2014 at 10:13 AM, John M Bliss bliss.j...@gmail.com wrote: Appears that my neo-cron.xml disappeared and neo-cron.bak is of size zero. Trying to restore from backup. Any idea how this could have happened? On Sat, Aug 23, 2014 at 9:48 AM, John M Bliss bliss.j...@gmail.com wrote: ACF 10,0,12,286680 This AM, when I login to the admin and click Scheduled Tasks, I get the following error. Ideas? The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. The error occurred in scheduletasks.cfm: line 188 -1 : Unable to display error's location in a CFML template. Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36 Remote Address 192.168.200.125 Date/Time 23-Aug-14 08:44 AM Stack Trace at cfscheduletasks2ecfm672758571._factor31(E:/cf10_final/cfusion/wwwroot/CFIDE/administrator/scheduler/scheduletasks.cfm:188) at cfscheduletasks2ecfm672758571.runPage(E:/cf10_final/cfusion/wwwroot/CFIDE/administrator/scheduler/scheduletasks.cfm:1) -- John Bliss - http://www.linkedin.com/in/jbliss -- John Bliss - http://www.linkedin.com/in/jbliss -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Scheduled Tasks Error
ACF 10,0,12,286680 This AM, when I login to the admin and click Scheduled Tasks, I get the following error. Ideas? The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. The error occurred in scheduletasks.cfm: line 188 -1 : Unable to display error's location in a CFML template. Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36 Remote Address 192.168.200.125 Date/Time 23-Aug-14 08:44 AM Stack Trace at cfscheduletasks2ecfm672758571._factor31(E:/cf10_final/cfusion/wwwroot/CFIDE/administrator/scheduler/scheduletasks.cfm:188) at cfscheduletasks2ecfm672758571.runPage(E:/cf10_final/cfusion/wwwroot/CFIDE/administrator/scheduler/scheduletasks.cfm:1) -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled Tasks Error
Appears that my neo-cron.xml disappeared and neo-cron.bak is of size zero. Trying to restore from backup. Any idea how this could have happened? On Sat, Aug 23, 2014 at 9:48 AM, John M Bliss bliss.j...@gmail.com wrote: ACF 10,0,12,286680 This AM, when I login to the admin and click Scheduled Tasks, I get the following error. Ideas? The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. The error occurred in scheduletasks.cfm: line 188 -1 : Unable to display error's location in a CFML template. Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143 Safari/537.36 Remote Address 192.168.200.125 Date/Time 23-Aug-14 08:44 AM Stack Trace at cfscheduletasks2ecfm672758571._factor31(E:/cf10_final/cfusion/wwwroot/CFIDE/administrator/scheduler/scheduletasks.cfm:188) at cfscheduletasks2ecfm672758571.runPage(E:/cf10_final/cfusion/wwwroot/CFIDE/administrator/scheduler/scheduletasks.cfm:1) -- John Bliss - http://www.linkedin.com/in/jbliss -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359178 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Scheduled Tasks Not Attempted
Here's a strange one: ACF 10,0,12,286680 Scheduled Tasks not attempted. I have numerous Scheduled Tasks that run daily in the early AM hours. This AM, it appears that none of them ran. No errors. The Scheduled Task page in the Admin shows two types: Duration Interval Last Run Next Run Sep 17, 2009 - INDEFINITELYDaily 8/19/2014 5:00:00 AM 8/21/2014 5:00:00 AM Feb 18, 2009 - INDEFINITELYDaily 8/19/2014 2:31:00 AM EXPIRED ...where that first one seems to illustrate skipping today and that second one illustrates skipping today and never running again? Despite the fact that it's set to INDEFINITELY. Any ideas on where to start? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT: the magic of RANK()
I hope this saves someone some time and I hope I'm not way late to the RANK() party: Let's say you have this table: column1 - column2 A - 1 A - 2 A - 2 B - 3 B - 4 B - 4 ...and you need to write SQL to return the most frequently occurring column2 for each distinct column1: A - 2 B - 4 Enter RANK(): SELECT x.column1, x.column2 FROM ( SELECT z.column1, z.column2, COUNT(*) as thecount, RANK() OVER (PARTITION BY z.column1 ORDER BY COUNT(*) DESC) AS therank FROM z GROUP BY z.column1, z.column2 ) AS x WHERE x.therank = 1 Done and done. :-) -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: the magic of RANK()
Happy to not be the only one. 18 years in and I just learned about it today (IIRC). :-) On Aug 12, 2014 8:49 PM, Rick Faircloth r...@whitestonemedia.com wrote: Nice! I've never heard of Rank()... On 8/12/2014 4:21 PM, John M Bliss wrote: I hope this saves someone some time and I hope I'm not way late to the RANK() party: Let's say you have this table: column1 - column2 A - 1 A - 2 A - 2 B - 3 B - 4 B - 4 ...and you need to write SQL to return the most frequently occurring column2 for each distinct column1: A - 2 B - 4 Enter RANK(): SELECT x.column1, x.column2 FROM ( SELECT z.column1, z.column2, COUNT(*) as thecount, RANK() OVER (PARTITION BY z.column1 ORDER BY COUNT(*) DESC) AS therank FROM z GROUP BY z.column1, z.column2 ) AS x WHERE x.therank = 1 Done and done. :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359114 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Logical looking dates reporting..
http://cflib.org/udf/longTime On Sat, Aug 9, 2014 at 8:40 AM, Phillip Vector vec...@mostdeadlygame.com wrote: So I want to display the time between 2 events (down to the second). I have the following code.. cfset Years = #DateDiff(, Leaderboard.CreatedOn, Leaderboard.DateOfDeath)# + 18 cfset Months = #DateDiff(, Leaderboard.CreatedOn, Leaderboard.DateOfDeath)# cfset Days = #DateDiff(, Leaderboard.CreatedOn, Leaderboard.DateOfDeath)# #Years# Years, #Months# months and #Days# days However, as you may have noticed, it produces an output like this.. 0 Years, 5 months and 174 days What I'm hoping it would say is something like 0 Years, 5 months and 24 days (but I would need to then figure out if the months between it contain 30 or 31 (or 29 or leap year 28).. Does anyone have something already coded before I try to tackle this? I'd hate to invent the wheel and my Google Fu doesn't come up with anything (Then again, it is 5:40am where I am and I just woke up). :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
expire application variable
I have a case where I need to have an application variable expire after a known amount of time. Do you have a favorite method for doing this? I was thinking of something like: application.thevar = structnew(); application.thevar.createtick = gettickcount(); application.thevar.thevalue = foo; ...and then, on use, checking gettickcount() - application.thevar.createtick. Good? Better way? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: expire application variable
Sweet. Thanks! On Aug 7, 2014 5:51 PM, Carl Von Stetten vonner.li...@vonner.net wrote: Are you on ColdFusion 9+? Why not use the built-in cache functionality (cachePut(), cacheGet(), etc.)? If you are on ColdFusion 10+, you can even put related objects into a cache region and manually flush that region using CacheRemoveAll( region ) . -Carl V. On 8/7/2014 1:06 PM, John M Bliss wrote: I have a case where I need to have an application variable expire after a known amount of time. Do you have a favorite method for doing this? I was thinking of something like: application.thevar = structnew(); application.thevar.createtick = gettickcount(); application.thevar.thevalue = foo; ...and then, on use, checking gettickcount() - application.thevar.createtick. Good? Better way? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9/Windows how to push data to HTML page
Are you talking about updating the page while end-user is looking at it? Or do you just need to have it updated on load / refresh? On Wed, Aug 6, 2014 at 8:03 AM, Mike K afpwebwo...@gmail.com wrote: I have a radio station site, and I want to be able to update the pages automatically as events happen. For example on the section where it says what's on air now i want it to automatically change as the hour ticks over and the new show startsOr as the live call of the sports ends and we return to music. Does anyone have a way to do that? I have been unsuccessful at using now() as a function in a CFC because the CFC stays in memory and doesnt necessarily update the data it works with. In fact the what's on today doesnt always have today's program listing - it often has yesterday's, even though it's based on now() as a parameter in the cfquery on the database programming table. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9/Windows how to push data to HTML page
Many ways to accomplish this: Check out alternatives to cfdiv here: https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfdiv/index.md JQuery example (you'd use a Javascript timer instead of the button): http://jsfiddle.net/ZPYUS/ etc On Wed, Aug 6, 2014 at 8:23 AM, Mike K afpwebwo...@gmail.com wrote: Ideally I'd like it updating while he's looking at it . rather the way Facebook does. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Aug 6, 2014 at 10:17 PM, John M Bliss bliss.j...@gmail.com wrote: Are you talking about updating the page while end-user is looking at it? Or do you just need to have it updated on load / refresh? On Wed, Aug 6, 2014 at 8:03 AM, Mike K afpwebwo...@gmail.com wrote: I have a radio station site, and I want to be able to update the pages automatically as events happen. For example on the section where it says what's on air now i want it to automatically change as the hour ticks over and the new show startsOr as the live call of the sports ends and we return to music. Does anyone have a way to do that? I have been unsuccessful at using now() as a function in a CFC because the CFC stays in memory and doesnt necessarily update the data it works with. In fact the what's on today doesnt always have today's program listing - it often has yesterday's, even though it's based on now() as a parameter in the cfquery on the database programming table. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (Semi-OT) - site sucker app
This is what I've used in the past: https://softbytelabs.com/en/BlackWidow/ On Aug 6, 2014 8:32 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Does anyone have a suggestion for a good application that can be pointed to an url and then download every page under that url. For example, if I want to view all of the Google maps documents offline I can point the app at https://developers.google.com/maps and it'll get me all of the faq, the api docs, etc. Yes, I can write such an app in CF and have a dozen times over. I also know that if I start rewriting my old apps in any way, shape, or form, I run the risk of getting pulled into a black hole of optimization and organization and lose track of the real project. Save me from myself and point me to what you would use. ;) Thanks Michael It is a wise man who knows his own foibles, especially if he can spell foibles without using a spellchecker. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto File Uploading...
In short, no. You'd have to deliver file to server via email / FTP / etc. On Aug 6, 2014 8:36 PM, Phillip Vector vec...@mostdeadlygame.com wrote: So I have a server that reads a file that is submitted to it and processes the contents. I can not touch this server and change any settings on it.. I want to take a file I have (Let's call it data.txt) and upload it to the server once an hour. I can just reload the page once an hour or I can set up a schedule, no problem.. I just can't seem to automate the browse button to pick the file (which I can understand not allowing). So is there any way for me to not use the browse button and post it directly to an address like a form? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto File Uploading...
...or HTTP post. On Aug 6, 2014 8:39 PM, John M Bliss bliss.j...@gmail.com wrote: In short, no. You'd have to deliver file to server via email / FTP / etc. On Aug 6, 2014 8:36 PM, Phillip Vector vec...@mostdeadlygame.com wrote: So I have a server that reads a file that is submitted to it and processes the contents. I can not touch this server and change any settings on it.. I want to take a file I have (Let's call it data.txt) and upload it to the server once an hour. I can just reload the page once an hour or I can set up a schedule, no problem.. I just can't seem to automate the browse button to pick the file (which I can understand not allowing). So is there any way for me to not use the browse button and post it directly to an address like a form? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto File Uploading...
In other words, if you have CF running locally, you could write something that performs a cfhttp post to server...mimicking browse, select file, click submit. On Aug 6, 2014 8:42 PM, John M Bliss bliss.j...@gmail.com wrote: ...or HTTP post. On Aug 6, 2014 8:39 PM, John M Bliss bliss.j...@gmail.com wrote: In short, no. You'd have to deliver file to server via email / FTP / etc. On Aug 6, 2014 8:36 PM, Phillip Vector vec...@mostdeadlygame.com wrote: So I have a server that reads a file that is submitted to it and processes the contents. I can not touch this server and change any settings on it.. I want to take a file I have (Let's call it data.txt) and upload it to the server once an hour. I can just reload the page once an hour or I can set up a schedule, no problem.. I just can't seem to automate the browse button to pick the file (which I can understand not allowing). So is there any way for me to not use the browse button and post it directly to an address like a form? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypting Zip File
Maybe http://www.andyscott.id.au/blog/getting-better-zip-support-in-coldfusion-with-zip4j On Thu, Jul 31, 2014 at 12:18 PM, Richard White rich...@re-base.net wrote: Hi, What is the best way to encrypt a zip file in ColdFusion? Many thanks, Richard ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 10 Developer Edition
https://www.copy.com/s/i0LSL1n8A6QC/ColdFusion%20Installs On Sun, Jul 27, 2014 at 10:59 AM, Richard Colman rcol...@cox.net wrote: Does anyone know where to find a download of V. 10 ... Adobe only seems to have Coldfusion11 available. TNX if you can help. -- Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
Here's the official replacement for cfgrid. Double-quotes because there're many way to replace cfgrid...this is just one suggestion. https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfgrid/index.md On Tue, Jul 22, 2014 at 1:34 PM, Andrew Scott andr...@andyscott.id.au wrote: where 0 = 0 looks like its obsolete in that query, in other words it shouldn't be needed if you have no if statements there. As you said it works on ColdFusion 10, what would happen if you removed the 0 = 0 or replaced it with 1 = 1? Other than that I really can't see any other issue with it. When you say is ignored, are you saying records are returning or no records are being returned? You also don't indicate whether you have an error, so we can assume that what is calling this is working to some degree with records in the grid? Also there is a huge push to remove any UI tags from Application code, it might pay to think about moving away from the likes of the current CF UI stuff. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Jul 23, 2014 at 3:08 AM, Stephen Hait stephenh...@gmail.com wrote: We have a CF app that uses a CF_GRID with some filters to allow limiting the data retrieved. After moving the app from a host running CF10 to another host running CF11, the filters stopped working even though the other grid functions did not - grid still display data correctly and clicking column headers correctly sorts the grid. This is the contents of the cfgrid tag: cfgrid format=html name=pilotGrid pagesize=10 autowidth=yes selectmode=row appendKey=yes href=index.cfm?fuseaction=dsp_adm-pilot-detail hrefKey=userid bind=cfc:pilot_search.getPilots({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, '#attributes.pil_email#', '#attributes.pil_lname#', '#attributes.pil_n_number#') The bind parameter specifies a function, getPilots, in pilot_search.cfc. It passes 3 attributes/parameters to the function which are the contents of the 3 text filters - pil_email, pil_lname, pil_n_number. The function contains a query to retrieve the requested data including WHERE clauses based on the filter text entered. This is the content of the function and query contained in pilot_search.cfc: cffunction name=getPilots access=remote returntype=struct cfargument name=page required=true / cfargument name=pageSize required=true / cfargument name=gridsortcolumn required=true / cfargument name=gridsortdirection required=true / cfargument name=pil_email type=string required=no default= / cfargument name=pil_lname type=string required=no default= / cfargument name=pil_n_number type=string required=no default= / cfif arguments.gridsortcolumn eq cfset arguments.gridsortcolumn = pil_email / cfset arguments.gridsortdirection = asc / /cfif cfquery name=pilots datasource=hope select userid, pil_n_number, pil_email, pil_lname, pil_fname, pil_password, last_login from pilots where 0=0 and pil_email like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_email#% and pil_lname like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_lname#% and pil_n_number like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_n_number#% order by #arguments.gridsortcolumn# #arguments.gridsortdirection# /cfquery cfreturn queryconvertforgrid(pilots, page, pagesize) / /cffunction Does anyone know why the WHERE clauses in the query appear to be ignored when running the app with CF11 but work correctly with CF10? Or does anyone have a suggestion of how to best debug this? I can't seem to figure out how to view the contents of the 3 arguments used in the WHERE clauses to see why they might be being ignored or why the result set is not limited by the filters on CF11. Any insight or suggestions appreciated. Regards, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF apps sudden performance issue - it's very slow
One such tool: http://tools.pingdom.com/fpt/ On Sun, Jul 20, 2014 at 9:20 AM, Russ Michaels r...@michaels.me.uk wrote: this sounds like a network issue. You have not mentioned if you are connecting on a local network or across the internet, but the fact that it works on the local machine, shows there is no problems with CF. You need to first investigate exactly what on the pages is taking a long time to load, it could be some Javascript or CSS files that is the cause, and I often see this being the case. There are plenty of tools out there to do this, and Google chrome and IE have tools built right in to do this. On Sun, Jul 20, 2014 at 7:28 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: · Dear Friends, We noticed our ColdFusion application(CF9 server Oracle db) works differently every time. o For example, when we refresh a page the second time it comes faster. o When we connect to COLDFUSION APPLICATION server remotely and logged in with same user credentials it was working fine faster. But from user machine itâs very slow. o Also we found it works faster once we connect to COLDFUSION APPLICATION server remotely from the end user machine. But still we are browsing the site from user machine and not remote desktop server. Which means I think there might be some difficulty for the network to find the COLDFUSION APPLICATION server every first time when a page request happens. o Sometimes the COLDFUSION APPLICATION works fine when the PC restarted. o Sometimes the COLDFUSION APPLICATION works fine when we delete the browser history. · The application was stable for the past three years and no changes has been made. Suddenly for the past 3 weeks we are getting application slowness mails from users. We checked with our network team but nothing has been changed by them recently. · Please suggest me some tips that you might have used to increase the performance of CF application. Sathya ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Encrypt/Decrypt Files
Check out https://wikidocs.adobe.com/wiki/display/coldfusionen/EncryptBinary including example at bottom. On Thu, Jul 17, 2014 at 4:10 PM, Bryan Stevenson br...@electricedgesystems.com wrote: Hey Rick, You can use more secure forms of FTP as opposed to getting that draconian - just a thought ;-) I haven't done any file encryption in a while, so I'll bow out on that detail - but yes it is doable. Cheers *Bryan Stevenson*B.Comm. President CEO Electric Edge Systems Group Inc. - makers of FACTS^(TM) phone: 250.480.0642 cell: 250.920.8830 e-mail: br...@electricedgesystems.com mailto: br...@electricedgesystems.com web: www.electricedgesystems.com http://www.electricedgesystems.com and www.fisheryfacts.com http://www.fisheryfacts.com Please consider the environment before printing this e-mail -CONFIDENTIALITY-- This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
oAuth 2 (Google) and CFML without cfoauth
Hope to save someone a bunch of time: http://www.brandiandjohn.com/post.cfm/oauth-2-google-and-cfml-without-cfoauth -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: validate w/ regular expressions in cftextarea cf9 not working
Warning: I'm side-stepping your question for a moment... Best-practice is now to use the following (or similar) in place of cftextarea: https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cftextarea/index.md Now, back to our regularly scheduled thread...answer to your question in 3, 2, 1... On Mon, Jul 7, 2014 at 6:08 PM, andy mann a...@sitemann.com wrote: Hi CFers, i am trying to make the form super secure and have added regular expression that works fine in cfinput to cftextarea and it doesn't work...? cftextarea name=mytxt value=#wrds# message=Text - Required. Letters, Numbers and .+()' allowed pattern=^[-a-zA-Z0-9_:+().' ']{1,100}$ height=300 width=700 validate=regular_expression validateat=OnSubmit disabled=No required=No toolbaronfocus=No bindonload=No html=No enabled=Yes visible=Yes richtext=Yes toolbar=Basic / this is in the head script function FCKeditor_OnComplete(editorInstance) { editorInstance.Config[ToolbarSets][BasicPlus] = [ ['SpecialChar','Bold','Italic','Underline','StrikeThrough','Link', 'Unlink','-','Cut','Copy','Paste', 'Find','Replace', '-','FontFormat','FontName','FontSize','TextColor'] ]; editorInstance.EditorWindow.parent.FCK.ToolbarSet.Load('BasicPlus') ; } /script tnx in advance andy ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358833 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 11
Interesting. Can you provide an example where that'd be useful? On Sat, Jun 28, 2014 at 1:05 AM, Dave Watts dwa...@figleaf.com wrote: Official list: http://www.adobe.com/products/coldfusion-enterprise/features._sl_id-contentfilter_sl_featuredisplaytypes_sl_new.html Your needs are almost surely different from ours...however...in case it's helpful, my boss asked me to order these from most important (for us) through least important (for us): One feature not on your list (and probably not important to you) is interesting to me. You can install CF as an application instead of a service. You could always run CF as an application once it's installed, but now you can just unzip CF into a directory - no admin rights needed - and run it as an application. You could do that before with a little bit of tinkering, but CF 11 makes it a lot easier. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 11
Official list: http://www.adobe.com/products/coldfusion-enterprise/features._sl_id-contentfilter_sl_featuredisplaytypes_sl_new.html Your needs are almost surely different from ours...however...in case it's helpful, my boss asked me to order these from most important (for us) through least important (for us): 1. Security enhancements - Limit the attack surface by restricting default remote access to the admin portal. Control access to resources by creating multiple sandboxes across directories. Make your server more secure against click-jacking and cross-site scripting using new functions to sanitize user input. 2. New Client-side database integration - Work more productively by not having to attach any callback handler when accessing databases. Now take advantage of the powerful CFQUERY tag to access client-side databases directly using SQL. 3. Language enhancements - Maintain and modify existing code faster and more easily with member functions on ColdFusion objects. Leverage enhanced JSON data conversion to identify the data types of JSON objects. Use the new QueryExecute function to easily handle database queries from within CFSCRIPT. 4. Tight integration with Adobe ColdFusion Builder - Enhance your development experience with integrated server management and expanded functionality through CFML extensions using ColdFusion Builder. Accelerate the development of mobile applications using features such as device detection, on-device debugging, multidevice inspection, and more. 5. Web services support - Publish and access web services with less code using the revamped engine that supports the WSDL 2.0 specification, SOAP 1.2, and document literal wrapped style. 6. Dynamic and interactive HTML5 charting - Implement a large repository of HTML5 charts using the built-in CFCHART tag. Easily create dynamic, data-heavy charts with an all-new server-side charting engine. Show data in a wide range of interactive formats with features such as zoom-in to help consumers get a granular view of information. 7. Rich Ajax UI controls - Build more compelling and intuitive applications with a broad set of Ajax controls via CFML tags and attributes. Easily bind client-side Ajax applications to ColdFusion components on the server. 8. Improved Microsoft Office file interoperability - Leverage additional functionalities, such as page break and auto filter, to manage spreadsheets better. Generate PDF files from PowerPoint and Word files. Produce HTML or SWF files from PowerPoint presentations. Take advantage of several performance enhancements to work faster with Microsoft Office 2010 files. 9. New Full CFSCRIPT support - Work more productively with complete scripting support for CFSCRIPT. Develop applications faster and more easily by accessing every ColdFusion 11 functionality using CFSCRIPT. 10. New Custom tag framework for UI development - Extend the functionality of ColdFusion by using the popular server-side custom tag framework on the client side. Reuse and distribute UI components to speed up development and reduce the testing effort. 11. New CFML-based mobile app development - Get a head start in the fast-growing market for mobile apps. Leverage your existing CFML skills to develop mobile apps and use built-in integration with Adobe PhoneGap Build to easily and quickly deliver them as installed apps that run on iOS and Android devices. 12. New On-device debugging - Use unique on-device debugging capabilities to identify and fix errors in installed apps as well as browser-based mobile applications. Remotely connect a mobile device to ColdFusion Builder and simulate actual usage on the device by stepping through application code. 13. New Multidevice inspection - Inspect the look and feel of both mobile and web applications on multiple devices using the built-in Weinre server. Modify the properties of elements using ColdFusion Builder, and see the changes take effect in real time in the mobile app. 14. New Device detection - Easily identify the type of device, its dimensions, group name, description, orientation, and features at runtime without needing any plug-ins. Leverage this information to deliver differentiated content for the device and enhance the user experience. 15. New Native device APIs - Use ColdFusion device APIs to easily integrate device functionalities, such as working with contacts, handling files, retrieving geo-location information, recording and playing back audio and video files, and accessing camera features, accelerometer, and storage. 16. New Enhanced server-side access - Work more productively by directly creating instances of ColdFusion components on mobile applications. Easily access server-side logic without creating a proxy or passing complex URLs. 17. New HTML to PDF conversion - Use the improved conversion engine from Adobe to generate superior quality PDF files from HTML pages. The engine parses the CSS and applies its settings to ensure that the content in the PDF file appears and
XML - no encoding
I'm working with a vendor to troubleshoot an error and he's asked me to *not* replace with amp; etc in a URL field. I'm building an XML doc with xmlnew() and then posting it with cfhttp method=post and I'm not explicitly calling urlencodedformat() or anything. CF is just automatically and (I think) correctly performing the encoding. Any way I can stop this from happening just for the duration of the troubleshooting...? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: XML - no encoding
So, using your example, instead of: MyXMLObj.MyXMLChild[1] = 'http://myurl.com?x=ya=b'; ...I'd use: MyXMLObj.MyXMLChild[1].XMLCData = 'http://myurl.com?x=ya=b'; ...? On Tue, Jun 17, 2014 at 2:39 PM, Jon Clausen jon_clau...@silowebworks.com wrote: CDATA: MyXMLObj.MyXMLChild[1].XMLCData=èttp://myurl.com?x=ya=b'; Most XML libraries for other languages will read CDATA just like they would a non-escaped node. On Jun 17, 2014, at 2:33 PM, John M Bliss bliss.j...@gmail.com wrote: I'm working with a vendor to troubleshoot an error and he's asked me to *not* replace with amp; etc in a URL field. I'm building an XML doc with xmlnew() and then posting it with cfhttp method=post and I'm not explicitly calling urlencodedformat() or anything. CF is just automatically and (I think) correctly performing the encoding. Any way I can stop this from happening just for the duration of the troubleshooting...? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: XML - no encoding
Element. This changed my XML from this: Urlhttp://myurl.com/?x=yamp;a=b/Url ...to this: Url![CDATA[ http://myurl.com/?x=ya=b]]/Url ...which, I guess, was the desired effect. Now, response I'm getting has changed to, URL 'http:// http://myurl.com/?x=ya=b' is not in the expected format. Repeating http://; is new... On Tue, Jun 17, 2014 at 3:03 PM, Dave Watts dwa...@figleaf.com wrote: CDATA: MyXMLObj.MyXMLChild[1].XMLCData=èttp://myurl.com?x=ya=b'; Most XML libraries for other languages will read CDATA just like they would a non-escaped node. I'm pretty sure that this will only work for element values, not attribute values. I'm not sure whether John's using this in an element or an attribute. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: XML - no encoding
SOLVED: URL had leading space. trim() fixed it. Thanks! :-) On Tue, Jun 17, 2014 at 3:10 PM, John M Bliss bliss.j...@gmail.com wrote: Element. This changed my XML from this: Urlhttp://myurl.com/?x=yamp;a=b http://myurl.com/?x=ya=b/Url ...to this: Url![CDATA[ http://myurl.com/?x=ya=b]]/Url ...which, I guess, was the desired effect. Now, response I'm getting has changed to, URL 'http:// http://myurl.com/?x=ya=b' is not in the expected format. Repeating http://; is new... On Tue, Jun 17, 2014 at 3:03 PM, Dave Watts dwa...@figleaf.com wrote: CDATA: MyXMLObj.MyXMLChild[1].XMLCData=èttp://myurl.com?x=ya=b'; Most XML libraries for other languages will read CDATA just like they would a non-escaped node. I'm pretty sure that this will only work for element values, not attribute values. I'm not sure whether John's using this in an element or an attribute. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358749 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT: EXT grid timeout
Hi! So I added this code to increase our EXT grid timeout from 2.5 minutes to 10 minutes: Ext.onReady(function(){ Ext.Ajax.timeout = 60; }); So now, EXT grids will wait longer for CF to return the JSON to populate the grids. Works great under about 5 minutes. The problem is: *above* 5 minutes, when the request for the JSON finally finishes (I can see this happening via FusionReactor), the grid's spinner just keeps spinning. Like it's no longer listening for the JSON request to complete. Any ideas? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: EXT grid timeout
Confirmed: only happens in Firefox. Thanks, Cameron. On Sat, Jun 14, 2014 at 10:28 AM, Cameron Childress camer...@gmail.com wrote: On Sat, Jun 14, 2014 at 10:16 AM, John M Bliss wrote: So I added this code to increase our EXT grid timeout from 2.5 minutes to 10 minutes: Any ideas? I am not sure I would try to work with AJax data that took that long to return. You have so many variables with different browsers (with their own timeouts) and JS involved and async stuff that's so hard to debug. I am sure it's possible, but this smells like something that will cause you to go insane, eventually. If I were you I would either try to get that server reply WAY WAY faster than 5 minutes (?!?!?!?!) or just use plain ole HTML for this data. -Cameron ... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
DDOS Prevention
Does anyone have a preferred free / low-cost solution for DDOS prevention for Windows / IIS? Anyone have any good/bad experience with http://www.iis.net/downloads/microsoft/dynamic-ip-restrictions ? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFB3
Existing .cfc with existing cfquery block, press Enter to insert new line into block, CFB3 locks up. Just me? Workaround? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: max reqs
P.S. It appears I can approximate reserving, say, half of my Maximum number of simultaneous Template requests for the short request-time site with Fusion Reactor's Crash Protection. On Sat, May 10, 2014 at 11:22 AM, John M Bliss bliss.j...@gmail.com wrote: Super-helpful! Thanks, all! On Fri, May 9, 2014 at 5:57 PM, Gerald Guido gerald.gu...@gmail.comwrote: Here is how I do it on cfmldeveloper if you are interested. http://www.michaels.me.uk/post.cfm/running-railo-and-coldfusion-10-side-by-side-with-boncode Nice, thanx for sharing that. G! -- Gerald Guido Twitter https://twitter.com/CozmoTrouble Blarg http://www.myinternetisbroken.com Facebook https://www.facebook.com/gerald.guido.9 On Fri, May 9, 2014 at 5:53 PM, Russ Michaels r...@michaels.me.uk wrote: Yes they can, right out of the box. Here is how I do it on cfmldeveloper if you are interested. http://www.michaels.me.uk/post.cfm/running-railo-and-coldfusion-10-side-by-side-with-boncode Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 9 May 2014 20:32, John M Bliss bliss.j...@gmail.com wrote: Can ACF10 Standard and Railo coexist on the same server, one attached to one IIS website and the other attached to another IIS website? On Fri, May 9, 2014 at 10:56 AM, Russ Michaels r...@michaels.me.uk wrote: if shelling out for a enterprise license is not viable, you could try using Railo for the management site. On Fri, May 9, 2014 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: Would I need two CF server licenses for this...? No, just one Enterprise license. Also, this is CF Standard we're talking about. Does Standard do multi-server? No. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358619 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: max reqs
Super-helpful! Thanks, all! On Fri, May 9, 2014 at 5:57 PM, Gerald Guido gerald.gu...@gmail.com wrote: Here is how I do it on cfmldeveloper if you are interested. http://www.michaels.me.uk/post.cfm/running-railo-and-coldfusion-10-side-by-side-with-boncode Nice, thanx for sharing that. G! -- Gerald Guido Twitter https://twitter.com/CozmoTrouble Blarg http://www.myinternetisbroken.com Facebook https://www.facebook.com/gerald.guido.9 On Fri, May 9, 2014 at 5:53 PM, Russ Michaels r...@michaels.me.uk wrote: Yes they can, right out of the box. Here is how I do it on cfmldeveloper if you are interested. http://www.michaels.me.uk/post.cfm/running-railo-and-coldfusion-10-side-by-side-with-boncode Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 9 May 2014 20:32, John M Bliss bliss.j...@gmail.com wrote: Can ACF10 Standard and Railo coexist on the same server, one attached to one IIS website and the other attached to another IIS website? On Fri, May 9, 2014 at 10:56 AM, Russ Michaels r...@michaels.me.uk wrote: if shelling out for a enterprise license is not viable, you could try using Railo for the management site. On Fri, May 9, 2014 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: Would I need two CF server licenses for this...? No, just one Enterprise license. Also, this is CF Standard we're talking about. Does Standard do multi-server? No. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: max reqs
Would I need two CF server licenses for this...? Also, this is CF Standard we're talking about. Does Standard do multi-server? On Fri, May 9, 2014 at 9:47 AM, Dave Watts dwa...@figleaf.com wrote: We have one ACF10 production server for two sites: 1 - a longer request-time management site 2 - a short request-time site for the public ( 300 milliseconds / req) What's the best/easiest way to reserve, say, half of my Maximum number of simultaneous Template requests for the short request-time site? Is there a way to do that via CF admin? Application vars? Programmatically? To the best of my knowledge, there is no way to do this. But that's why CF has multi-server functionality. You can create two instances, dedicate one instance to each site, and control the resources available to each instance. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: max reqs
Can ACF10 Standard and Railo coexist on the same server, one attached to one IIS website and the other attached to another IIS website? On Fri, May 9, 2014 at 10:56 AM, Russ Michaels r...@michaels.me.uk wrote: if shelling out for a enterprise license is not viable, you could try using Railo for the management site. On Fri, May 9, 2014 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: Would I need two CF server licenses for this...? No, just one Enterprise license. Also, this is CF Standard we're talking about. Does Standard do multi-server? No. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: max reqs
NP, Matt. On May 9, 2014 5:41 PM, Matt Quackenbush quackfu...@gmail.com wrote: By the way, I apologize for my brevity earlier. I would give the long answer (i.e. how to do it), too, but, well, I haven't used Windows in several years and it's been even longer since I used ACF, so I've never personally done a side-by-side install on Windows. On Fri, May 9, 2014 at 5:34 PM, Gerald Guido gerald.gu...@gmail.com wrote: Yeah, what Matt said. There are several ways to do it. I have done it like so: http://blogs.iis.net/wonyoo/archive/2008/07/09/application-request-routing-arr-as-a-reverse-proxy.aspx HTH G! -- Gerald Guido Twitter https://twitter.com/CozmoTrouble Blarg http://www.myinternetisbroken.com Facebook https://www.facebook.com/gerald.guido.9 On Fri, May 9, 2014 at 3:39 PM, Matt Quackenbush quackfu...@gmail.com wrote: In short, yes. There'll be some configuration change requirements, but yes, people do it all the time. On Fri, May 9, 2014 at 3:32 PM, John M Bliss bliss.j...@gmail.com wrote: Can ACF10 Standard and Railo coexist on the same server, one attached to one IIS website and the other attached to another IIS website? On Fri, May 9, 2014 at 10:56 AM, Russ Michaels r...@michaels.me.uk wrote: if shelling out for a enterprise license is not viable, you could try using Railo for the management site. On Fri, May 9, 2014 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: Would I need two CF server licenses for this...? No, just one Enterprise license. Also, this is CF Standard we're talking about. Does Standard do multi-server? No. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
max reqs
Hi! We have one ACF10 production server for two sites: 1 - a longer request-time management site 2 - a short request-time site for the public ( 300 milliseconds / req) What's the best/easiest way to reserve, say, half of my Maximum number of simultaneous Template requests for the short request-time site? Is there a way to do that via CF admin? Application vars? Programmatically? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: how much to charge for a e-commerce solution?
This thing is $250 http://www.cf-ezcart.com/live/ezcartlive.cfm On Sat, May 3, 2014 at 3:47 PM, Matthew Smith chedders...@gmail.com wrote: I need to put in a quote for an e-commerce solution. I have a solution that I have developed over the last decade. It has paypal and cc integration, a category and unlimited subcategory capability, the ability to handle unique, limited, and unlimited items, and a transaction locking mechanism so no duplicate order on unique or limited items. I am meeting with the business owners this week to discuss. I will be accepting about $650 in merchandise, though I could get the items for about $400 online. This is normal for the industry. I would normally quote an hourly rate but would rather have a flat price for this and maybe an option for overage hours. I am not the best for graphic design, so I would either contract that out or get a template. Fixed costs include template, credit card gateway, cert. I am figuring about 20 hours or so for labor, but I have put in countless hours to get the solution to the point it is. I am not sure what to quote and would really appreciate the help. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need help to configure SMS with CF application
Perhaps helpful...? http://smsgateway.riaforge.org On Tue, Apr 29, 2014 at 3:17 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear Friends, I have been provided with below details. I don't know how to configure SMS with CF application. Your valuable time help is really appreciated. SMS short code details: Action: Provide ShortCode: (4 digit no) Sender ID: Admin Throughput: 5 Classification: Normal SMS Connectivity details: IP address: Action: Provide Thanks, Sathya (sathya0...@gmail.com) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFB3
Hi! Working on justifying upgrade from CFB2 to CFB3 to my boss. Three new features listed here do not apply to us at the moment: http://www.adobe.com/products/coldfusion-builder/coldfusion-builder-features.html Thought I remembered reading that this is a huge re-write with lots of performance improvements, bug-fixes, etc. Did I hallucinate that? Anyone have any suggestions / advice? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFB3
Is that officially documented somewhere so that I don't have to tell my boss, Steve from the Internet says, 'Major performance improvements?' No offense, Steve. *I* know you...but my boss does not. I suppose I could include http://klout.com/#/cutterbl or something. :-) On Tue, Apr 29, 2014 at 1:55 PM, Steve 'Cutter' Blades cold.fus...@cutterscrossing.com wrote: Major performance improvements. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 4/29/2014 12:42 PM, John M Bliss wrote: Hi! Working on justifying upgrade from CFB2 to CFB3 to my boss. Three new features listed here do not apply to us at the moment: http://www.adobe.com/products/coldfusion-builder/coldfusion-builder-features.html Thought I remembered reading that this is a huge re-write with lots of performance improvements, bug-fixes, etc. Did I hallucinate that? Anyone have any suggestions / advice? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does Not Contain Number
isnumeric(listfirst(316 Spring Creek Dr., )) On Sun, Apr 20, 2014 at 3:12 PM, David Moore dgmoor...@hotmail.com wrote: How do I check to see if a string includes (or does not contain) an integer or number. I am trying to check the Address form field to see if it 'Does Not Contain' a number as in 316 Spring Creek Dr. I want to see if they left out the 316. Thanks in advance for any help. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does Not Contain Number
refind(\d, P.O. Box 316) On Sun, Apr 20, 2014 at 3:36 PM, David Moore dgmoor...@hotmail.com wrote: Is there a way to check the whole string and not just the first part in case it is a P.O. Box 316? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does Not Contain Number
I believe that refind will return zero if no digit. Therefore, you should be able to use cfif refind(/d, form.yourvar) On Apr 20, 2014 4:41 PM, David Moore dgmoor...@hotmail.com wrote: Well, you are doing a great job. I guess I am not communicating well. I was using the 316 as an example. I want to check an address field passed from a form where the value is unknown. I just want to be able to check using Does Not Contain or IsNumeric or other Cold Fusion test in a cfif statement to determine if the passed string contains a number. Does that help? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does Not Contain Number
Regex shorthand for digit. On Apr 20, 2014 5:34 PM, David Moore da...@upstateweb.com wrote: For education reasons, what does the '/d' reference? How does that tell the statement to look for a number? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFHTTP SSL Cert
When cfhttp is broken, can you drop the URL into your browser and have it work? Or is it broken there too? On Wed, Apr 16, 2014 at 12:27 PM, Brook Davies cft...@logiforms.com wrote: Hey Peeps, After heartbleed, I had to re-add the EchoSign Cert to our keystore (via the keytool) on all our servers. It worked as expected, and the connection started working again. However, on one our webservers, it works, and then later that day stops being able to connect and I get I/O Exception: peer not authenticated when I try to CFHTTP to the HTTPS address. If I restart the server, it works again, and then stops working again later in the day. What the heck could cause that? My other webservers work without an issue. But this one seems to keep failing. The cert IS in the keystore... Any ideas? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
weird issue with utility
I have a little utility I run on my dev box which calls data-fetching processes on my production box. Usually works great: cfloop index=i from=0 to=-90 step=-1 cfhttp url=http://production.com/?Date=#DateFormat(DateAdd('d', i, now()), 'm/d/')# /cfloop But now I have it pointed at a different process and here's what happens: 1. I tell utility to go 2. Using Fusion Reactor, I can see that http://production.com/?Date=4/15/2014 has been called and is running on production 3. When, that finishes, http://production.com/?Date=4/14/2014 is *not* called but my utility keeps spinning as if it's still doing its thing Any ideas? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: weird issue with utility
Right. Usually, it runs serially just fine. With this production URL, it behaves in the way I described. On Tue, Apr 15, 2014 at 3:42 PM, Dave Watts dwa...@figleaf.com wrote: I have a little utility I run on my dev box which calls data-fetching processes on my production box. Usually works great: cfloop index=i from=0 to=-90 step=-1 cfhttp url=http://production.com/?Date=#DateFormat(DateAdd('d', i, now()), 'm/d/')# /cfloop But now I have it pointed at a different process and here's what happens: 1. I tell utility to go 2. Using Fusion Reactor, I can see that http://production.com/?Date=4/15/2014 has been called and is running on production 3. When, that finishes, http://production.com/?Date=4/14/2014 is *not* called but my utility keeps spinning as if it's still doing its thing Any ideas? I'm pretty sure that HTTP requests made from CF, by default, will run serially rather than concurrently. So, until the first URL finishes and CF gets a completed response, the loop won't go to the next one. You can avoid this by using CFTHREAD, although that may cause other problems if you're not careful - I'm not sure I'd want to use 90 threads in a production environment. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: weird issue with utility
Good idea. I'll check... On Tue, Apr 15, 2014 at 4:13 PM, Byron Mann byronos...@gmail.com wrote: It sounds like maybe the first cfhttp call from the client is ending with maybe a 500 error at the production.com URI and not really returning a response to the client. In that instance I can see the first iteration in the client side loop just stalling, while on the end point side, Fusion Reactor thinks the request is done. Do you get output on the client side when just calling the first iteration... cfloop index=i from=0 to=-90 step=-1 cfhttp url=http://production.com/?Date=#DateFormat(DateAdd('d', i, now()), 'm/d/')# cfdump var=#cfhttp# cfbreak /cfloop Byron Mann Lead Engineer Architect HostMySite.com On Tue, Apr 15, 2014 at 3:32 PM, John M Bliss bliss.j...@gmail.com wrote: I have a little utility I run on my dev box which calls data-fetching processes on my production box. Usually works great: cfloop index=i from=0 to=-90 step=-1 cfhttp url=http://production.com/?Date=#DateFormat(DateAdd('d', i, now()), 'm/d/')# /cfloop But now I have it pointed at a different process and here's what happens: 1. I tell utility to go 2. Using Fusion Reactor, I can see that http://production.com/?Date=4/15/2014 has been called and is running on production 3. When, that finishes, http://production.com/?Date=4/14/2014 is *not* called but my utility keeps spinning as if it's still doing its thing Any ideas? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Heap and RAM
Here's a strange one: We have one process that consumes a LOT of RAM. (It parses a huge XML file.) It usually runs with no problem. Sometimes, it errors-out with a CF out of Java heap space error. Not most days...just sometimes. Last week, we added 2 GB of RAM to the server to bring the total up to 4 GB and I bumped up CF's min/max heap size from 1 GB to 1.4 GB. Since then, process in question has failed every day with out of Java heap space error...until I restart the CF server service and run the process right away after it restarts. Any idea what's going on? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Heap and RAM
Do you have specified sizes for the young and perm generations? If not, you might want to set them. No. How do I do that? On Mon, Apr 14, 2014 at 9:21 AM, Dave Watts dwa...@figleaf.com wrote: We have one process that consumes a LOT of RAM. (It parses a huge XML file.) It usually runs with no problem. Sometimes, it errors-out with a CF out of Java heap space error. Not most days...just sometimes. Last week, we added 2 GB of RAM to the server to bring the total up to 4 GB and I bumped up CF's min/max heap size from 1 GB to 1.4 GB. Since then, process in question has failed every day with out of Java heap space error...until I restart the CF server service and run the process right away after it restarts. The heap is not one big undifferentiated bucket of storage. It contains different sections, or generations, that are used to store different scopes of variables. Simply increasing the overall heap may not have any effect on the amount of storage for this variable. Do you have specified sizes for the young and perm generations? If not, you might want to set them. All that said, you might also want to switch to SAX parsing if you're working with extremely large XML files. SAX parsing is (in my opinion) a lot more programming work, but it's designed to let you solve this sort of problem. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm