SQL DateDiff, Between, and GetDate()
Posted by Stephen Weyrick | Tags: sql
Today I was trying to fix problem with a report that sums up hours, and I had a huge brain fart. What took me an hour to fix, should have only taken me about 5 minutes. I thought that it would make a good blog post, because I really don't want to make this same stupid mistake again.
Check if a ColdFusion Array Position Exists
Posted by Stephen Weyrick | Tags: coldfusion
This is some sample script that I used today to check if a position in an array exists. Basically, I was tasked with creating an email that showed hours from two separate datasources, and I needed to combine those side by side in an array to show the differences. I knew that the first set of hours would always exist, so I looped over the second set of hours with a nested loop matching up the dates. To check if the second position existed, I used a cfparam with set values of zero. I did this because ColdFusion doesn't seem to have clean way of checking for a missing element.
Updating Datasource with ColdFusion Bean
Posted by Stephen Weyrick | Tags: coldfusion , flex
John Gagliardi(cftips.net) and I have been working on a new flex application that will be used as a project tracker for work related purposes. John is building the Flex or UI side of the application, while I am building the database and ColdFusion backend. We are trying to build the entire application using OOP design priciples; specifically MVC. After building the database and basically getting a great start on the project, I am starting to realize how powerful OOP can actually be. Today we created a task updater that is controlled by horizontal date slider, and I wanted to share some of my backend code which will hopefully show just how easy it is to update a simple CRUD app.
Windows Vista Screen Saver Problems
Posted by Stephen Weyrick | Tags: vista
Last Month I purchased a new labtop which came with Windows Vista pre-installed. I haven't had any problems with the labtop or Vista; however, I couldn't get the screen saver to turn on automatically. After researching and troubleshooting, I realized that it stopped working when I plugged in my 'Microsoft' usb optical mouse. It seems absurd to me that a Microsoft hardware product wasn't tested on Windows Vista before being released (sarcasm).
Organizational Development
Posted by Stephen Weyrick | Tags: coldfusion
This morning I was browsing through blog posts on Hal Helms website, and I came across his Organizational Development Maturatity Chart and Definitions. It was really interesting to compare my place of work with the definitions listed below the chart. I think that my shop is at the dangerous two position. We have employed and recognize the benefits of OO design, but we find it difficult to learn more without an expert mentor. We continually debate about whether our designs are consistant with current OO best practices or not. I wrote this post to ask the ColdFusion community for references to books, articles, or topics related to OO design. What would be the best approach to understanding OO in ColdFusion and what kind of resources would be best to use?