Dynamically Changing jQuery UI Accordion Tab Headings
If you're into using jQuery UI (and who's not?) then this is an easy way to change the heading of a jQuery accordion tab style heading to reflect user focus.
HELP! Have you ever successfully output a cfchart within a cfdocument?
I have a cfchart (flash format) that works great within a normal cfm page. I'm running CF 8 so I should be able to embed the cfchart within a cfdocument but for whatever reason I cannot. If I change the chart format to png or jpg then I get a red x and if I run it as a flash format I get nothing. Has anyone out there ran into this and lived to tell the tale?
UPDATE: Outputting the cfchart in png format will work if the localUrl attribute is removed (or set to false).
Getting Started with jQuery UI Dialogs
So I've been slowly learning jQuery over the last two weeks and today I wanted to see how I could duplicate the cool overlay style and functionality of a cfwindow. As it turns out, jQuery UI makes this super simple with Dialogs.
Looking for a MySQL equivalent for SQL Server's ISNULL function?
SQL Server has a well known and widely used ISNULL function that actually replaces a null column value or null subquery value with whatever you specify. For example, if you were to write
1 SELECT ISNULL(UnitPrice,0)
2 FROM InventoryItem
2 FROM InventoryItem
then you would have zeros returned in your result set for all InventoryItem table records that had a NULL value for the UnitPrice field. Ever tried to do that in MySQL? It doesn't work because MySQL's ISNULL function simply returns a value telling you whether or not the argument to the ISNULL function was NULL or not. Not as cool when compared to SQL Server's nifty replace type of functionality now is it? But wait, no need to talk smack about MySQL - for there is another great and easy to use command in MySQL that will give us the same result!
Using jQuery load in place of a cfdiv
As many of you know, yesterday I ventured into the world of jQuery for the first time. I'm a little late to the party so I've decided that in order to get proficient with jQuery before the apocalypse I'm going to have to use it in my everyday client development tasks.
To give you some background, I have a long, on-going project where I'm creating a warehouse management/manufacturing application using ColdFusion 8 and SQL Server 2005. The app is huge and I've been using lots of out of the box cfajax widgets and cfajaxproxy to do cool things. I wanted to see how tough it would be to make jQuery do the same type of thing that I would normally use a cfdiv to accomplish. The quick answer? Easy, easy, easy - so easy that I couldn't believe it and had to ask Ray Camden if it were truly that easy or if I had made some sort of lucky mistake. I said, "Ray - it's too fast and too easy" and he said "Is that even AIR that you're breathing???" so here we go!
