The uuid() function in MySQL returns a 36 character hex string, formatted as:

aa479ea9-1d9d-11ed-ba03-564760fe47b7

ColdFusion's createUUID() function returns a 35 character hex string formatted as:

AA479EA9-1D9D-11ED-BA03564760FE47B7

Both store the same amount of data (16 bytes), the only difference is that there is an extra dash in the MySQL uuid() function result.

Here's some SQL I came up with to create a UUID using ColdFusion's formatting in raw SQL:

SELECT upper(concat(left(uuid(), 23), right(uuid(), 12)))

It is not an ideal solution because I am actually calling uuid() twice, but it is sufficient for my use case. You could probably use a regex to remove the extra dash and avoid calling uuid twice if you wanted to try and optimize it. Feel free to post a comment if you can come up with a better way to do it.

Now suppose you want …

I am happy to announce today the release of FuseGuard Web Application Firewall for ColdFusion!

FuseGuard 2.0 is the new name for Foundeo Web Application Firewall, but we did a bit more than just change the name!

The biggest new features added to version 2 are the Web Based manager, and the database logger. The web manager main function is to provide reporting for the attacks against your server, but it also allows you to view configuration, and manage users.

Here are some screen shots:

   

    …

I am happy to announce the latest creation from foundeo: fusionKit.

fusionKit is a CD full of some handy ColdFusion components and UDF's. It is a similar concept to the DRK's that Macromedia used to sell, but is it's 100% ColdFusion.

My favorite component in the kit is the Bayesian CFC. You may recall that spam filters tend to use bayesian analysis to determine if a message is spam or ham. This CFC allows you to perform the same kind of analysis on any block of text. I am using this CFC in one of my client's blogs, and it has blocked over 4,000 spam comments in one week!

There is also the tagging CFC, which makes it easy to work with tags or …

New Atlanta, just released Beta 1 of version 7 of thier BlueDragon CFML application server.

Below is a list of the new features - I think the IsNull function and null keyword will prove to be quite handy.

• Multi-threaded programming (CFTHREAD, and related tags and functions)
• Interfaces and Abstract CFCs
• null keyword and IsNull() function
• CFQUERY Enhancements
  • CACHEDUNTILCHANGE attribute
  • BACKGROUND attribute
• Application.cfc
  • onClientStart() handler
  • onMissingTemplate() handler
• CFDOCUMENT
• CFCHART
• CFSEARCH Enhancements
  • support for Word and PDF documents …

I thought it would be fun, and informative to conduct some interviews with web developers on my blog. I'm starting off with someone that most of my blog readers probably already know, and many have probably even had a beer with - Sean Corfield.

If you don't know Sean, he was the Director of IT Architecture at Macromedia. Sean has had a diverse career including eight years involved with the ISO C++ standardization committee.

More recently Sean has been deeply involved in the ColdFusion community as a speaker at conferences, contributor to mailing lists, and more. Sean lead the team that built macromedia.com using ColdFusion and Flash, it is one of the most trafficked web sites in the world.

You can read more about Sean on his website.

Let's get on to the interview

What …