I build the following into a scheduled task recently to cleanup my CF temporary files. I put files here when they’re uploaded, being processed, or temporary attachments that are being mailed out. Because of my mail spooler settings, I’d rather not CFFILE DELETE them immediately, but rather a day or so later.
I see questions posted in various places regarding ColdFusion applications trying to access remote network shares. The most common problem in doing this is getting denied access — and the most common troubleshooting step is logging into the server and accessing the share. They can often access the share just fine. Unfortunately, this thought process is flawed. The reason is because ColdFusion is not running as any user who is logged in, it is running using a service account (such as one you’ve created, or LocalSystem). This account probably doesn’t have access to the remote share.
As part of a recent a ColdFusion project, I needed to query an Oracle database and accept anywhere from 0 to 30k-40k records, then export into a CSV. It didn’t seem like too difficult of a problem at first. I used Toad to build the perfect query. Once optimized to pull down the max amount of records in the least amount of time, I copied to ColdFusion, built my front end, tested, and released. How’d I do it? Seemed simple — I setup a variable with a CSV header row, and then appended the variable record by record with the new data, and at the end CFFILE’d it all into a temp file which I then presented to the user.
I just had someone forward me along this great blog post that explains how to get your copy of Firefox to pass along your Microsoft Windows authentication data to a website. If you’re running ColdFusion on an Intranet using Integrated Windows Authentication, you can use this hack to stop being prompted for your username and password every time you connect.
I don’t know much about the world of Domino, but I’ve done my share of integration with Lotus Notes in the last couple of years. Usually, it’s by 3rd party apps and poor hacks. They really don’t make it easy sometimes. Recently, I wanted to link an Intranet application to a Lotus Notes Yellow Pages type database. The goal was to be able to select a person from my application, hit a link, and popup a copy of that persons entry in the yellow pages. The database was already setup by the Domino folks to be web accessable, however I wanted to go right to a specific record.
Adobe had posted a Technote a while back about getting error 401 when trying to use RDS. See: here. I was happy to find this article so quickly, and it turns out I did infact have Windows Authentication turned on for CFIDE. However, after fixing my CFIDE directory, I still was getting a 401 when trying to use RDS (by way of Report Builder). The fix for me was to also turn off Integrated Windows Authentication on the JRUNSCRIPTS folder. I sent a note over to Adobe to get the Technote updated, but in the mean time I hope this post helps someone out.
In the last few weeks I’ve starting toying around with Subversion as a version control system for my ColdFusion work. It’s my first jump into this, or anything like this (i.e. VSS, or CVS). With the help of Joe and his article Setting Up Subversion In An Instant, it was easy as pie. That article, along with all the supporting documentation, should get you started. I should start off by admitting that I have Subversion running on a Windows box.
A common question I’ve seen around is how to get a users NT login name, even when Anonymous access is turned on. As you may be aware, when both Windows Authentication and Anonymous Access are turned on, the web server doesn’t send the 401 code to the browser, and the browser doesn’t send the server the info. This means that we can’t get the data from the CGI scope.
The cfQuickDocs Firefox Plugin has been updated to point to the new www.cfquickdocs.com, instead of the old TechFeed site. This was at the request of the owner of the blog. Anyone already using the plugin may be updated automatically within 2 weeks, but as of right now, the old site is still up and running, so your existing plugins will work.
In a recent article, I discussed how you can use Oracle XE to build a local development database. I have also built a script that will recreate my staging database (which is just another local database) from production whenever I need to. This will allow me the ability to easily refresh my database when needed, then run my test scripts against it to make sure it works.