not long until 2005…

general No Comments »

With not long to go until it’s 2005 I’ve been doing some work on the codebase for my site - mostly rearchitecting bits where i’d been lazy in places. Also, I wanted to sort out the ‘archives’ section in the right side bar as the list of months is ever growing. This will only now show the individual months for the current year, previous years will appear in the list at the bottom allowing you to view archives when you click on the year. I’ve also tidied up the email that is sent when you post a comment - it was messy and needed line breaks!!

Happy Christmas everyone!

general 1 Comment »

My turn to wish everyone a really great Christmas and even better 2005.

I’m sitting here at my very empty old desk having packed it all up ready to start my new job as a full time Cold Fusion developer on the 4th January - I can’t wait!!!!

Happy Holidays!


Portable Eclipse - part2

ColdFusion 3 Comments »

This post is just in case you didn’t see the thread on CF-talk regarding making Eclipse & cfeclipse small enough to fit on a memory stick (apart from buying a bigger memory stick!!!). Spike replied with the following minimumalist list of plugins for running on Windows;

org.apache.lucene
org.eclipse.core.expressions
org.eclipse.core.filebuffers
org.eclipse.core.resources
org.eclipse.core.runtime
org.eclipse.core.runtime.compatability
org.eclipse.help
org.eclipse.help.appserver
org.eclipse.help.base
org.eclipse.jface
org.eclipse.jface.text
org.eclipse.osgi
org.eclipse.platform
org.eclipse.swt
org.eclipse.swt.win32
org.eclipse.text
org.eclipse.ui
org.eclipse.ui.editors
org.eclipse.ui.forms
org.eclipse.ui.ide
org.eclipse.ui.views
org.eclipse.ui.workbench
org.eclipse.ui.workbench.texteditor
org.eclipse.update.configurator
org.eclipse.update.core
org.eclipse.update.ui

Spike ended his post by saying that reducing the plugins to the above you won’t have any support for CVS, Synchronization, ANT or any other feature installed by default. It will bring the size of Eclipse down to around 14Mb!!!

Fusebuilder: A gem for Fuseboxers!

ColdFusion, Fusebox 2 Comments »

Fusebuilder has been around for a while now - essentially it’s a web based Fusebox application builder. You can start by building your wireframe and then take the project right through to architecting individual fuses. Being web based obviously has distinct advantages, I can be sitting at my desk and being working on a wireframe whilst in a conference call with clients who are looking at the same wireframe as i build it on my website.


Over the past few days I’ve been talking with the creator of Fusebuilder, Mike Ritchie on MSN Messenger and he’s been kind enough to show me the next installment of Fusebuilder - wow, it’s impressive! Being as Fusebox 4.1 is about to release Fusebuilder has been upgraded to take advantage of all the new features in Fusebox. It’s been an interesting couple of days as I’ve been building a project on one of Mike’s servers and then when i run into a problem or something that doesn’t quite work right he nips in, jigs the code for Fusebuilder and i carry on - for more major problems he works on them in the evening whilst I’m asleep (the joy of cross time zone developing) and then it’s all fixed for me in the morning whilst he’s sleeping.

Right, so if you’ve never seen Fusebuilder, here’s a look at a typical fusebuilder screen


In the screenshot above you can see ‘blog’ circuit beneath the controller along with the fuseactions that exist within the circuit. Circuits and fuseactions can be added using the links in the side bar or by using keyboard short cuts eg, to add a new circuit just press ‘c’ and if you want a new fuseaction just press ‘f’. If you go into a fuseaction you see the following:


What you now see is all the ‘elements’ that make up the particular fuseaction, in this case blog.show - what’s really nice is the ‘Preview Fusebox Code’ link which as expected will show you the code that will be generated when you generate code - which incidently can be either PHP of CF in various guises of Fusebox.

In the fuseaction screenshot above you’ll see an INVOKE and that’s where things start getting fun.  What you can now do in Fusebuilder is register CFC’s so they appear in the CLASS element in your fusebox.xml.cfm, but Fusebuilder goes one step further and allows you to actually register methods (complete with arguments) that exists in your CFCs - the idea is that when you generate code ’stub’ CFCs will be created for you *OR* if you’ve got existing CFCs you will be able to import them into Fusebuilder for use in your application design


Here’s a couple of CFCs I’ve started to define (just for testing) along with a couple of methods and the arguments they take. So now, when I add an element in to a Fuseaction we see the available element types;


Selecting an INVOKE element takes us to this screen;


You can see all the CFCs and associated methods are retrieved allowing the developer to select which ever they require. On selecting a particular method Fusebuilder prompts you for whatever arguments are required for that CFC as previously defined.


Notice here, I’m now prompted for a blogID argument. That is just cool!!!!

Fusebuilder uses a similar technique for custom lexicon - we register our individual pieces of lexicon along with parameters they take



