I've been stumbling upon this bug for a while now, and keep having to remember how to fix it. Tired of googling it every time (and it's never in the top results), I thought I'd write a short entry on how to enable line numbers when there doesn't seem to be an option for it in CFEclipse 1.3.1.6.

Today I had to generate a raw dump of data into an Excel file. Nothing new here. However, while coding/testing, I was frustrated by the fact I had little control on how my file looked. Normally, when I have to create an Excel file with Coldfusion, I just make up a table in HTML and send it to Microsoft with the handy little cfcontent tag. However, there's only so much you can do with Excel's limited CSS support.

After a lot of work trying to get the system up and running, I finally managed to get to the point where I'm actually writing the post I wanted! As you can see from the title, the point of this entry is to discuss how to retrieve data from an external source. Let's say you want to get data to and from different servers. Let's say server A runs on CF / MSSQL and you want to be able to get data from server B, which runs on CF / MySQL.

I was going to post something a little more... substantial, but then fate intervened. OK, it wasn't fate, but rather a lack of preparation on my part. I recently had to format my hard drive, and when I reinstalled all of my programs, I forgot the most important ones: my dev environment! So... when I came to get a post ready on Friday, I wasn't setup to get anything prepared!

I know I've been absent for a while, and I'd lie if I said I had any good excuse for not posting anything during that time. To be honest, I hit some kind of a down, and it's been really hard getting back up. Work was at an all-time stressful high, and any extra-curricular time I had was spent trying to get some of the pressure off. However some projects that were being held back have since been launched, and work has begun on some new ones.

Ben Nadel has written up an excellent post and started a really interesting discussion on SQL best practices. Some techniques apply only to Coldfusion (which is just fine ), but most of them cover SQL in general. Follow the link to indulge.

Recently we started having several crashes and "unable to create new native thread" error messages on one of our servers at work. Oddly, this was one of our most stable machines and the problem started very suddenly. Now I know what you're thinking, and no we didn't modify the codebase of any applications on that server (there are only 2). However, the volume of requests can vary from day to day, so we assumed it was being caused by memory problems.

In a previous article, we had configured FCKeditor to work with BlogCFC. After a couple of posts, however, we realized that FCKeditor was having problems with both "tags" we could use: <more/> and <code></code>. When switching from WYSIWYG to Source mode, FCKeditor would break all of our formatting, breaking the <more/> tag and destroying the <code> tag and it's content. After a little googling, here is what I was able to put together.

Work continues on Project moreADS! To see where we're at, you can click here. You might say that not much has changed since Monday. I'd have to agree with you, at least visually. I did change the menu list a bit, made it a bit more graphic, and added some valid and powered by buttons at the bottom of the page. However, the big part of the work was done under the hood. As always, at every step of development the source code is available as a download at the bottom of the post.

Every once in a while, my lazy side gets the best of me. It's not necessarily a bad thing, though. It's just that sometimes, writing blog posts in a textarea field can be a pain (no offense, Ray. BlogCFC rocks! And I saw those comments in tags/textarea.cfm ). Of course, as a programmer, I much prefer actually writing up the HTML for my markup on my own. However, this is a blog post, not a full-fledged application.