Re: CF builder installer?
Doug, I've reached out to Gavin to give him a copy of the installer (I have the Update 1 version of the Windows installer). It's 32-bit only (there was no 64-bit installer for CFBuilder 2). I'll send you a direct email with a ling to my Dropbox folder where I have a copy. -Carl V. On 11/21/2014 4:03 PM, Doug R wrote: Thanks Carl - great resource. Unfortunately, though, there is only the Mac (.dmg) installer. I should have specified that I need a windows installer (don't recall if it comes in 32 and 64 bit flavors - 64 bit preferred). If anyone has a copy of the windows installer, I'd love to get a copy, and we can also add it to the repo. Thanks Doug R On Fri, Nov 21, 2014 at 3:05 PM, Carl Von Stetten vonner.li...@vonner.net wrote: http://www.gpickin.com/cfrepo/ -Carl V. On 11/21/2014 2:28 PM, Doug R wrote: Hi all - I just had my laptop reimaged and one of the items I am missing is the CFbuilder2 installer package. I have my serial... just need the installer. If anyone has it, I would appreciate it if I could get a copy. I tried to find it on adobe's site, but since 3 rolled out, I've had no luck. Thanks Doug R ~| 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:359707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF builder installer?
http://www.gpickin.com/cfrepo/ -Carl V. On 11/21/2014 2:28 PM, Doug R wrote: Hi all - I just had my laptop reimaged and one of the items I am missing is the CFbuilder2 installer package. I have my serial... just need the installer. If anyone has it, I would appreciate it if I could get a copy. I tried to find it on adobe's site, but since 3 rolled out, I've had no luck. Thanks Doug R ~| 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:359701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: HMAC Algorithms and Encoding?
Does SHA256 require the Java Cryptography Extension be installed, or is that just SHA512 and above? -Carl V. On 9/9/2014 11:36 AM, Sandra Clark wrote: Thanks Pete! -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: Tuesday, September 9, 2014 2:11 PM To: cf-talk Subject: Re: HMAC Algorithms and Encoding? Try HMACSHA256 for the algorithm see http://cfdocs.org/hmac -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://hackmycf.com - Is your ColdFusion Server Secure? http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10 minutes On Tue, Sep 9, 2014 at 11:22 AM, Sandra Clark sclarkli...@gmail.com wrote: ~| 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:359264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: expire application variable
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:359090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Calling a Custom Tag Twice Duplicates Query Results?
Yup, MX was attached to the version numbers of both ColdFusion releases that Macromedia was responsible for. Adobe dropped the MX when they released ColdFusion 8. On 5/30/2014 8:19 AM, Scott Brady wrote: On Wed, May 28, 2014 at 1:57 PM, Phillip Vector vec...@mostdeadlygame.com wrote: Also, it's either MX or 7. :) No, Dan was right. Version 7 was ColdFusion MX 7. Which is just kind of a weird way to number it. ~| 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:358704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Builder 3 frustrates!!!
You can actually import your entire CFB2 workspace if you want (projects included). By default (and on Windows), CFB2 put the workspace in C:\Users\Username\Adobe ColdFusion Builder Workspace. You can point CFB3 to that same workspace if you want, or copy it into the one created by CFB3 (probably in a similar place). At least that worked with the Thunder Beta version I have. -Carl V. ~| 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:358587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable to add text to HTML HEAD tag
Rewrite the whole thing right now? No. I would progressively replace CF UI tags with clean JS frameworks or custom JS as you touch each section of your application. You'll find fewer and fewer people are using the CF UI tags and therefore less and less assistance available. And most of the CF UI tag problems people seek assistance with are directly related to shortcomings/bugs in said tags that will probably never be fixed by Adobe. Considering that the CF UI stuff is built on top of JS libraries that are several versions (and several years) old, you are far better off investing in implementing current versions of JS libraries yourself and reaping the benefits of the cumulative feature improvements/bug fixes of those libraries. Just my $0.01 (inflation sucks, don't it) -Carl V. On 5/7/2014 8:35 AM, John Pullam wrote: So you suggest going back and rewriting a 50,000 line application in order to resolve the problem? Not a very practical solution, I'm afraid. Does anyone have a more realistic suggestion? ~| 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:358574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: DW versions that supported CF
Bruce, If you can make it through the first two weeks using CFBuilder, you probably won't look back at Dreamweaver (at least for ColdFusion coding). I was a long-time Dreamweaver user before switching to CFBuilder 2. After a couple of weeks, I never opened Dreamweaver again. And that was despite some of the little quirks of CFBuilder/Aptana. The CFBuilder 3 beta seemed to be pretty solid (Adobe ripped out Aptana and rewrote the HTML/JS/CSS/CFML parser, code insight, code completion stuff), and is much faster and free of the quirks that annoyed me. Plus you can add in any Eclipse plugins that are useful to you (I like the MXUnit and EGit plugins for Unit Testing and Git interactions, respectively). -Carl V. On 4/30/2014 11:16 AM, Bruce Sorge wrote: On my machine using CC, I just told it to open .cfm files with dreamweaver by default, then it works. I even have tag insight. What it won't do is create a .cfm file. I have to do a file - save-as .cfm. I think that I need to embrace the new builder going forward. Bruce Sent from my iPhone 5S On Apr 30, 2014, at 1:59 PM, Russ Michaels r...@michaels.me.uk wrote: the creative cloud version does support CF, but it is not enabled by default and is depreciated, but I have seen posts explaining how to get it working, so do a bit of googling and you should find it. On Wed, Apr 30, 2014 at 6:08 PM, Gerald Guido gerald.gu...@gmail.comwrote: I think DW 6 was the last one to support CF -- Gerald Guido Twitter https://twitter.com/CozmoTrouble Blarg http://www.myinternetisbroken.com Facebook https://www.facebook.com/gerald.guido.9 On Wed, Apr 30, 2014 at 1:05 PM, Ben b...@webworldinc.com wrote: Looking at the version list would that be CS 5.5? Ben On Apr 30, 2014, at 9:53 AM, Bruce Sorge sor...@gmail.com wrote: The version just prior to Creative Cloud. Bruce Sent from my iPhone 5S On Apr 30, 2014, at 12:48 PM, Ben b...@webworldinc.com wrote: Hi What was the most recent version of DW that still supported CF? I've been using an older version and want to upgrade but am not going to learn a different platform just to upgrade. Thanks! Ben ~| 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:358488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: DW versions that supported CF
Bruce, Good stuff. And in case you didn't know, you can use the CFBuilder 3 trial version until it expires, then it reverts to CFBuilder Express. So you can continue to use most of it's functionality until you are ready to make the purchase. -Carl V. On 4/30/2014 12:13 PM, Bruce Sorge wrote: Carl, I know. I was one of the original testers of CF11 and Builder 3, but I had to stop testing. I am still on Active Duty and I am also a full time college student, and since I didn't have any actual CF projects (only PHP at the time), I didn't have the time to dedicate to any real testing. Once I finish these four classes and graduate school, I plan to install CF11 (on my VMWare partition since there are features that don't work on a Mac) and buy Builder 3 and start back into working with the two. Bruce ~| 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:358490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFB3
John, I'm not going to use those top 3 new features either. But the performance is definitely vastly improved over CFB2 because they scrapped Apatana and rewrote the entire code insight/formatting parts for HTML/JS/CS/CFML. And there's now a 64-bit Windows installer, so no more having to do the Eclipse + CFBuilder plugin thing. They also incorporated Eclipse 4.3.1 (Kepler SR1) instead of the old Eclipse 3.7.2 (Indigo SR2). -Carl V. On 4/29/2014 10:42 AM, 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:358467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
John, Are you able to manually create a 32-bit ODBC connection to your Access database? If you weren't aware already, you need to run the 32-bit Windows ODBC data sources applet from inside \Windows\SysWOW64 to access the 32-bit stuff. If you can do that successfully, then try connecting to that 32-bit ODBC data source from within CF Administrator. HTH, -Carl V. ~| 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:358440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 does not allow Access datasource
John, The behavior you are describing with the ODBC service does not sound normal. Have you looked around in the Windows event viewer to see if there are any error messages related to the ColdFusion ODBC Service? Isn't there also a second ODBC-related service for ColdFusion? Is that one running? They both may need to be reinstalled. -Carl V. On 4/28/2014 12:58 PM, John Pullam wrote: I went into Services and the ODBC service is defined and it set up as automatic. When I started it, it said it started and then stopped. It indicated that some services only start when they are needed. I then made it manual and started it again and received the same message. So I think that it believes it is there and is able to run. ~| 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:358452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 java applet error. any solutions?
If you've upgraded to the Java 7 JVM (1.7.x) on your desktop, the error may be due to a new security feature. Take a look at this thread on the Adobe forums: http://forums.adobe.com/thread/1433308?tstart=0 -Carl V. On 4/1/2014 12:18 PM, Dave Watts wrote: Russ is this a new thing? I have an application that used to work ok using CFGRID all over the placeSuddely they dont work.I had to run through the whole app and change the CFGRID's to tables and recode them. Are you saying that something's changed in ColdFusion that those applets can never work safely in production because they rely on RDS? These are two separate issues. The RDS thing only applies to the applets used in the CF Administrator. But applets breaking in custom applications can happen when the client changes JVMs in some cases, or has some other issue with the downloaded JAR file. ~| 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:358282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Patch/update 9.0 help
Did you do a backup of your computer before the upgrade so you can revert? If so, take a look at the Unofficial Updater 2 http://www.uu-2.info/ to make the patching process a bit easier. -Carl V. On 3/21/2014 4:49 PM, Pete Ruckelshaus wrote: Awesome. Ran the 9.01 updater and the CF service won't restart now. This is why I don't update unless I have to. On Fri, Mar 21, 2014 at 6:56 PM, Russ Michaels r...@michaels.me.uk wrote: ~| 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:358072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFC Not Returning JSON properly from an array
Are you doing SerializeJSON() in your CFC method, AND have returntype=JSON on the function definition? If so, it is double serializing the data. Remove the SerializeJSON() call and allow the function to automatically do the serialization. HTH, -Carl V. On 3/14/2014 12:26 PM, Rixon Reed wrote: I have a CFC that I'm trying to return JSON data in a web service.=20 If I do a dump before I return the code to the calling program, the JSON is= fine. However it returns this to the calling program:[\\\n\\t\\n\\t\\t\\= n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\= t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\\/portfolio\\n\\t\\n\\t\\t\\n\\t\\t\\n\\t\\= t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\\/portfolio= \\n\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\\/portfolio\\n\\t\\n\\= t\\t\\n\\t\\t\\n\\t\\\/portfolio\\n\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\= t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\\/portfolio\\n\\t\\= n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\= t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\= t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\= n\\t\\\/portfolio\\n\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\= t\\\/portfolio\\n\\t\\n\\t\\t\\n\\t\\t\\t\\n\\t\\t\\t\\\/category\\n\\t= \\t\\\/category\\n\\t\\\/category\\n\\t\\n\\t\\t\\n\\t\\t\\\/category= \\n\\t\\t\\n\\t\\t\\t\\n\\t\\t\\\/portfolio\\n\\t\\t\\n\\t\\t\\\/categor= y\\n\\t\\t\\n\\t\\t\\\/category\\n\\t\\t\\n\\t\\t\\t\\n\\t\\t\\\/portfo= lio\\n\\t\\t\\n\\t\\t\\\/portfolio\\n\\t\\t\\n\\t\\t\\t\\n\\t\\t\\t\\t\\= n\\t\\t\\t\\t\\n\\t\\t\\t\\\/portfolio\\n\\t\\t\\t\\n\\t\\t\\t\\t\\n\\t\\= t\\t\\t\\n\\t\\t\\t\\\/portfolio\\n\\t\\t\\\/category\\n\\t\\t\\n\\t\\t= \\\/portfolio\\n\\t\\\/category\\n\\t\\n\\t\\\/portfolio\\n\\t\\n\\t= \\\/portfolio\\n\\t\\n\\t\\\/portfolio\\n\\\/root\,\\\n\\t\\n\\t\\\= /category\\n\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\t\\n\\= t\\t\\n\\t\\t\\n\\t\\t\\n\\t\\\/portfolio\\n\\t\\n\\t\\t\\n\\t\\t\\n\\t\= \\/portfolio\\n\\t\\n\\t\\\/category\\n\\t\\n\\t\\\/category\\n\\\/ro= ot\] What am I doing wrong? Thanks in advance. ~| 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:357936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Default Values for Built-in Function Optional Parameters
Byron, That's the problem with positional vs. named arguments on BIFs. I ran into this with a cross-platform app that needed to run on ACF Railo. Railo supports named parameters for some BIFs (including cachePut() ), but ACF doesn't. So I had to split my caching function into separate CFCs for ACF Railo. The line that runs cachePut() in ACF looks like this: CachePut( id, val, , , myregion ); while the one for Railo looks like this: CachePut( id:id, value:val, cacheName:myregion ); The empty strings for the two timeout arguments is acceptable on ACF. -Carl V. On 3/10/2014 8:25 AM, Byron Mann wrote: Specifically I've created a caching region, and will just be using the defaults for the time-outs. CachePut(id, value, [timeSpan], [idleTime], [region], [throwOnError]); So I'd like to just do something similar to this: CachePut(id=x, value=v, region='myregion'); This doesn't work of course. I also tried, argumentCollection without success. I'm assuming this is just the way life is and will have to do something to just pass the region defaults. cachePut(id, val, CacheGetProperties('myregion').TIMETOIDLESECONDS, CacheGetProperties('myregion').TIMETOLIVESECONDS, 'myregion'); Byron Mann Lead Engineer Architect HostMySite.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:357909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF session management suddenly not sticking ...
I think it was pretty clear that code he listed was being used solely to diagnose a problem he was experiencing **on a production server** and from **multiple client computers**, and that wasn't necessarily reproducible on a development server. And I don't think the code was meant for permanent use. So I think your assumptions and gruffness and were a bit off the mark. -Carl V. On 3/6/2014 7:35 PM, Andrew Scott wrote: If you are going to be dumping things out in production, for the world to see, I would stop that habit. The last thing you want to do is annoy your clients / visitors with this stuff. People are not forgiving when they see these things on the screen, personally if you have to do this, for god sake lock this output down to your development IP address. Really Why do people insist on making changes directly on a production server... Seriously bad practice. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 ~| 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:357876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF session management suddenly not sticking ...
+1 for J2EE sessions. -Carl V. On 3/7/2014 9:20 AM, Dave Watts wrote: The best solution, in my opinion, is to switch to J2EE sessions, assuming you can invest the time and effort to do that. ~| 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:357878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF session management suddenly not sticking ...
IIRC, unless you explicitly access CFID/CFTOKEN in your code, there shouldn't be any issues. -Carl V. On 3/7/2014 10:45 AM, Les Mizzell wrote: So considering the above - what, in theory, would be the exact consequences in switching to J2EE sessions? I don't this there would be that much code that would need to be changed. I'm simply checking that session.isADMIN is true in my application file. I admittedly don't have a super-technical understanding of exactly how things have changed between CF8 and CF10. ~| 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:357884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF session management suddenly not sticking ...
I forgot about the persistence issue. Personally, I consider the lack of session persistence to be a security benefit. But not everyone will agree. -Carl V. On 3/7/2014 11:17 AM, Dave Watts wrote: If you're not directly referencing CFID and CFTOKEN in your code, and you're not relying on the default persistence of CF session cookies, you should be able to just enable that option. By the default persistence of CF session cookies, I mean that CF's session cookies by default don't get deleted when the browser is closed. J2EE session cookies do. So, if a user logs into your app, closes the browser, then opens it back up, the user will have to log in again if you're using J2EE sessions even if the session would not have expired otherwise. ~| 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:357886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF session management suddenly not sticking ...
I think by add on he might have been referring to a browser add-on or plugin that the users have installed into Internet Explorer. -Carl V. Or maybe you have an add on that is killing cookies. That was my very first thought and I went straight to the design team who swore that we weren't doing anything genuinely different. Nonetheless we pulled a bunch of stuff out with no success. To finally clear that I wrote up the bare bones page (previous post) and it too is evidencing the problem. I'm in full control of the server and there's nothing server-side changed at the server level. BTW it is CF9 with all patches. ~| 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:357888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Textfield Format
Yeah, sorry. I somehow completely overlooked the ExtJS reference in the OP. -Carl V. On 2/27/2014 4:01 AM, Steve 'Cutter' Blades wrote: Carl, You should really review the documentation on the ExtJS site, for the version you are using. You do not need additional plugins for this type of thing. Ext allows you to define default empty text, masked input, and you can put a listener on the field's render event, to place the cursor on focus. The Ext forums, on the Sencha site, are a good place for this sort of info... 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 2/25/2014 3:38 PM, Carl Von Stetten wrote: Richard, You'll need to do some JavaScript magic to accomplish that. There are some widgets and jQuery plugins out there that seem to fit the bill: http://digitalbush.com/projects/masked-input-plugin/ (jQuery plugin) http://jquery-plugins.net/tag/masked-input (a list of jQuery plugins) http://jasny.github.io/bootstrap/javascript/#inputmask (Bootstrap plugin) -Carl V. On 2/25/2014 12:13 PM, Richard White wrote: Hi, This is not really a CF question but rather seeking general code advise. I want to create a textfield using ExtJS and would like the user only to have access to alter parts of the text... For example, I want to populate the textfield with 'CP - - U' When the user clicks on this textfield I want the cursor to start blinking next to the P (in the position of the empty space). Then as the user types I would like the textfield to replace the empty spaces. When they get to a dash it automatically skips the dash and keeps typing where the next underline is. Is there a special kind of textfield or formatting that can be used to achieve this? Many thanks for any advise. 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:357782 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Textfield Format
Richard, You'll need to do some JavaScript magic to accomplish that. There are some widgets and jQuery plugins out there that seem to fit the bill: http://digitalbush.com/projects/masked-input-plugin/ (jQuery plugin) http://jquery-plugins.net/tag/masked-input (a list of jQuery plugins) http://jasny.github.io/bootstrap/javascript/#inputmask (Bootstrap plugin) -Carl V. On 2/25/2014 12:13 PM, Richard White wrote: Hi, This is not really a CF question but rather seeking general code advise. I want to create a textfield using ExtJS and would like the user only to have access to alter parts of the text... For example, I want to populate the textfield with 'CP - - U' When the user clicks on this textfield I want the cursor to start blinking next to the P (in the position of the empty space). Then as the user types I would like the textfield to replace the empty spaces. When they get to a dash it automatically skips the dash and keeps typing where the next underline is. Is there a special kind of textfield or formatting that can be used to achieve this? Many thanks for any advise. 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:357762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from CF8 tp CF10 - Session Issues
Dan, Please make sure to log a bug with Adobe https://bugbase.adobe.com/index.cfm on this so they fix it in Splendor before the final release. -Carl V. On 2/22/2014 4:37 PM, Dan Crouch wrote: I was testing a migration from CF8 to the Splendor Beta and I ran into a weird session issue. In my case, a session ID is inserted into a database table and there is a select that makes sure it is still the same a bit farther down. I was logging in and getting sent right back to the login screen. I found that the variable being inserted had some extra blank spaces and possibly a newline at the end. When outputting the variable, it looked exactly the same but the insert and select didn't match up. I ended up trimming the variable on the insert and select and that fixed the problem for me. It works fine in CF8 and CF9, I hadn't tried it in 10 yet, but the break is there in the new beta. I'm not sure what the problem is exactly, I just wanted to fix it so I could keep testing. ~| 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:357741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
9.02 is not an update - it is a full install (see Charlie Arehart's blog entry for an excellent explanation http://www.carehart.org/blog/client/index.cfm/2013/8/19/understanding_ColdFusion_9.0.2_a_FAQ). As such, it cannot be installed over the top of 9.0 or 9.0.1. -Carl V. On 2/13/2014 9:19 AM, Richard White wrote: Just to double check, is it OK to install 9.02 update instead of all the 9.01 hot fixes. I am sure 9.02 will contain all the fixes but just wanted to make sure thanks Richard Some of those updates in CF 9 were pretty tricky. I would checkout the cfUpdater project for RIAForge. It can handle a lot of that craziness for you. http://cfupdater.riaforge.org/ 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/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: danger in increasing PostParameterLimit ?
Chris, I believe the danger involves the risk of the HashDOS issues that Pete elaborates on in his posts (which you cited). Is your application public-facing or intranet-only (behind a corporate firewall)? If public facing, then you have to weigh the potential for HashDOS vulnerability against the needs of the application. Where are all those parameters coming from? A single gigantic web form with more than 1,100 fields? A web service call? If it's a web form, can the application be rewritten to use multiple form sections (like walking through a multi-page wizard) and send the form data in pieces to the server (maybe adding each section's fields to a session variable until the last page is completed)? -Carl V. On 1/17/2014 7:52 AM, Chris wrote: How dangerous is increasing PostParameterLimit in CFv9 ? We have increased from the default 100 to 1,100 to meet applications' needs. We are now requested to consider increasing it to 2,000. The developers are reviewing updating the design to use fewer PostParameters. I don't have a good feel for how dangerous this could be. Comments? Tomcat, Microsoft, and Adobe seem to have quite different considerations of the danger, based on their default number of post parameters: ASP.net1,000 Tomcat 10,000 ColdFusion 100 ColdFusion: ColdFusion Security Hotfix APSB12-06 http://helpx.adobe.com/coldfusion/kb/coldfusion-security-hotfix.html Understanding HashDos and postParameterLimit http://www.petefreitag.com/item/808.cfm HashDOS and ColdFusion http://www.petefreitag.com/item/801.cfm thank you, Chris ~| 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:357472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: per application settings
Eric, I don't think ColdFusion mappings are involved when accessing files other than ColdFusion templates and components (.cfm and .cfc). If you look at the source of your web page in your browser, you'll probably see that the URLs are still /cup/images/image.png. The web server then prepends the server name when handling the request. You'll need to create a cup virtual directory for that host, and point it to where the mapping is pointing. If the only purpose of the mapping is for URLs to static resources, you don't even need the mapping at all. As a side note, is the application scope even available to make assignments before the onApplicationStart() function is called? Your application.cuproot variable may not even exist when the constructor is processing the cfset this.mappings... stuff (especially on first run of the application). HTH, -Carl V. On 11/26/2013 10:36 AM, Eric Roberts wrote: I am trying to set up some local mappings (CF9) and it doiesn't seem to recognize it. I have this as part of several variables that are set before the 1st function in my application.cfc... cfset this.mappings[ /cup ] = #application.cuproot#/cup For instance...when I try to access an image in a directory (the path from the root is /cup/images/image.png), I call img src=/cup/images/image.png /, instead of mapping it like i would expect it to, it just appends the server url and i get something like http://www.xxx.com/cup/images/image.pngwhen it should be http://www.xxx.com/er/cup/images/image.png. I have dumped application.cuproot and it has the appropriate value. It just seems to be ignoring the fact that i am setting up a CF mapping, If I do the mapping in cf admin...it works as expected. ~| 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:357146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: per application settings
Eric, To clear up any questions about how the URL is being built/coded, can you post the content of your .cfm file that handles the header. -Carl V. On 11/26/2013 11:52 AM, Eric Roberts wrote: Philip...it is in a .cfm file that handles the header. in this specific instance, it is calling up a logo image in the header. If this was in an html file, then they would be correct...but in a cfm file...everything is parsed. The point behind having mappings is so that in the code, you are refering to a directiory by name rather than having to deal with what the path is from the file. CF handles determining what that is when it renders it int o html. Eric ~| 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:357167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with data formatting in CFINSERT
If you move to MSSQL 2008 or newer, the varchar(MAX) nicely replaces the Access TEXT data type. If you use the SQL Server import tools rather than the Access migration tools, you should be able to do identity insert on on auto increment columns and preserve their values. -Carl V. On 11/5/2013 7:27 AM, Ben wrote: Yep. That sounds familiar. And some of the auto incrementing features in access don't convert well. Perhaps a more recent conversion package version does a better job these days. This was about 9 years ago. Ben On Nov 5, 2013, at 8:20 AM, Russ Michaels r...@michaels.me.uk wrote: Microsoft provide a free migration tool, as you are obviously on windows I would suggest going with MSSQL and not MySQL http://www.microsoft.com/en-gb/download/details.aspx?id=28763 the code changes are fairly minimal unless your app is huge, but if memory serves it is mainly issues with primary keys and TEXT fields to varchar fields you will have to deal with. On Tue, Nov 5, 2013 at 3:06 PM, Ben b...@webworldinc.com wrote: Hi Russ For those of us who have been out of the loop for a while, can you suggest easy to implement alternatives to 32 bit MS access? I did a conversion of a DB to SQL server some years back and that was painful. Ben On Nov 5, 2013, at 7:52 AM, Russ Michaels r...@michaels.me.uk wrote: well someone has to say it... but why the frack are you still using MSACCESS when there are so many better/free alternatives? you know the Jet driver (which is what you use to connect to MSACCESS) is no longer supported by Microsoft and ha snot been for years and only runs in 32 bit, and as such does not work on modern 64bit OS (without lots of hacking to get it to run in 32bit mode), which is Windows Server 2008 onwards, there is no 32 bit windows any more. On Tue, Nov 5, 2013 at 2:44 PM, wrote: I have robot updaters and inserters too (made all the more robotic with the help of cfdbinfo figuring out the field types), This is what I do, but using my own CFX_ODBCinfo I developped years before cfdbinfo was available, and I'm still using it because cfdbinfo doesn't work for Access databases. Debugging is miserable with a layer of code in the middle and straightforward without. Right, I think I'm going to improve my CF_INSERT tag by generating the SQL code in the tag. ~| 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:357048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: No directory deletion after cfcontent
I believe cfcontent effectively issues an abort after execution (at least the CF10 docs say so, not sure about CF9), so any code that follows the cfcontent is not executed. You might be better off setting up a recurring scheduled task to do your directory cleanup. HTH, -Carl V. ~| 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:356555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does Windows 7 include SMTP server?
Joy, Windows 7 (any addition) **does NOT** include an SMTP server. The SMTP Mail Server icon in IIS Administrator is to point ASP.NET apps to a SMTP server elsewhere on your network (or a third-party SMTP server running on localhost). This is equivalent to setting the mail server settings in ColdFusion Administrator. So, like Dave Watts suggests, you might try Apache James. -Carl V. On 8/13/2013 7:36 AM, Joy Paulose wrote: Does windows 7 include SMTP server? I came across some notes on windows discussion forum that said windows 7 does not include SMTP Mail server. But after the installation of IIS 7.5 from the components and features it does shows SMTP mail server icon on IIS Manager. Microsoft does not have enough documentation about this though. I am talking about Windows 7 Professional on local environment. This is a stand along machine just for development purposes. I have ColdFusion 9 installed and working just perfect on IIS 7.5. I am trying to connect to SMTP server for CFMAIL to work. Thanks Joy Developer ~| 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:356544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
I wonder if the problems with cfquickdocs and cfgloss are related to the switchover of the ColdFusion docs to the new wiki format? Or is that only for CF10 docs? -Carl V. On 8/19/2013 7:15 AM, DURETTE, STEVEN J wrote: I know from trying to look something up last week that I couldn't get to cfquickdocs and cfgloss took over 15 minutes to load before I could search. ~| 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:356497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does Windows 7 include SMTP server?
Joy, At least two other people have already answered this question in your other thread. Windows 7 does come with SMTP server, but it is not installed by default. You'll have to install it from add/remove Windows Features. You also need IIS6 Management Console to manage SMTP. -Carl V. On 8/13/2013 7:36 AM, Joy Paulose wrote: Does windows 7 include SMTP server? I came across some notes on windows discussion forum that said windows 7 does not include SMTP Mail server. But after the installation of IIS 7.5 from the components and features it does shows SMTP mail server icon on IIS Manager. Microsoft does not have enough documentation about this though. I am talking about Windows 7 Professional on local environment. This is a stand along machine just for development purposes. I have ColdFusion 9 installed and working just perfect on IIS 7.5. I am trying to connect to SMTP server for CFMAIL to work. Thanks Joy Developer ~| 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:356447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion.server.ServiceFactory get datasource names? cf10
Morchella, You shouldn't be using the ServiceFactory stuff anyway, as that is undocumented and subject to change without notice. Take a look at the Administrator API (provided that isn't locked down as well): http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html. Take a close look at datasource.cfc. HTH, -Carl V. On 8/13/2013 11:04 AM, morchella wrote: They turned this off on one of our servers. we do not have access to cfadmin. can any one think of a way to output the names of dsn's set up on a server without having access to java objects? any help would be appreciated! -m Detail Access to Java objects in the ColdFusion package has been disabled by the administrator. Message Permission denied for creating Java object: coldfusion.server.ServiceFactory. ~| 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:356450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Address Prompts for Java Updates
Just to add to Pete's comments: the prompts you are seeing are probably not for the Java JVM that ColdFusion is using; most likely it is the Java client JVM that is used by apps and web pages that have Java plug-ins. To upgrade the JVM for ColdFusion, you'll need to download and install the latest Java SE JDK from Oracle - this JVM has additional server components that ColdFusion needs. Once that is installed, as Pete said, you'll need to update the JVM path to point to the new Java SE JDK. Again, you'll need to install all the hotfixes first as Pete stated. -Carl V. On 7/2/2013 1:39 PM, Pete Freitag wrote: Java 1.6.0_17 has several of security issues, so you probably do want to update java, BUT you need to make sure you have applied the latest ColdFusion hotfixes first because Java 1.7 support was only added a few months ago via hotfixes. You don't want to overwrite the C:\ColdFusion\runtime\jre JVM, you want to install the jvm in its own place, and then update the JVM path in your ColdFusion administrator or jvm.config file. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://hackmycf.com - Is your ColdFusion Server Secure? http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10 minutes ~| 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:356121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to Address Prompts for Java Updates
I don't see any replies from you on this thread... I think there are two parallel threads going here. -Carl V. On 7/3/2013 8:56 AM, Russ Michaels wrote: Isn't that what I said :) Russ Michaels www.michaels.me.uk On 3 Jul 2013 16:21, Carl Von Stetten vonner.li...@vonner.net wrote: Just to add to Pete's comments: the prompts you are seeing are probably not for the Java JVM that ColdFusion is using; most likely it is the Java client JVM that is used by apps and web pages that have Java plug-ins. To upgrade the JVM for ColdFusion, you'll need to download and install the latest Java SE JDK from Oracle - this JVM has additional server components that ColdFusion needs. Once that is installed, as Pete said, you'll need to update the JVM path to point to the new Java SE JDK. Again, you'll need to install all the hotfixes first as Pete stated. -Carl V. On 7/2/2013 1:39 PM, Pete Freitag wrote: Java 1.6.0_17 has several of security issues, so you probably do want to update java, BUT you need to make sure you have applied the latest ColdFusion hotfixes first because Java 1.7 support was only added a few months ago via hotfixes. You don't want to overwrite the C:\ColdFusion\runtime\jre JVM, you want to install the jvm in its own place, and then update the JVM path in your ColdFusion administrator or jvm.config file. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://hackmycf.com - Is your ColdFusion Server Secure? http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10 minutes ~| 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:356124 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best means of setting a library of reusable code
Rick, I don't know if this will help, but I've read about people creating proxy CFCs in or below the webroot specifically for AJAX requests. Those proxy CFCs either extend the protected CFCs (the ones outside the webroot) or have functions that call the protected CFCs through createObject() or other similar means (which breaks encapsulation, but I think that doing this was thought of as a justifiable exception to encapsulation). You would still need to create mappings to the CFCs that reside outside the webroot, but you likely would have to do that anyway if you use the same CFCs elsewhere in your application. -Carl V. On 6/25/2013 12:03 PM, Rick Faircloth wrote: Well, the good news is that I can include the application variables in the AJAX post and pass them into the contact.cfc (which is also out of the webroot and in the library) via the AJAX call to contact.cfc. The bad news is, I have to type all those application variables into every AJAX call. But, at least I only have to type them in once for the reusable code! ~| 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:356076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adobe no longer supports ColdFusion??? Really?
One weird thing I noticed when installing Dreamweaver CC: it actually stopped mid-install and made me shut down my ColdFusion 10 services before I could proceed any further. If ColdFusion is no longer supported in DW, why would it be checking for and stopping if ColdFusion is running? -Carl V. On 6/18/2013 10:07 AM, Mike K wrote: Have I missed something here? I upgraded my Dreamweaver CS6 to Dreamweaver CC and ColdFusion is no longer supported apparently. There are no CFM file types, no tag hinting or code completion etc for ColdFusion, apparently. Unless I've missed something somewhere and I have to change a setting or install an extension or something. Has anyone else found a fix for this? Or have I got it wrong? ~| 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:356013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 11?
Alan, It was actually two versions of CF and two corresponding versions of CF Builder that were announced and are shown on the ColdFusion roadmap. Still, nice to see there is commitment to continued development of the product! :-) -Carl V. On 6/19/2013 7:49 AM, Alan Rother wrote: There has been a push in Adobe to get a new release of CF out no less than every 18 months... Also I've seen in public events, Adobe has a plan for at least the next 3 or 4 versions of CF. On Wed, Jun 19, 2013 at 4:40 AM, Casey Dougall - Uber Website Solutions ca...@uberwebsitesolutions.com wrote: On Wed, Jun 19, 2013 at 7:34 AM, Scott Stroz boyz...@gmail.com wrote: Actually, there was a public call to get in on the CF 11 pre-release a couple of months ago. After the amount of time it took them to make a functional installer for Windows 8 and Windows 2012 servers I'm not holding my breath for CF11 to come anytime soon ;-) Although there is the CF Summit in end of October so there is yet hope... -- Casey Dougall Ãœber Website Solutions (518) 633-1621 Saratoga Springs, NY http://uberwebsitesolutions.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:356016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 11?
While the tempo of software releases in the industry has increased, it has in many cases created a backlash. IT departments are struggling to keep up with installing updates to enterprise systems. Look at ColdFusion as an example. How many organization have bothered to upgrade to ColdFusion 10? I upgraded my department's server to CF 10 pretty soon after it was released, but our IT department only recently upgraded their CF server to CF 9 from CF 8 - and AFAIK they have no plans to upgrade to CF 10. Surveys others have taken across the CF community indicate very few organizations have upgraded to CF 10, and many are still on CF 7 and CF 8. Microsoft has significantly reduced the time between releases for SQL Server. Again, many organizations are way behind installing the new releases. I just upgraded my servers from SQL Server 2005 to 2008R2 within the past year, and 2012 was already available. Our IT department is still on SQL Server 2005, and I don't think they are planning on upgrading to any of the more recent releases any time soon. Again, I think this is probably pretty typical of many organizations. If ColdFusion was on an annual release cycle, how many organizations would actually upgrade annually? -Carl V. On 6/19/2013 11:31 AM, Byron Mann wrote: Software maintenence in the industry has always been frequent for the most part. Most of those updates are more reactive, as patches and hot fixes. I was getting more to feature additions and enhancements. 12-18 months between feature releases is quite a period with regards to technology these days. How often have we all been on the upcoming release webinars for a product with this type of release schedule and think to ourselves, Oh, finally. It seems the industry trend is headed towards a frequent release cycle. Cheers. Byron Mann Lead Engineer Architect HostMySite.com On Jun 19, 2013 1:48 PM, Steve 'Cutter' Blades cold.fus...@cutterscrossing.com wrote: You'll have to forgive my thought process here, but I just installed my 10th CF 10 updater in the CF Admin. That isn't iterative? 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 6/19/2013 1:11 PM, Byron Mann wrote: It's a shame Adobe is still going with long-term major releases instead of a more frequent and iterative schedule. The architecture, I would guess, is partially the reason for that. Seems like having a plug-in architecture would be the way to go. They could have a stripped down core product, then do add-ons through plug-ins and expansion packs that are fee based. This might make it more affordable and attractive for a wider customer base. We probably only use about 10% of the features/tags/functions, so why should we pay for the other 90%. I would imagine upgrading/patching, etc would be far less of a hassle as well. Byron Mann Lead Engineer Architect HostMySite.com On Wed, Jun 19, 2013 at 11:19 AM, Carl Von Stetten vonner.li...@vonner.netwrote: Alan, It was actually two versions of CF and two corresponding versions of CF Builder that were announced and are shown on the ColdFusion roadmap. Still, nice to see there is commitment to continued development of the product! :-) -Carl V. On 6/19/2013 7:49 AM, Alan Rother wrote: There has been a push in Adobe to get a new release of CF out no less than every 18 months... Also I've seen in public events, Adobe has a plan for at least the next 3 or 4 versions of CF. On Wed, Jun 19, 2013 at 4:40 AM, Casey Dougall - Uber Website Solutions ca...@uberwebsitesolutions.com wrote: On Wed, Jun 19, 2013 at 7:34 AM, Scott Stroz boyz...@gmail.com wrote: Actually, there was a public call to get in on the CF 11 pre-release a couple of months ago. After the amount of time it took them to make a functional installer for Windows 8 and Windows 2012 servers I'm not holding my breath for CF11 to come anytime soon ;-) Although there is the CF Summit in end of October so there is yet hope... -- Casey Dougall Ãœber Website Solutions (518) 633-1621 Saratoga Springs, NY http://uberwebsitesolutions.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:356023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) .NET vs. CF
Justin, With regard to a CFML engine running on .NET, New Atlanta has a BlueDragon .NET edition http://www.newatlanta.com/products/bluedragon/index.cfm that does exactly that. -Carl V. On 3/12/2013 2:07 PM, Justin Scott wrote: For those of u on this list that have experience with both, can I please get your feedback on the Pros and Cons of going to the .NET framework from ColdFusion? Hi Dave, that will depend on what you're doing with it. I don't have anything against .NET and have done some coding with it. The biggest headache about .NET is that it's a fully object-oriented language and everything is based around that. It's a lot harder to throw something together quickly with .NET than it is with ColdFusion. If you're building large well-designed applications that will be OO from the beginning regardless of the language, then it's mostly a matter of syntax. .NET has a wealth of libraries behind it, but navigating that world is on-par with Java in complexity (strong typing, lots of long paths to method calls, etc.). CF is more akin to PHP in that regard. Not to get too far off-topic, but I'd be happy to see a project like OpenBD or Railo that created a CFML engine on top of .NET rather than Java so that we could just switch the engine out and say okay, we're doing .NET now, wink wink. If you're doing simple web applications, .NET may just get in the way and add time and complexity that isn't needed. If you're doing PDF generation, I haven't seen anything that beats the simplicity of CFDOCUMENT (though it has its limitations). So, as with anything in IT... it depends. But as has already been mentioned, switching platforms just because someone read an article in a magazine about something another company did is pretty short-sighted. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: now( ) is off by an hour
Daniel, What version of ColdFusion are you running? Maybe you can upgrade the JVM to a newer version that has updated DST settings? I think the start/end dates for DST in the US were changed in 2007, while Java 1.4 hasn't been current since around 2004. -Carl V. On 3/12/2013 6:31 AM, daniel kessler wrote: I get: JRE:=Java(TM) 2 Runtime Environment, Standard Edition 1.4.2_09-b05 tz:=Eastern Daylight Time dst savings:=1 uses DST: YES in DST now: NO I saw that there is an update to 1.4.2_11, but that came out around 2007 I think. So I would need a more recent update. A coworker said that she updated her jvm and still sees the error. However, I'm waiting for her to come in to work and run this script that you gave me. Maybe it gives some different info. When it says in dst now, that means that JVM thinks it's not in DST or that the computer does not think it's in DST? script jre=createObject(java,java.lang.System); JREname=jre.getProperty(java.runtime.name); JREversion=jre.getProperty(java.runtime.version); tz=createObject(java,java.util.TimeZone).getDefault(); tzName=tz.getDisplayName(true,tz.LONG); dstSavings=tz.getDSTSavings()/360; writeoutput(JRE:=#JREname# #JREversion#br tz:=#tzName#brdst savings:=#dstSavings#br uses DST: #tz.useDaylightTime()#br in DST now: #tz.inDaylightTime(now())#); /cfscript ~| 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:354952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) .NET vs. CF
Justin, As a one-time Java BlueDragon user, I'd say the .NET version is the only reason I'd use BlueDragon over ACF at this point. They have fallen way behind in comparable feature support (last time I checked they were about equivalent to ACF 7/8). -Carl V. On 3/12/2013 3:49 PM, Justin Scott wrote: Thanks Carl, I knew they had a Java version but wasn't aware of the .NET edition. Good to know if I ever run across one of those types of clients. -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Creating indexes on cdata and cglobal tables?
Indexes can become fragmented over time, however. If you add the indexes and note degradation of performance after a while, then you may need to look at rebuilding indexes and statistics. If you are using SQL Server, there are tools built-in to set up automated maintenance plans which can include index rebuilding. -Carl V. On 3/5/2013 2:25 PM, Dave Watts wrote: No, the database will do that for you automatically. INSERTs, UPDATEs and DELETEs may take a bit longer with indexes as a result, but SELECTs will be faster if they filter by key columns. Dave Watts, CTO, Fig Leaf Software ~| 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:354844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installing CF 10 Updater 8
Rick, What OS are you on? If Windows 7 or Windows Server 2008, you might want to try downloading the hotfix (but not installing) using the Server Update tool, then installing the update using this Adobe Docs http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSe61e35da8d318518-33adffe0134c60cd31c-7ffe.html page. I just tried following it and all of my previous update angst was resolved. -Carl V. ~| 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:354764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installing CF 10 Updater 8
Rick, It might work pretty well under other OS's. But there are a number of people (myself included) that have had issues on Windows 7/Windows Server 2008. I think there are issues with Windows UAC and other permission controls. The only workaround aside from doing the command-line install is to put the ColdFusion service account into the local Administrators group whenever I install updates. -Carl V. On 3/1/2013 9:51 AM, Rick Root wrote: Alright that seems to work. Huh. I guess the server updates section was a nice idea ;) 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:354766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installing CF 10 Updater 8
Adam, I don't know if it's related to extra security in Windows 7 Pro vs. Home Premium, or the fact my development PCs and my server are joined to a Windows domain. But this issue has been reproducible on all of my computers since Updater 4. -Carl V. ~| 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:354773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery forms
The jQuery Validation plugin is pretty awesome: http://bassistance.de/jquery-plugins/jquery-plugin-validation/ Also, that plugin is built into the ValidateThis framework: http://www.validatethis.org/ HTH, -Carl V. On 2/14/2013 8:00 AM, John M Bliss wrote: Hi! Time-back-way-back, my favorite way to do client-side form validation was Adobe Spry. It was super-easy to do color-coded alerts on empty required fields, email format validation, etc. Nowadays, I know that can all be done with roll-your-own JQuery but I'm wondering if you have a favorite JQuery plugin / lib that'll handle it out of the box. 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:354512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 10 automatic updates not working
This is a common issue reported on the Adobe ColdFusion forums. The only solution I have found to work reliably for me (and I'm on the same OS and web server) is to make sure that the service account ColdFusion is running under is a member of the local Administrators group. You may also want to restart the ColdFusion service after putting the account in the Administrators group. -Carl V. ~| 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:354346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 10 automatic updates not working
Steven, I guess I should have added that once the updates are installed, remove the service account from Administrators. And this solution is only a workaround, mind you. I don't believe this **should** be necessary, but it has been for me. I've followed the lockdown guides, including granting the ColdFusion service account full permissions to the entire /ColdFusion10 folder structure. Updates since update 2 have not installed without installing with Administrator group rights. -Carl V. On 2/7/2013 7:53 AM, DURETTE, STEVEN J wrote: And yet I believe that would go against the lockdown guides... So our options are easy updates or secure systems? ~| 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:354348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 10 automatic updates not working
That's exactly what I was suggesting you do. After you set the ColdFusion service to run as your account, did you stop and restart the service? That is necessary for the Administrator permissions to be granted to the ColdFusion service. Then, after the updates are installed (assuming they do install successfully), switch the service back to the local system account and stop/restart it again. Since you are running as local service, is this your local development machine or your production server? Just curious. -Carl V. On 2/7/2013 2:40 PM, Jeff Carpenter wrote: I am not sure I follow. The ColdFusion 10 Application Server service is set to Log on with the local system account. I tried changing this to log on as my own login account, which is a member of the local administrators. I still was not able to logon. ~| 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:354371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion license
Pradeep, On the question of the license key: yes, you use the same license key on test and staging. I'm not aware of a way to limit the number of cores that ColdFusion has access to. If you virtualize your servers with VMWare vSphere, you can limit the number of cores each virtual machine can use, thereby limiting how many cores ColdFusion can use. I've not used the Windows HyperV, so I can't comment on whether it can be similarly configured. If you have Windows Server 2008 R2 Enterprise edition, you are entitled to run up to four virtual machines under one license (provided you have at most two physical processors in the server). HTH, -Carl V. On 2/1/2013 1:04 AM, Pradeep Viswanathan Rajasekaran wrote: I know that the EULA changes from ColdFusion 9 and above allows free staging and test instance, but does that mean we can actually install the original production license key on test and staging. Also on the context of licensing, is there a way to limit ColdFusion to use X number of cores for legal purposes on a Windows 2008 server? ~| 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:354219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion license
Pradeep, I agree that the EULA is a bit vague about using the same license key. I confirmed it though through comments and responses on the Adobe ColdFusion Blog (*http://blogs.coldfusion.com/post.cfm/coldfusion-10-eula)*. -Carl V. On 2/1/2013 8:11 AM, Pradeep Viswanathan Rajasekaran wrote: Thanks for the response Carl. I will look for the official adobe document which says that. When I was discussing this with my admin, he felt that that the EULA does not explicitly specify that the key can be installed. The license was procured for Coldfusion 10 however I am not sure if my admin is aware of the changes regarding the number of cores clause on the EULA, so thought of finding a solution for it too. On Feb 1, 2013 8:04 PM, Carl Von Stetten vonner.li...@vonner.net wrote: ~| 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:354222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: table (rows...)[...]not indexable by 1 -- error
I think you can remove all of the references to [getEmployeeList.currentrow] in your a tags. Since you are looping through the query with cfloop, any place you reference #getEmployeeList. you will get only the value of that field for the current row. HTH, Carl V. ~| 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:354163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JRun errors after security patch install
Terry, I assume you are referring to the latest patch released earlier this week. Since it was a cumulative patch, it included some previously released security improvements as well as the new ones. One of the older security improvements was to add a Post Parameter Limit setting to prevent denial of service (DOS) attacks using hash algorithm collisions. You can find details of the issue here http://www.adobe.com/support/security/bulletins/apsb12-06.html. The default value for this new setting is 100, but you can increase it if you need to. Instructions to do this can be found here http://helpx.adobe.com/coldfusion/kb/coldfusion-security-hotfix.html. HTH, -Carl V. On 1/16/2013 7:36 AM, Terry Ford wrote: Hello -- I installed the security patch last night on cf 9.1 linux, and woke up this morning to find that some of our templates no longer work: [Wed Jan 16 09:28:27 2013] [notice] jrApache[1978: 53193] returning error page for JRun too busy or out of memory They return a 500 error to the user. The commonality in the templates that are doing this is that they have lots of FORM variables. So, they're dealing with a lot of form input. They have worked perfectly for years, up til this patch. Has anyone else experienced this? We are running on linux/apache. Regards ~| 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:353937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: form-post to SQL-insert creates double-entry
If you add a name attribute to your submit button: input type=submit name=submit value=Enter New Donor then when the form is submitted, there will be a corresponding submit key added to the form scope. Then, as others have suggested, wrap your query in: cfif StructKeyExists(form, submit) //Your query here /cfif Again, as the others have stated, this will cause the query to only be executed if the form is actually submitted, rather than on every page load. HTH, -Carl V ~| 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:353940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Windows Mesh Alternatives
+1 for Dropbox. Dropbox for Teams looks interesting as well. -Carl V. On 12/14/2012 9:50 AM, Cameron Childress wrote: On Fri, Dec 14, 2012 at 12:36 PM, John M Bliss bliss.j...@gmail.com wrote: Hi! Currently, my geographically dispersed company uses Windows Mesh as a network drive for shared office files. Microsoft has announced that Mesh is going away to be replaced by SkyDrive. Before we migrate to SkyDrive, I thought I'd poll the list to see if any of you might have another (better?) alternative. We use DropBox for this purpose. I like that it's cross platform, seamless, and not a Microsoft owned product, but better will be something only you can decide. -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:353480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFERROR Handler
ColdFusion can only route runtime errors to an error handler (your soft error). Compile errors (such as invalid tag names) can't be interpreted by ColdFusion and cause a hard error. Not much you can do about that. -Carl V. On 12/6/2012 8:39 AM, Robert Harrison wrote: I have an exception error handler - type=exception error=any It mostly works... see http://www.austin-williams.com/_soft_error.cfm - this a bad var name; works as it should and sends me a dump. Now look here: http://www.austin-williams.com/_hard_error.cfm - this is bad cftag name; shows the error on screen. Any idea why the second error is not working with my error handler? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353379 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMAIL Not getting to mail server
If the mail log doesn't show the messages as being bounced and undeliverable (and the messaged don't end up in the cfmail\undelivr folder in your ColdFusion install directory), then the problem is likely with your downstream mail server, not with ColdFusion. Did you propagate the same SMTP server settings from your CF7 install to your CF9 install? -Carl V. On 11/27/2012 2:23 PM, Brian Cain wrote: Hello All, I recently migrated to CF 9 from 7, and there seems to be an issue with not all cfmail messages going out. I an not getting any errors, and the log files in CF actually show the messages in the mail sent log, but there is no trace of them after that on my mail server or the client end. This problem did not start happening until after I migrated to CF9, and there have been no changes in the code or environment beyond that. This does not happen to all messages, but it happens often enough that is a problem. Does anyone have any ideas of how to fix this issues. I found some threads about this issue and other people experiencing it, but no solutions or help from Adobe on a permanent fix. Thanks, Brian Cain ~| 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:353305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where is information used by the Scheduler?
Claude, Try neo-cron.xml (should be in the \lib folder under your ColdFusion installation). -Carl V. On 11/26/2012 11:03 AM, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote: Hi, When I open the Scheduler in the CF administrator (CF 9), I get the error: 11/26/2012 1:58:00 PM is an invalid date format. Fist I don't see why it is ivalid. But I'd like to see if I can modify it. I suppose all the information about scheduled tasks is stocked in some XML file, but where? ~| 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:353288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
I spoke too soon. The installer with tools provides limited replication support and SSMS, but not SSIS. -Carl V. On 11/15/2012 4:30 PM, Carl Von Stetten wrote: Starting with SQL Server Express 2008 R2 (and maybe some prior versions), you can download an installer that includes the SSMS tools, which I think includes SSIS as well. -Carl V. On 11/15/2012 1:32 PM, Mike Kear wrote: the things cut out of the express version are the kinds of things we use coldfusion for anyway. I havent found any issues at all in connecting SQLexpress versions and Coldfusion. The only issues I've had are to do with things like the lack of SSIS which makes things like moving data to online more difficult that's all. 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 Fri, Nov 16, 2012 at 6:32 AM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: Works just like the full version, and it's what I use on my VPS. On Thu, Nov 15, 2012 at 5:23 AM, Kevin Parker tras...@internode.on.net wrote: Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| 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:353207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Express and CF
Starting with SQL Server Express 2008 R2 (and maybe some prior versions), you can download an installer that includes the SSMS tools, which I think includes SSIS as well. -Carl V. On 11/15/2012 1:32 PM, Mike Kear wrote: the things cut out of the express version are the kinds of things we use coldfusion for anyway. I havent found any issues at all in connecting SQLexpress versions and Coldfusion. The only issues I've had are to do with things like the lack of SSIS which makes things like moving data to online more difficult that's all. 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 Fri, Nov 16, 2012 at 6:32 AM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: Works just like the full version, and it's what I use on my VPS. On Thu, Nov 15, 2012 at 5:23 AM, Kevin Parker tras...@internode.on.net wrote: Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| 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:353206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Case statement inside cached query
I don't think the CASE function is supported in Query-of-Query statements. -Carl V. On 11/8/2012 8:07 AM, Nathan Chen wrote: Matt, sorry I wasn't clear. I got a query of queries syntax error like this: Query Of Queries syntax error. Encountered sum ( case. Incorrect Select List, Nathan -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Wednesday, November 07, 2012 4:27 PM To: cf-talk Subject: Re: Case statement inside cached query What does wouldn't work mean? Get results you didn't expect? If yes, what did you get and what did you expect? Get an exception? If yes, where's the stack trace? On Wed, Nov 7, 2012 at 5:22 PM, Nathan Chen nathan.c...@cu.edu wrote: All: Do cached queries allow SQL case statement at all or is there a way to get around it? I am trying to put this inside a cached query such as : Sum( case when A = 'B' then C else 0 end) as D ( C is numeric field). It wouldn't work. I am on CF 8 and Oracle 11g. Thanks. Nathan Chen ~| 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:353091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdirectory
This should work, so you need to address the rights issue. What Windows user account is the ColdFusion service running under? If you have it running as a specific Active Directory account, you need to modify the fileserver folder to grant Read access to that account. -Carl V. On 10/29/2012 2:00 PM, Stephens, Larry V wrote: Running CF10 on IIS7.5 on Windows server 2008R2 on Server Z Filerserver (O) running on 2008R2 I want to do a cfdirectory to the fileserver to list the contents of a directory. Directory=\\UNC\path... name=MyDir (where \\UNC\path... relates to the fileserver) yields nothing when I dump MyDir. We found a note at http://www.asadesigner.com/16-coldfusion/c1788fe8b3536edc.htm tells us this is a rights issue. (I'm wanting to list the contents of a specific sub-directory, the name of which I can determine programmatically - and would be photos - so I can display a list of those images and allow my user to click a constructed link and see the image.) Other than cfdirectory, is there a good way to display a directory listing that comes back as query results that I can loop and display on a page? Incorporate something in C? In vbScript? ~| 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:353018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF10 Solr Searches using Addresses
I have a ColdFusion 10-based GIS application with a search form. One of the searches that can be performed is an address search. Address data is stored in an enterprise database that I can't alter, so I have to work with it the way it is. Addresses are broken apart into six separate database columns, not counting the city, state or zip code. Not every address uses every one of the six columns, but some use as many as five of them. Anyway, the search form currently is rather cumbersome as users have to enter pieces of the address into different form fields. It works, but as I said, it's cumbersome. I decided to try to see if I could use Solr to do more intelligent address searches from one form field, ala Google or Yahoo maps. I created a collection on my dev server. I wrote a query that assembled the six pieces into a single address column, then used cfindex to put the query results into the index (I put the address column into the body attribute of cfindex). Last, I wrote a simple one field form to perform the search. This seems to work, but it pulls back a horrifically large amount of results of dubious match quality. For example, a search using 1234 Main St (fictitious example address to protect the innocent) returned 34,040 rows out of 123,000 address records. The reason? It's finding matches to any single piece of the search string. From the ColdFusion docs, it looks like I might be able to tighten up the search results by prefixing each piece of the search criteria with a + character. However, that will force exact matches (except when the street name is also the city name, such as Oakland Blvd in the city of Oakland), and I'd like to keep a little bit of fuzzy search capability for typos and such (like Google does). Has anyone played around with parsing addresses and assembling an optimized Solr search? I'm hoping to save some time on experimentation. Thanks, Carl V. ~| 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:353005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: calling coldfusion page from SSIS package
It would probably be easier to have your CF scheduled job either 1) log an entry in a database table with a success code and timestamp, or 2) write an entry to a text file that SSIS can read. Then update your SSIS package to check the table or text file for the success code before proceeding. HTH, -Carl ~| 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:352653 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Mailing list for Responsive and Adaptive Web Design
Rick, I think you'll find that most of the HoF lists you mentioned (aside from CF-Talk) have very limited participation recently - suggesting that people are generally going to other lists or forums for support and discussion on those topics, because the communities are larger and more likely to have members with adequate experience to answer questions. Many of the HoF lists were created before established communities or forums were available elsewhere. If you look a some of these HoF lists, you'll see what I mean: *List** * *Posts in 2012** * *Last Post** * Ajax 3 8/23/12 CSS 0 12/23/10 JavaScript 0 9/15/11 XML 0 5/12/10 SQL 4 5/9/12 RegEx 2 4/5/12 Java 4 (all job postings) 3/22/12 .Net 6 (all job postings) 6/11/12 SEO 0 11/20/08 To be honest, my primary reason for joining HoF was for CF-Talk, which I try to stay active with. I subscribe to the ColdFusion-Builder list for occasional support (although I'm starting to use the Adobe forum more and more), and to the SQL list mainly to offer assistance when I can. If I have a SQL issue, I hit the Google or a couple of SQL Server specific groups (SSWUG, MSSQLTips, SQLServer Central). -Carl On 9/16/2012 11:26 AM, Rick Faircloth wrote: If the topics for mailing were to be restricted to CF only, which I could understand, then there would be no mailing lists, as there already are, for SEO, RegEx, CSS, SQL, AJaX, XML, Java, Jrun, .Net (especially), and Javascript on HouseOfFusion.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:352642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) How compatible is SQLServer 2012 with SQL Server 2005 databases?
Mike, I think that each database has a setting for compatibility level (go to the Properties dialog for the database, then the Options tab, it's at the very top). As long as you leave this at SQL Server 2005 (90), you should be able to run the same database on 2012. I don't have SQL Server 2012 yet, but I do have 2008 R2. Here is an excerpt from the help docs for 2008 R2, under Alter Database Compatibility Level: For all installations of SQL Server 2008, the default compatibility level is 100. Databases created in SQL Server 2008 are set to this level unless the *model* database has a lower compatibility level. When a database is upgraded to SQL Server 2008 from any earlier version of SQL Server, the database retains its existing compatibility level if it is at least 80. Upgrading a database with a compatibility level below 80 sets the database to compatibility level 80. This applies to both system and user databases. Use ALTER DATABASE to change the compatibility level of the database. To view the current compatibility level of a database, query the *compatibility_level* column in the *sys.databases* catalog view. Using Compatibility Level for Backward Compatibility Compatibility level affects behaviors only for the specified database, not for the entire server. Compatibility level provides only partial backward compatibility with earlier versions of SQL Server. Use compatibility level as an interim migration aid to work around version differences in the behaviors that are controlled by the relevant compatibility-level setting. If existing SQL Server applications are affected by behavioral differences in SQL Server 2008, convert the application to work properly. Then use ALTER DATABASE to change the compatibility level to 100. The new compatibility setting for a database takes effect when the database is next made current (whether as the default database on login or on being specified in a USE statement). This is followed by a long table that explicitly states the differences in compatibility from previous versions. I'm assuming the docs for SQL Server 2012 would have something similar. HTH, Carl ~| 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:352616 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF10 on Win7
Russ, My experience with Windows 7/Windows Server 2008 R2 and ColdFusion 9 Standard Edition has been that when a new site is added in IIS, **none** of the ColdFusion connectivity works without some intervention (and I'm not just talking about the CFIDE vdir). The only thing that has consistently made IIS and CF play nice has been to re-run WSCONFIG. Typically I will run WSCONFIG and remove the All Sites connection, restart IIS, then re-run WSCONFIG to re-add All Sites. I have occasionally just added the individual new sites as well. The point is, for me, that running WSCONFIG has been absolutely necessary to get new IIS web sites wired up properly. Your experience may be different. -Carl ~| 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:352434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF10 on Win7
Chad, Every IIS host that serves ColdFusion content needs the jakarta virtual directory. It sounds like you didn't rerun the web connector tool after you created your foo site. Run the web connector tool and connect ColdFusion to your foo site. This will add the jakarta virtual directory, and configure the IIS request handler. The reason http://foo/ worked is that IIS is falling back to the global CF wildcard handler to route the request through CF. HTH, -Carl On 9/5/2012 1:33 PM, Chad Gray wrote: This is kind of interesting. If I type a real missing html file like http://foo/missingFile.html I get this in the 404 response: Requested URL http://foo:80/missingFile.html Physical Path E:\webSite1\missingFile.html If I type the same URL only with CFM http://foo/missingFile.cfm I get this: Requested URL http://foo:80/jakarta/isapi_redirect.dll Physical Path E:\webSite1\jakarta\isapi_redirect.dll Isapi_redirect.dll? what does that have to do with the Requested URL? Hmm now I wonder if I need that Jakarta folder! I bet that is what is missing! Chad -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Wednesday, September 05, 2012 3:49 PM To: cf-talk Subject: RE: CF10 on Win7 Nope... nothing fancy here. Just a index.cfm with Hello World no application.cfm or application.cfc. -Original Message- From: Brian Thornton [mailto:br...@cfdeveloper.com] Sent: Wednesday, September 05, 2012 3:42 PM To: cf-talk Subject: Re: CF10 on Win7 Do you have a url rewriter installed by chance? On Sep 5, 2012 3:40 PM, Chad Gray cg...@careyweb.com wrote: OK I got CF10 64bit running in IIS on Windows 7 on the default website. CF admin is working great etc. I created a new website in IIS and it runs the index.cfm file just fine if I don't type it into the URL. http://foo/ If I type index.cfm into the URL I get a 404. http://foo/index.cfm I am using a host name of foo in IIS and I have an entry in the C:\Windows\System32\drivers\etc\hosts file to point it to 127.0.0.1. 127.0.0.1 foo This has always worked in the past. It works fine on the default website in IIS http://localhost/index.cfm Anyone have any ideas why I get a 404 when I type the file name in the URL? Thanks, Chad ~| 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:352417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF10 on Win7
Chad, Yes, new websites added to IIS after running the connector tool do not automatically receive all of the necessary hooks to properly handle ColdFusion files. You have two options when re-running the connector tool: 1. Remove the all web sites connection and then re-add it. This may require multiple restarts of the connector tool and IIS. 2. Simply add the new sites individually in the connector tool. While the underpinnings of ColdFusion 10 are different from previous versions (Tomcat instead of JRun and different IIS connectors), I think this process of connecting IIS web sites is pretty similar. I seem to recall having the same issues when I added ColdFusion 9 web sites to IIS, especially on IIS7 (Windows 7) or IIS7.5 (Windows Server 2008 R2). -Carl ~| 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:352421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF10 on Win7
Russ, True, as I said, the underpinnings between CF9 and CF10 are different. But the issue of having to re-run the connector tool to add ColdFusion functionality to new IIS web sites is common to both (even if what the connector tool is doing under the covers is different between the versions). This has been my experience over the past few years working on Windows 7 and Windows Server 2008R2. -Carl ~| 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:352423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 Scheduled Task
Dave, On my previous Win2K3 server, the only way I was able to get scheduled tasks to run properly was to allow anonymous access to the subfolder in the application which stored the scripts for scheduled tasks. This worked fine for several years on the old server. I was trying to do the same thing on the new Win2K8R2 server (IIS 7.5). The application requires NTLM authentication, but I haven't been able to get the scheduled tasks to run. Even when I hit the scheduled task pages directly in a browser (Firefox and Chrome), I am prompted to login with Active Directory credentials. I also tried turning the subfolder in question into a virtual application in IIS 7.5 but that didn't seem to make any difference. Anyway, as you indicate, it appears that under IIS 7.5 you can't open a security hole (my quotes) by allowing anonymous access to a subfolder in a site requiring authentication. So my workaround is to create a new site just for running scheduled tasks, and have that entire site allow anonymous authentication (thanks also to Russ who kinda suggested this). I am now able to get these scheduled tasks to run properly. Thank you Dave and Russ for your suggestions! -Carl On 8/10/2012 4:19 PM, Dave Watts wrote: OK. I created a local Windows user account named SchedTasks. I gave that account read permissions to the folder. I set Anonymous Authentication to Enabled just for that folder, and set the credentials to use the SchedTasks account. In the CF Scheduled Task, I specified SchedTask for the username, and filled in the correct password. I still get the 401.2 error when running the scheduled task. If you're creating a user account for CF to use, why would you enable anonymous authentication? That's not going to help you any. First, I'd recommend that you don't even bother testing from CF yet. Test from Firefox or some other non-IE HTTP client (wget, etc). Second, I don't think you can set anonymous authentication for a folder, as such - it has to be a virtual server or a virtual application. I could be wrong about that, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
Another +1 for Notepad++. -Carl ~| 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:352127 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problem with Authentication on IIS 7.5 Scheduled Task
I have ColdFusion 10 running on Windows Server 2008R2, using IIS7.5 as web server. I have an intranet application configured to use Windows Authentication with NTLM, which works very well. However, I have an issue with executing scheduled tasks. The files are part of this same application, but are located in a nested subdirectory under the webroot. On this subdirectory, I have turned off Windows Authentication and turned on Anonymous Authentication (using the built-in IUSR account). When I try to run any .cfm files in this subdirectory via a scheduled task, I get a 401.2 - Unauthorized error. However, if I run the files from a web browser, even when logged in as a non-domain user, the .cfm files run without issue. I've checked the permissions on the subdirectory in question, and all of the relevant accounts (the Active Directory account CF runs under, the local account created for the application pool, and the built-in IUSR account) have permissions to read from that subdirectory. I can't for the life of me figure out what I'm doing wrong. Anyone have any ideas? Thanks -Carl ~| 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:352095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 Scheduled Task
Digging a little more into IIS (by the way, I Googled IIS 7.5 stuff for a while before my initial post) - I checked the Authorization Rules for the subdirectory in question. I changed the Allow rule to include All anonymous users instead of All users. Didn't help. -Carl ~| 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:352096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 Scheduled Task
Russ, Cached login might be right. I just tried the URL in Firefox, and was prompted to login. I think the security of the site is superseding the security I am trying to set on the subdirectory. Maybe I'll create a special site on this server just for scheduled tasks, with anonymous authentication enabled. I'll post back with the results. And yes, CF is running under a custom Active Directory account that has been granted rights to the entire directory structure, so it should be able to access the file in question. Thanks, Carl Try different browser and see if it still works, you may be using cached login which is why it seems to work in browser. Do you have cf running under a custom user? Regards Russ Michaels On Aug 10, 2012 9:39 PM, Carl Von Stetten vonner.li...@vonner.net wrote: ~| 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:352099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 Scheduled Task
Dave, How would you create the USERNAME with PASSWORD? I'm not sure I follow (I looked in IIS under Basic Authentication, and the only thing you can set there is Default Domain and Realm). -Carl And yes, CF is running under a custom Active Directory account that has been granted rights to the entire directory structure, so it should be able to access the file in question. That won't help with CFHTTP requests. CF doesn't use service account credentials for HTTP authentication, and it doesn't support NTLM or Kerberos authentication (Windows Integrated Authentication in IIS). You can use Basic Authentication with the USERNAME and PASSWORD attributes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 Scheduled Task
Since this is a new server setup, I don't have another site to compare to. I do have this working on an older Windows Server 2003/IIS 6, but things have changed a lot in IIS 7.5. I've checked all the settings in the web server config files (and they look correct), restarted IIS several times, and even rebooted the server, all to no avail. -Carl Looks like you haven't got that subdir set to anon access properly. Chech the authentication settings on another site for comparison to see what it should be. It needs to run under the iis_iusr account. Or you could just put login details in the scheduled task. Regards Russ Michaels ~| 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:352107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 Scheduled Task
Nope. One of the early steps in the ColdFusion lockdown guide has you remove the Default web site for security. -Carl Surely you have the default website still? Regards Russ Michaels ~| 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:352109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 Scheduled Task
OK. I created a local Windows user account named SchedTasks. I gave that account read permissions to the folder. I set Anonymous Authentication to Enabled just for that folder, and set the credentials to use the SchedTasks account. In the CF Scheduled Task, I specified SchedTask for the username, and filled in the correct password. I still get the 401.2 error when running the scheduled task. -Carl How would you create the USERNAME with PASSWORD? I'm not sure I follow (I looked in IIS under Basic Authentication, and the only thing you can set there is Default Domain and Realm). In Windows, you need to create whatever accounts you want to use for authentication. In IIS, you need to configure the virtual server or virtual application to use Basic Authentication. In CF, you need to explicitly provide the account's username and password with the USERNAME and PASSWORD attributes of CFHTTP. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 10 Administrator Javascript Errors
I just installed the 64-bit version of ColdFusion 10 on Windows Server 2008R2. I tried to do the install as close to the CF9 Server Lockdown Guide as possible, given that CF9 and CF10 have different underlying engines (CF9 is JRun and CF10 is Tomcat, in the Administrator CF9 used Java applets for file browsing and CF10 uses jQuery and JavaScript UI components). Anyway, things seem to be working fine for the most part, except that some of the ColdFusion Administrator functionality is broken for me. Any place that requires using the new jQuery file browser throws script errors. For example, when trying to specify an alternative JVM path, clicking Browse Server results in the error jQuery is undefined (see http://screencast.com/t/GQMZ1cdLJy ). Of course, jQuery.js is in the same folder as the offending script (jqueryeasing.js), so this makes no sense. Anyone encountered this before? -Carl ~| 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:352077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 Administrator Javascript Errors
Russ, Thank you for the suggestions. I just figured it out. On my IIS site, I hadn't removed the Deny URL request filtering on the /scripts folder (the Deny URL filtering per the lockdown guide). Once I removed it, all is well. Thanks, -Carl ~| 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:352080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ON-THE-FLY FILTERS
Larry, Might I suggest a little bit different approach? Instead of storing the whole WHERE clause in a session variable, store only the string you need to use for filtering. In your session definition code (likely onSessionStart() in Application.cfc): cfset session.F = Then modify your query: SELECT tblY.fldX FROM tblY WHERE 1=1 cfif len(trim(session.F)) AND tbly.fldA = cfqueryparam value=#session.F# cfsqltype=CF_SQL_VARCHAR /cfif This protects your SQL database from SQL injection (as Matt Q. alluded to). If you haven't changed session.F from the initial blank string, the query will return all records. If you update session.F to contain an actual value, then that string will be used to filter the records. HTH, Carl On 6/28/2012 8:29 AM, Stephens, Larry V wrote: CF8 SELECT tblY.fldX FROM tblY WHERE tblY.fldA='something'; That works okay. But I want to set the WHERE clause on-the-fly. So the user selects the filter (via a form) and the result is stored as cfset SESSION.F = WHERE tblY.fldA=' FORM.Result ' (where FORM.Result = something) Do a cfoutput to check SESSION.F and that shows WHERE tblY.fldA='something' All is well. So, my code is SELECT tblY.fldX FROM tblY #SESSION.F#; The problem is, it now displays as SELECT tblY.fldX FROM tblY WHERE tblY.fldA=something; And that throws an error. Why does SESSION.F display correctly in the cfoutput but CF8 changes the ' to when I use it in cfquery ? ~| 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:351757 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Maximum Post Variables
Paul, Take a look at the 9.0.2 release notes: http://helpx.adobe.com/coldfusion/release-note/coldfusion-9-0-update-2.html The Maximum size of post data is for the size (in MB) of posting data and/or files in a post request, not the number of parameters allowed in a post request. You'll need to edit the neo-runtime.xml file per the release notes to increase the number of parameters allowed. HTH, Carl On 6/29/2012 1:55 PM, Paul Alkema wrote: Hi All, I'm running into an issue, where when I create over 100 different form elements with different content I get a 500 error. I'd like to increase this number up from 100 however I can't find an area to do this. My original thought was that it was in the ColdFusion Administrator -- settings -- Maximum size of post data however, when I upped this, it had no effect on the number of post variables. I think this setting seems to be the post variable size, as like for file uploads ect... I'm running on ColdFusion 9.0.2 and when I run the code below and hit submit I receive an error. Anyone have any ideas? form action= method=post cfoutput cfloop from=1 to=100 index=i input name=txtBox#i# type=hidden value=txtValue#i# / /cfloop /cfoutput input type=submit name=txtButton / /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:351763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Distributed Cache in Coldfusion 9 with Terracotta
Rick, Try this: http://li-ma.blogspot.com/2010/04/run-terracotta-server-as-windows.html HTH, -Carl ~| 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:351355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Variables
Also, be careful using var as a variable name. It is a reserved keyword in ColdFusion. As Scott mentioned, you can make a variable local to a function by calling it local.varname. You can also make it local to a function by using the var keyword when you create the variable: cfset var foo = bar HTH, Carl ~| 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:351206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 no longer recognizes virtual directories on IIS after install of Apache
Dave, Have you checked the permissions on the folder the Virtual Directory points to? Is directory security in IIS on the Virtual Directory set to Enable anonymous access with an account that has Windows permissions on that remote folder, or does each user that connects to your site use NT permissions that grant them access to that remote folder? -Carl Dave, Thanks for your thoughts. I am pretty sure that the IIS virtual directories must be the problem. I can go into IIS and browse to the virtual directories and see all of the files in them but IIS does not seem to want to serve them up. I can access the other server directly by setting the file name through the other server name and everything works fine. cfset filename = \\bpsbs/pdfarchive/ #(Int(URL.fn/1)*10)# kPDFs\ #URL.fn# .pdf The problem with changing everything over to this method is that on some pages I also use the embed tag to directly embed the PDF in the page so it shows along with some other text and form buttons, etc. When I use the embed tag with the file name built using a direct reference to the server it does not display. Any thoughts would be greatly appreciated. I am afraid my next option is going to be to re-install the server from a backup from last week. The data is on another drive so I won't lose anything except a lot of down time and hours spent doing it. Thanks Curt ~| 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:350942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 no longer recognizes virtual directories on IIS after install of Apache
Whoops. That was supposed to be directed to Curt, not Dave. My bad. -Carl Dave, Have you checked the permissions on the folder the Virtual Directory points to? Is directory security in IIS on the Virtual Directory set to Enable anonymous access with an account that has Windows permissions on that remote folder, or does each user that connects to your site use NT permissions that grant them access to that remote folder? -Carl Dave, Thanks for your thoughts. I am pretty sure that the IIS virtual directories must be the problem. I can go into IIS and browse to the virtual directories and see all of the files in them but IIS does not seem to want to serve them up. I can access the other server directly by setting the file name through the other server name and everything works fine. cfset filename = \\bpsbs/pdfarchive/ #(Int(URL.fn/1)*10)# kPDFs\ #URL.fn# .pdf The problem with changing everything over to this method is that on some pages I also use the embed tag to directly embed the PDF in the page so it shows along with some other text and form buttons, etc. When I use the embed tag with the file name built using a direct reference to the server it does not display. Any thoughts would be greatly appreciated. I am afraid my next option is going to be to re-install the server from a backup from last week. The data is on another drive so I won't lose anything except a lot of down time and hours spent doing it. Thanks Curt ~| 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:350943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrate back and forth between cf7 and cf8 on IIS
He's on Windows XP and is thus limited to one site in IIS. Man I love multiple IIS sites in Windows 7! -Carl On 3/9/2012 10:04 AM, Russ Michaels wrote: why not just setup separate sites and set each site to use the appropriate cf version instead of keep switching one site between different home directories and cf version ? On Fri, Mar 9, 2012 at 5:23 PM, Andrew Scottandr...@andyscott.id.auwrote: Just a heads up that I wrote a blog about something like this the other day, although it is geared for ColdFusion 8 and ColdFusion 9. There should be no reason why you can't apply this same method to ColdFusion 7 and ColdFusion 8. http://www.andyscott.id.au/2012/3/6/Developing-Apps-to-work-with-ColdFusion-8-and-ColdFusion-9-with-multi-instance-ColdFusion-install -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Sat, Mar 10, 2012 at 4:20 AM, daniel kesslerdani...@umd.edu wrote: Just set the ISAPI paths at the website level for the CF7 site to point to your CF7 install directory (specifically at the jrun dll's).. ok, that worked. Thank you very much. Is that the sort of thing that can be adjusted using a .bat file? I don't know much about them. However, I'm trying to make switching between these two environments as easy as possible. I appreciate the assistance everyone. daniel ~| 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:350331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help with REFind and Insert()
The docs for REFind() say that the third argument should be a positive integer, default value is 1. REFind() returns the position in the string where the matched string begins. You'll need to add the length of the matched string (in your case, Len(url.terms) ) to this value to get the end of the matched string. Try this: cfset DocContents = Insert(#i#, DocContents, REFind(#url.terms#, DocContents, 1)+Len(url.terms))/ HTH, -Carl ~| 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:350092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
Yeah, or how about the red seal on the cover that says High Quality Content by WIKIPEDIA articles!? LOL :-D On 2/21/2012 11:04 AM, Steve 'Cutter' Blades wrote: You mean I should write a book on CFScript? Fantastic? Betascript Publishing hhhm... Anyone notice the tagline states: ColdFusion Markup Language, JavaScript, BlogCFC Now THAT is interesting... 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 2/20/2012 10:48 AM, Robert Rhodes wrote: Hello to all. Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. All suggestions welcome. -RR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
The only thing I might add is that if you are on CF9, you might consider using the new in-memory virtual file system (VFS) to write your new spreadsheet and read it back in (might improve the performance if the spreadsheet is large). -Carl On 2/8/2012 8:34 AM, Hong Chen wrote: I used SpreadSheetRead to read the spreadsheet into memory and used SpreadsheetFormatColumns to format the dob column, then used cfspreadsheet to write a new spreadsheet, last step, I read the new spreadsheet into a query to insert to DB. It was successful, but hope there is a simple way to do it. 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:349852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Rex, I think cf_abort is a custom tag, not a UDF, so it would not be called using cf_abort(). -Carl On 2/9/2012 9:19 AM, Rex wrote: yes, but to call cf_abort, you want to do cf_abort() It's like calling #now# instead of #now()# - Rex On 2/9/2012 5:46 AM, daniel kessler wrote: you have cf_abort in your code instead of cf_abort() I am using cf_abort. ~| 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:349853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Oops. I missed that. Nevermind! :-[ On 2/9/2012 10:10 AM, Matt Quackenbush wrote: Nopers. Daniel has ancffunction name=cf_abort in his CFC. See his previous posts in the thread. On Thu, Feb 9, 2012 at 12:04 PM, Carl Von Stetten vonner.li...@vonner.netwrote: Rex, I think cf_abort is a custom tag, not a UDF, so it would not be called using cf_abort(). -Carl On 2/9/2012 9:19 AM, Rex wrote: yes, but to call cf_abort, you want to do cf_abort() It's like calling #now# instead of #now()# - Rex On 2/9/2012 5:46 AM, daniel kessler wrote: you have cf_abort in your code instead of cf_abort() I am using cf_abort. ~| 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:349855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM global event handler
Maybe an issue with the case of your function calls to setCreated. For example, you check if the arguments.entity has a setCreated method, but you try to call using setcreated (notice the c in created is not capitalized). HTH, Carl On 12/29/2011 9:02 AM, Tom Small wrote: Hi Matt Thanks for your reply. I am following a book by John Whish ColdFusion ORM and have pasted his exmaple; component implements=cfide.orm.IEventHandler { public void function preLoad( any entity ) { logEvent( preload, arguments.entity ); } public void function postLoad( any entity ) { logEvent( postload, arguments.entity ); } public void function preInsert( any entity ) { logEvent( preinsert, arguments.entity ); var timestamp = now(); if ( StructKeyExists( arguments.entity, setCreated ) ) { arguments.entity.setcreated( timestamp ); } if ( StructKeyExists( arguments.entity, setUpdated ) ) { arguments.entity.setupdated( timestamp ); } } public void function postInsert( any entity ) { logEvent( postinsert, arguments.entity ); } public void function preUpdate( any entity, Struct oldData ) { if ( StructKeyExists( arguments.entity, setUpdated ) ) { arguments.entity.setupdated( Now() ); } logEvent( preupdate, arguments.entity ); } public void function postUpdate( any entity ) { logEvent( postupdate, arguments.entity ); } public void function preDelete( any entity ) { logEvent( predelete, arguments.entity ); } public void function postDelete( any entity ) { logEvent( postdelete, arguments.entity ); } private void function logEvent( required string event, required CFC ) { var message = Entity: #getMetaData( cfc ).fullname#, Event: #event#; WriteLog( type=event, file=ormevent.log, text=message ); } } ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: DirectoryExists sometimes returning incorrect value
Since DirectoryExists returns a true/false, you don't need the IS No part of the statement. Also, DirectoryExists expects you to pass it a variable, so you don't need the quotes and pound signs around variables.dirpath: cfif NOT DirectoryExists(variables.dirpath) cfdirectory action=CREATE directory=#variables.dirpath# /cfif HTH, Carl On 12/6/2011 1:56 PM, Shannon Rhodes wrote: This appears to happen randomly, making it difficult to replicate. Code will error that looks like this: cfif DirectoryExists(#variables.dirpath#) IS Nocfdirectory action=CREATE directory=#variables.dirpath#/cfif The error looks like this: The specified directory attribute value \\blah\AppDev\ParisDocs\blah\docs\ could not be created The most likely cause of this error is that (above) already exists on your file system. The exception occurred during a cfdirectory action = 'CREATE'. The directory definitely exists and most of the time the code works. What can I look at to discover why DirectoryExists would return No when it should be yes? Thanks in advance! ~| 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:348988 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: DirectoryExists sometimes returning incorrect value
It may be more than a style preference. I'm not sure that No as a string value is always equivalent to a true/false boolean value. My suggestion was intended to help identify if that might actually be your issue. I've experienced intermittent issues with FileExists and trying to delete files in similar logic as yours. Carl On 12/7/2011 9:14 AM, Shannon Rhodes wrote: I understand and agree with your style preferences, but neither complaint with legacy code would cause issues. Since DirectoryExists returns a true/false, you don't need the IS No part of the statement. Also, DirectoryExists expects you to pass it a variable, so you don't need the quotes and pound signs around variables.dirpath: cfif NOT DirectoryExists(variables.dirpath) cfdirectory action=CREATE directory=#variables.dirpath# /cfif HTH, Carl On 12/6/2011 1:56 PM, Shann ~| 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:348997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging doesn't display on local sevrver
That looks like a IPv6 address, rather than the #.#.#.# IPv4 addresses. On 12/7/2011 12:03 PM, Greg Morphis wrote: Hey Russ, thanks for the tip, removing the IP addresses worked.. apparently my IP address is ::1 Thanks! On Wed, Dec 7, 2011 at 1:01 PM, Russ Michaelsr...@michaels.me.uk wrote: cf only cares about the IP address, by default it allows localhost in the IP restrictions. Try removing all the IP restrictions and see if that helps. Also are u sure you don;t have another cfsetting further down your code disabling the debugging again ? On Wed, Dec 7, 2011 at 6:53 PM, Greg Morphisgmorp...@gmail.com wrote: I have CF 9 developer version running on IIS 7, my server is http://localhost:81 I look in the cfadmin and the debugging options are selected, I check Application.cfc and I've got cfsetting requesttimeout=200 showdebugoutput=true enablecfoutputonly=false / And yet, there's no debugging at the bottom showing queries ran, structures, etc. Is it because I have it running in IIS or a different port? Is there a setting I turn on to allow me to see the debugging info? 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:349010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging doesn't display on local sevrver
Yup. That's the IPv6 equivalent of 127.0.0.1 -Carl On 12/7/2011 1:43 PM, Greg Morphis wrote: REMOTE_ADDR=::1REMOTE_HOST=::1 right On Wed, Dec 7, 2011 at 3:36 PM, Carl Von Stetten vonner.li...@vonner.net wrote: That looks like a IPv6 address, rather than the #.#.#.# IPv4 addresses. On 12/7/2011 12:03 PM, Greg Morphis wrote: Hey Russ, thanks for the tip, removing the IP addresses worked.. apparently my IP address is ::1 Thanks! On Wed, Dec 7, 2011 at 1:01 PM, Russ Michaelsr...@michaels.me.ukwrote: cf only cares about the IP address, by default it allows localhost in the IP restrictions. Try removing all the IP restrictions and see if that helps. Also are u sure you don;t have another cfsetting further down your code disabling the debugging again ? On Wed, Dec 7, 2011 at 6:53 PM, Greg Morphisgmorp...@gmail.comwrote: I have CF 9 developer version running on IIS 7, my server is http://localhost:81 I look in the cfadmin and the debugging options are selected, I check Application.cfc and I've got cfsetting requesttimeout=200 showdebugoutput=true enablecfoutputonly=false / And yet, there's no debugging at the bottom showing queries ran, structures, etc. Is it because I have it running in IIS or a different port? Is there a setting I turn on to allow me to see the debugging info? 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:349013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm