With a little side of applesauce...

Friday, March 26, 2010

Adobe Coldfusion Builder - installation notes

I wanted to write up some notes about my Adobe Coldfusion Builder installation experience. I am a longtime Eclipse user, so I thought I would just install the plugin version into my existing Eclipse installation. Here are the troubles that I have had:

1. You need to uninstall CFEclipse and Coldfusion Extensions first.
2. You need to import your CFEclipse projects into the Coldfusion Builder. (http://www.trunkful.com/index.cfm/2010/3/23/Migrating-to-ColdFusion-Builder-from-CFEclipse)
3. You need to do a full uninstall of Coldfusion Builder, if you decide you want to try the standalone version after installing the Eclipse plugin. If you don't, you will receive a Licensing error mentioned here, (http://blogs.adobe.com/cfbuilder/2010/03/things_to_watch_out_while_inst.html), when you startup the standalone version.
4. You need to do a full uninstall of Coldfusion if you decide you want to go from the standalone to the Eclipse plugin. If you don't, the cfbuilder_install program will complain about existing Coldfusion Builder plugins. You may need to manually delete any existing /Application/Adobe Coldfusion Builder* folders, (on a Mac), in addition to manually deleting Coldfusion Builder plugins from the /path/to/eclipse/plugins directory.
5. My initial installation of Coldfusion Builder as an Eclipse plugin was broken, so it showed up as being installed into Eclipse but broken. There was no Uninstall option for the packages while in this state, so I manually deleted the folders in #4, was then able to continue installing Coldfusion Builder back into Eclipse.

Monday, March 22, 2010

Coldfusion - access specific row in query object

I ran into an issue where:

<cfloop query="myquery">

was throwing a CFQUERY timeout. When I looked at the problem, I realized that CFLOOP must be holding open the query object, and then Coldfusion would throw the CFQUERY timeout error. To get around this, I decided to use CFLOOP, and then just iterate through the query object by referencing the rows. Here is how you do that:

<cfquery datasource="#Application.dsn#" name="notstudents">
select *
from people
where usertype != 'student'

<cfloop from="1" to="#notstudents.Recordcount#" index="id">
<!--- grab all associated categories --->
<cfquery datasource="#Application.dsn#" name="categories">
select category
from categories
where userid = '#notstudents [ "myid" ][ id ]#'

"myid" is the field that I want to reference in the notstudents query, and "id" is the row. I like the array notation, though it was really Ben Nadel who helped me get to this point:

Friday, March 19, 2010

iTunes - play FLAC files

Make sure to download the 0.2.5 version if you are running 10.6 Snow Leopard:


Tuesday, March 2, 2010

Mac OS X 10.6 - Start Screen Saver

I have found that you simply need to enable Hot Corners
Preferences->Desktop & Screen Saver->Hot Corners...

I set my bottom left-corner as my Screen Saver Hot Corner.