So yesterday I blogged on how to create a T-SQL custom scalar function in SQL Server to clean up a DATETIME and output it like this... 05/11/2010 11:37 AM. So for anyone who is primarily using MySQL (most of our clients use SQL Server but we also take care of some MySQL driven CF apps too) here is the same code for creating and calling your very own inline function on the MySQL platform.
As we all know, ColdFusion has a stellar line up of date and time formatting functions. But what happens when you need to do this at the database query level in a CFC or a Stored Procedure? Plus a FREE Scalar function!
So if you're a CF'er who has doubled down on AJAX then you really should take a minute to get to know the JavaScript arguments object.
If you've struggled with emulating GMail or Yahoo style Select All functionality for tabular forms and you're in love (or just curious) about jQuery and ColdFusion then this post is for you! If you love MASS EFFECT and you just want to see where someone has come up with a legitimate reason to use the words MASS EFFECT in code then this post if for you too!
Have you ever spent an hour on something that was so simple that upon solving it you wonder how you possess enough brain power to have ever learned to write a simple statement? Well I did and I'm writing this entry for anyone else who has ever felt like they should be immediately de-rezzed! Yeah - I just went TRON on you...
Someone recently asked me if it were possible to easily execute the same code for two or more possible case values in a JavaScript switch statement.
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.
Have you ever wanted to quickly migrate selected table data back and fourth from your dev database to your live database? If the answer is yes then this one's for you.
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).
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.
