Welcome to Sorcerer's Isle, a weblog covering a multitude of topics, ranging from programming to 3D graphics; photography to gadgets; tutorials to tinkering. SQL

<p>I have released v0.7 of <a href="http://www.hybridchill.com/projects/qpscanner.html">QueryParam Scanner</a>, which introduces a variety of improvements over v0.6.1:</p> <ul> <li>Significantly faster processing</li> <li>Multiple output formats (HTML, XML, WDDX).</li> <li>Ability to override Request Timeout.</li> <li>Option to specify file/directory exclusions (regex).</li> <li>Option to include/exclude Query of Queries.</li> <li>Option to include/exclude built-in CFML functions.</li> <li>Eclipse Plugin for easier execution.</li> </ul> <br/> <p>For more details and download information, visit the <a href="http://www.hybridchill.com/projects/qpscanner.html">project page at Hybridchill</a>.</p> <br/> <h2>Future Improvements</h2> <p>The following release, v0.8 will have three key features:</p> <ul> <li>A Fix mode, allowing you to manually or automatically correct missing cfqueryparams.</li> <li>A flexible exclusion system, allowing you to ignore paths and variables you know are ok.</li> <li>Integration and examples of use for <a href="http://ant.apache.org">Apache Ant</a> and <a href="http://www.mxunit.org">MXUnit</a>.</li> </ul>

2008-09-23T20:09:31Z

<p>The latest development version of qpScanner is now in SVN at <a href="http://qpscanner.riaforge.org/">RIAForge</a>.</p> <p>It would be great if people could test it out and let me know of any issues they encounter.</p> <p>As before, it is all self-contained, so it can be installed and run with minimal effort.</p> <p><strong>Note:</strong> As this is still the development version, you need to use the zip option at the bottom of the RIAForge page, <em>not</em> the "Download Project" link - the button will only give the old version.</p> <p>When released, v0.7 will be a significant new version, so I want to give a quick discussion of the new features...</p>

2008-08-17T00:01:01Z

<p>Well the first day of Scotch '08 is now over, so here is a quick round-up of the sessions I attended.</p> <p>Day two has ended, and I have updated the main entry with details on today's events.</p> <p>Scotch on the Rocks 2008 is now unfortunately ended, as before please see the main entry for the final day's summaries.</p>

2008-06-06T22:57:00Z

<p>Okay, so I've arrived back from <a href="http://www.cfdevcon.com">the UK's first* ColdFusion developers' conference</a> (*if you ignore the previous two UK-based CF conferences), and decided I would give my thoughts about it.</p>

2006-11-09T22:49:42Z

<p>Where I work we have a generic database table which stores a variety of values associated with different things. Each entry has a type, id and description, along with a set of generic alpha_1..9 and numeric_1..9 columns.</p> <p>Today I needed to check whether a certain value was in the table but wasn't certain where it might be - all I knew was that it was text, so I started writing the following SQL...</p>

2006-08-21T18:34:47Z