This is based on an old example from Ray Camden, but is now 100% in script. Feel free to use it.
I am a big fan of the script capabilities of CF 11 and especially queryExecute(). If you are using it, make sure all your SQL is wrapped within double quotes so that string values work and you don't end up troubleshooting simple issue because of vague errors. Take this example I originally made the error of using single quotes which tends to be my preference, but ended up with an error of ColdFusion is looking [...]
Relaunch of an old post. So this week (January 24, 2012), I had the need for dates of varying formats and I decided to post a beginners post. I currently am using CF Builder at work and as much as I like Dreamweaver, CF Builder showed me something I had never used before or haven't used in so long that I have forgotten; the built-in date formats (long, medium, short, and full). I have always [...]