so then when we add a Custom Lexicon element to a particular fuseaction we can only add predefined pieces of lexicon and make sure an attributes that are required are entered.

So that’s a brief look at what’s to come and it sure is looking rosy for Fusebuilder. At the moment you can download the Fusebox4 version, Fusebuilder is honourware so if you download it you’ll get the full version but if you like it you’re expected to pay for it. The new FuseBuilder for Fusebox 4.1 has taken a stricter approach, but any previous license purchases will be honoured towards the full price of the 4.1 version. Talking with Mike he’s also considering a new ’subscriber’ based model so developers don’t need it installed locally - develop on his servers, generate a project and out pops a ZIP file containing all the stubs etc.

In all the excitment I forget to mention one important thing, Fusebuilder does not use a database - project information is saved into a file on the server so they’re fully portable between Fusebuilder installations!!!!

Barneyb on Architeching FB 4.1 apps

Fusebox No Comments »

BarneyB has posted an interesting take on architecting Fusebox 4.1 applications - it’s always interesting to see what other folk are doing and Barney’s post certainly gives you food for though.

the Google Zeigeist

general No Comments »

Here’s an interesting section on Google.com, it’s Zeitgeist. What is the Zeitgeist? It’s Googles search statistics, patterns, trends and other surprises page. You can even see the most searched for items per country right back to 2001. It’s quite interesting to see!

The Zeitgeist for the USA is here

For the rest of the world, see here

you won’t have noticed, but…

general No Comments »

I’ve moved my hosting yet again! I didn’t like the fact that the host i moved to in the UK was using CF Standard on their shared reseller plans and i had a number of unneccessary downtimes - i even had to request they put the lastest MX6.1 updater on!! So now, I have my own CF instance in a virtual private server back once again hosted in the USA with cfxhosting. My blog has been upsized to SQL server too - although i never had a problem with it in MS Access. I’ve moved my email over to a hosted MS Exchange account with Intermedia.net for a mere $9.95 a month per mailbox - 200mb storage, MAPI, OWA, OMA, Wireless sync via ActiveSync, Blackberry etc, Spam, AV.

So i’ll be hated by anyone using CFHTTP to syndicate my blog, that darn DNS caching issue - sorry Lucas! But i think that I’ve got the best of both worlds now and will stay put for a while with cfxhosting.

Problems with Unicode and MS Access

ColdFusion 8 Comments »

I had a bitch of a problem this morning. I found that having moved hosts i couldn’t post long entries into my blog. I was getting a message back “Error Executing Database Query. Application uses a value of the wrong type for the current operation” - not too helpful.

I used a couple of UDFs from cflib to look at the datasources on the server and then retrieve the properties for my datasource - i found it was using the MS Access unicode driver whilst I’ve always used the standard MS Access driver when developing. When i changed the driver on my local machine I was able to duplicate the problem - which was a start!

The code i’m using is based on Ray’s blog app - the insert uses a cfqueryparam with type=”cf_sql_longvarchar” into a field of ‘memo’ type in MS Access. I found after a while that removing the cfqueryparam i could get data inserted - so the problem lay with the cfqueryparam tag.

It was suggested in Sean’s breeze room to try enabling CLOB/BLOB on the DSN but then i tried type=clob on the cfqueryparam and it worked! It turns out DWMX2004 only has 20 possible sql types in the cfqueryparam tag insight where if you look in the livedocs here you’ll see 22 types listed, including BLOB and CLOB. After changing the type to CLOB I tried the insertion again to see if it worked with the standard MS Access driver and it did - a few folks seem to think that a CLOB type is a better choice for the ‘memo’ field type in MS Access.

PS: CFeclipse has the correct types as defined in the livedocs :)

PPS: I found other differences between the two drivers too, the unicode version has ‘action’ as a reserved SQL word, so if you use it as a column names it needs to be wrapped in [] brackets. Also Yes/No field types seem to require different code to be able to obtain correct results.

Fusebox4.1 Sample App

ColdFusion, Fusebox 5 Comments »

Brian Kotek has just published a great Fusebox4.1 sample app based on the same sample application he’s done in Fusebox3, FuseQ, Fusebox4 and now Fusebox4.1 - the bookstore. It’s available to download on his site, here.

Brian uses some of the new XML that was introduced in Fusebox4.1 to invoke CFCs within circuit definition files although i would like to see some of the code he’s used in fusebox.init.cfm to define classes moved into fusebox.xml.cfm and then have CFCs instatiated using the new INSTATIATE verb just to leverage all the new functionality in Fusebox4.1. Great job, Brian!

i’ll be back…

general 1 Comment »

I’ve disappeared from the UK CFUG Blogregator, i’d expect down to the issue of DNS caching with CFHTTP (since i’ve moved hosts). Hopefully i’ll be back syndicated on there shortly.

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in