Review: Spam-a-lot

Quick Verdict: Hilarious and Inventive

While I would never call myself a huge Monte Python fan, I found myself laughing more at the clever way the show adapted the scenes from the movie. I also think I laughed more at the parts that were original to the musical and not in the movie. There were a few die-hard fans that laughed when they knew a particular scene was about to get played out and sometimes (annoyingly) they would even fill in the dialog. On top of the creative adaptation, the set design was amazing and inventive. I was extremely impress by the dramatic lighting (and lighting devices), the way they interlaced video projection into the set and the overall set architecture and costumes were also well done.

Truly a great laugh and worth the money!!!

cfprocparam Gotcha in CF 7.0.2 Hot Fix 1

We just moved CF 7.0.2 Hot Fix 1 into our dev environment today and quickly found a problem…

It seems that a developer who no longer works with us liked to use named parameters like this:
cfprocparam cfsqltype=”cf_sql_integer” type=”in” dbvarname=”intLinkLocation_ID” value=”#Form.linkLocation#”

The only problem was that the MS SQL 2000 server used @intLinkLocation_ID for the parameter. CF seemed to forget this fact since the items were in the correct sequence. After the hot fix it throws a cryptic error on the stored procedure.

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near ‘=’.

The fix is easy, just add the @. Unfortunately, we found over 1000 instances where the @ is missing. Even if we add them all we now have the fun of testing all the apps to make sure we get the names right.

So watch out!!!