http://blogs.law.harvard.edu/tech/rss http://www.sorcerers-tower.net Welcome to the Tower, my programming and web development blog. Here you will find articles relating to CFML, CSS, HTML, Java, JavaScript and Regular Expressions, plus discussions on the associated tools, technologies, techniques and ideas.</p> <p>For more general topics, please visit <a href="http://www.sorcerers-isle.net">Sorcerer's Isle</a>, where you will find articles on my other interests. SQL http://www.sorcerers-tower.net/article/queryparam_scanner_v0.7_released_v0.8_in_progress.html <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> Tue, 23 Sep 2008 20:09:31 GMT http://www.sorcerers-tower.net/article/queryparam_scanner_v0.7_dev.html <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> Sun, 17 Aug 2008 00:01:01 GMT http://www.sorcerers-tower.net/article/scotch_on_the_rocks_2008.html <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> Fri, 06 Jun 2008 22:57:00 GMT http://www.sorcerers-tower.net/article/cfdevcon_2006.html <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> Thu, 09 Nov 2006 22:49:42 GMT http://www.sorcerers-tower.net/article/sql_look_behind_you.html <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> Mon, 21 Aug 2006 18:34:47 GMT