4.11.08 Mark Gibson’s JSON JQuery Updated category: AJAX, jQuery
0
comm

Mark Gibson put together a re-purposed json.js direct from Douglas Crockford’s early implementation of json.js as a jQuery plugin located here. I simply took Douglas Crockford’s ‘2008-02-14′ json2.js release and did the same re-purposing as Mark Gibson did just to have the updated features of the new json2.js code. One of those features included the [...]

4.11.08 MSSQL - Fast Character Field Loose-Comparison category: Coldfusion Development, MSSQL
0
comm

Another absolute gem that a coworker of mine, Scott Fitzpatrick, found as part of our continuing database optimization was how to compare character fields fast if doing a “loose” comparison. Say we wanted to find a row where the field was O’BRIEN but we wanted to match on OBRIEN. We have previously been using a [...]

4.11.08 MSSQL Functions To Strip Non-AlphaNumeric and Non-Numeric Characters In Character Fields category: MSSQL
0
comm

Thanks to Dan Venor and Scott Fitzpatrick and a little help isolating the ASCII Character values here are a two functions for use with inline MSSQL queries to strip non-alphanumeric and non-numeric characters in character fields respectively. This comes in handy if you’re using older versions of mssql that do not have regex (regular expression) [...]

3.27.08 Load Test AJAX Applications With HTTPERF category: AJAX, UNIX
0
comm

First off - never leave home before launching any site or server architecture without HTTPERF. http://www.hpl.hp.com/research/linux/httperf/
This is the most robust and elegantly simple load testing CLI (command line interface) I’ve yet ever seen or been happy to use. The one feature that is most impressive is the –wsesslog feature:
      –wsesslog=N,X,F
      [...]

3.17.08 Fast Display of Coldfusion Execution Time category: Coldfusion Development
2
comm

There is a definite penalty to using the “Report Execution Times” in the coldfusion administrator. There is a simple way to use built-in java timestamps to guage execution time.
I simply add a start time at the beginning of a request via the Application.cfc’s onRequest method and calculate the difference in time at the end of [...]

3.5.08 Javascript Invalid Argument errors category: AJAX, DHTML
0
comm

When you build an AJAX application that is served to IE6 and IE7 clients - you’ll probably run into the obscure “Invalid Argument” error:
[name] => Error
[number] => -2147024809
[description] => Invalid argument.
[message] => Invalid argument.
If you see this returned by the Error object that gets passed with a try {} catch {} throw or a [...]

2.21.08 Convert ADODB XML To JSON Through XSLT category: AJAX, DHTML
1
comm

Hot on the heels of my ADOtoWDDX XSLT1.0 script, here’s a way to take the ADODB XML recordSet and parse the data into a JSON array of objects (again, this will work with XSLT 1.0):
Here’s the XSLT:
<xsl:stylesheet version = ‘1.0′ xmlns:xsl=’http://www.w3.org/1999/XSL/Transform’>
    <xsl:output method="text"/> 
    <xsl:template match="/">
        <xsl:for-each select="*/*">
        [...]

2.13.08 Consolidate & Compress AJAX Javascript Files Through Coldfusion With JSMin category: AJAX, Coldfusion Development, DHTML
0
comm

When building a large-scale AJAX application the size and number of supporting Javascript files grows quickly. There are many projects out there to aid in the optimized delivery of so many AJAX application assets which essentially consolidate several Javascript files into one file, “compress” via JSMin and finally compress via mod_deflate or simple gzip HTTP [...]

12.24.07 mod_cache ignores mod_dir DirectoryIndex index files + workaround category: UNIX
0
comm

An interesting problem with Apache’s mod_cache (even “production” in the 2.2.X branch) is that it does not cache mod_dir’s DirectoryIndex files. For instance, if you have a
DirectoryIndex index.html index.php
declaration, neither of which will be cached by mod_cache. I have only seen this be true for mod_disk_cache but assume it fails with mod_mem_cache as well. The [...]

12.17.07 Custom Coldfusion Caching Engine category: Coldfusion Development
2
comm

CFCACHE is a black box item. It works well for “normal” pages, but it’s one caveat since version 6 of Coldfusion was that it automatically pre-pended the cache file with a <!— URI —> right at the top of the file. This ruins any DOCTYPE declaration in IE and there’s no way around it - [...]

2.673s