Flash CS4 Update Fixes Hanging Issues

Date February 10, 2010

I recently had Flash CS4 installed and began experiencing some issues. Specifically, I was attempting to copy a nested object from within one heavily nested frame into another movie. Flash hung immediately and never recovered.

After a little bit of Googling I found that Adobe released an update to version 10.0.2 on 5/13/2009 to address similar issues. The installation was fairly quick and painless. No reboot was required. It seemed to fix the issues I was experiencing.

You can download the update here:
http://www.adobe.com/support/flash/downloads.html

If you purchased a current copy of Flash, the update is probably already included since it came out last year. The version information is on the splash page and under Help / About Adobe Flash CS4 within the application.

How to View Bit Values in MySQL Query Browser

Date November 6, 2009

I stumbled across this useful tidbit the other day in the MySQL Forums. I’ve always been frustrated that bit data type values fail to appear in MySQL Query Browser. Instead, it simply displays a ‘b’ regardless of the actual value.

I looked through all of the options but couldn’t find a setting related to the issue. The solution (workaround) turned out to be very easy. Just add 0 to the column in the SELECT list and the values will appear.

For example:

SELECT myBooleanColumn + 0 as myBooleanColumn
FROM myTable

Either a 1 or a 0 will now appear as the value in the results.

Update ColdFusion Query Columns With JavaCast

Date October 9, 2009

I recently found myself in need of a way to convert a Binary data column into Base64 encoded data when returning a query. After a quick Google, I was directed to Ben Nadel’s post “Updating Columns In An Existing ColdFusion Query Object” which details how to use javaCast to update a ColdFusion query.

From there, I just needed to add the small extra step of Base64 encoding and my query was ready to go.

<cfloop  query="q">
    <cfset base64Data = toBase64(q.my_binary_data) />
    <cfset q["my_binary_data"][q.currentRow] = javaCast("string",'#base64Data#') />
</cfloop>            

This is not the first time I found a useful solution on Ben’s site. If you use ColdFusion, you should definitely check it out. He has some great, easy-to-understand, posts on many useful topics.