SQL Server: How Many Work/Week Days In Date Range

Posted by Brad Wood
Oct 15, 2008 11:19:00 UTC
I had the need to calculate how many week days existed in an arbitrary range of dates today. I Googled for a while but didn't find anything I liked and I really didn't want to iterate over the entire range and count. For what it's worth, this is what I hacked out.

ActionScript Date Comparison

Posted by Brad Wood
Oct 15, 2008 07:29:00 UTC
I was just staring a a piece of ActionScript code trying to figure out why the two date objects I was comparing were not coming up equal. I'm ashamed to say I didn't notice the problem at first because I had mistakenly typed if(date1 = date2) Two equals signs ("==") work a little better than one since the single operator obviously changes the value of the former operand. :) Once I fixed that, I found my real problem.

Flex Charting: Format Your Data Tips The Same As Your Axes

Posted by Brad Wood
Oct 14, 2008 22:20:00 UTC
In case you are wondering, "Axes" is the plural form of "Axis" and it is pronounced "Axees" with a long e as in "see". Perhaps you have never pondered that one, but it's been driving me crazy. In this post I wanted to demonstrate a little experiment I did tonight to try and not duplicate as much formatting when it came to my charting data tips. I can already think of a few problems with it, but I wanted to try anyway.

Flex Charting: Format Your X And Y Axis

Posted by Brad Wood
Oct 14, 2008 22:00:00 UTC
Well, once again this is a pretty basic post of information readily available on the Internet. It took me seemingly forever to piece it all together, so I am blogging it to cement it in my mind and hopefully help someone else down the road. This week I have conquered the formatting of my X and Y axis labels for my charts. As usual, the hoops are a little bulky to jump through when you just want to add a very simple bit of formatting, but the flexibility is awesome.

Solution: Query of Queries Whitespace Problem

Posted by Brad Wood
Oct 09, 2008 14:28:00 UTC
I came up with a ColdFusion-only hackish solution for the whitespace problem caused by query of queries. Brad suggested I hardcode a temp table into a random SQL database on our server, which is also a good hackish solution, but required database access. Because I was doing all of this work without accessing the database, I wanted to come up with a solution I could implement just in ColdFusion.

Query of Queries -- Whitespace Is Important

Posted by Brad Wood
Oct 09, 2008 09:25:00 UTC
I've been working on modifying the QueryParamScanner to have a new screen that will allow me to fix the queries and update the files automatically. I finally seem to have everything working and I have the code setup so I can edit the suggested changes to fix anything that the regular expression didn't guess correctly. Last night I was running a final test and I noticed that I had lost all of the whitespace at the beginning and end of each query.

Where Did Yahoo! Go?

Posted by Brad Wood
Oct 08, 2008 20:16:00 UTC
Recently Yahoo's home page changed for me. Interestingly enough, I only get the new page at home while using Internet Explorer. Apparently they are "easing" their redesigned site into the market a few users at a time. I didn't start getting it until I cleared my IE cookies last night. Even after clearing my Firefox cookies, I still get the old school page there.

Having A Hard Time Finding Flex 3 Language Reference

Posted by Brad Wood
Oct 08, 2008 08:43:00 UTC
I feel dumb saying this, but I am having a heck of a time finding consistent information about Flex 3 classes. I am just starting in Flex and it isn't TOO hard to find an example out there that is close to what you are doing, but often times examples don't cover all the bases, and I'll need to look up a method to get its exact signature. (How many arguments, what type, etc) Generally, I'll turn to the livedocs for this, but I have been wasting a lot of time Googling and I don't think it should be this hard.

Formatting My DataGrid Cells For Currency

Posted by Brad Wood
Oct 07, 2008 11:51:00 UTC
If you have been programming in Flex for a while, I have nothing earth-shattering to say here. Nevertheless, having just figured it out I wish to write it down as much for my sake as anyone else. My latest task, simple as it was, involved formatting the numbers in several of my Data Grids as dollars and cents.

Flex Has Forced Me To Think Differently About My Code

Posted by Brad Wood
Oct 04, 2008 20:40:00 UTC
I have been enjoying my dip into Flex so far. Sometimes you don't notice habits until you have to change them. One rut I've gotten into over the years is the procedural way web-based apps have gotten be thinking about programming.

Site Updates

Entries Search