Community Member Profile

Recent Blog Comments By Mike Causer

• Why NULL Values Should Not Be Used in a Database Unless Required

  Posted on Feb 23, 2010 at 11:33 PM

  Nulls are great! They are excluded where you expect them to be. As per your examples, if you wish to include them, you need to use the sql server isNull() function to replace the nulls with blank strings. Theres also an opposite nullIf() function for replacing values with nulls w... read more »

• QUERY.ColumnList Does Not Return True Column Ordering

  Posted on Oct 29, 2009 at 9:45 PM

  If you want all columns, in their specified case and in their selected order, use this: columns = arrayToList( myQuery.getMeta().getColumnLabels() ); getColumnLabels() returns a java string array (string[]), so if you want to use cf array methods on it, you'll need to bounce it through... read more »

• ColdFusion Application.cfc OnRequest() Creates A Component Mixin

  Posted on Aug 19, 2009 at 10:56 PM

  typo detected... "Executes the requested ColdFusoin template"... read more »

• GetMetaData() Is Shared By All Instances Of A Given Class In ColdFusion

  Posted on Jul 22, 2009 at 8:53 PM

  Interesting... It seems the meta data is being stored with the template proxy cache. I guess they figured it wouldn't change much and people wouldn't try to modify it... The cache hangs around until you run: createObject('component','CFIDE.AdminAPI.runtime' ).clearTrustedCache('/full/... read more »

• KinkyTwits - My ColdFusion And jQuery Powered Twitter Client (Beta)

  Posted on Jul 20, 2009 at 7:31 PM

  seems the problem is to do with the cf8/9 javascript-style create structs and arrays. eg. myStruct = {}; myArray = []; try replacing {} with structNew() and [] with arrayNew(1) or upgrading to cf8... read more »

• KinkyTwits - My ColdFusion And jQuery Powered Twitter Client (Beta)

  Posted on May 15, 2009 at 1:08 AM

  Nice work! One thing I noticed was in TinyURLService.cfc you were pointing to http://tinyurl.com/create.php and using regex to extract the url. There is a TinyURL api which just simply returns the url, without tons of html. N... read more »

• ColdFusion GetPageContext() Massive Exploration

  Posted on Mar 2, 2009 at 7:19 PM

  JD-GUI 0.2.7 > DJ Java Decompiler http://java.de compiler.free.fr/ You can pass in the entire cfusion.jar file and have a poke around. FTW!... read more »

• Ask Ben: Converting A Query To A Struct

  Posted on Jan 27, 2009 at 11:21 PM

  A limitation with deserializeJSON() in CF8 is that it cant convert a json string that looks like a cf query back into a query object. Instead it converts the query to a struct containing 2 keys, columns and data. Data is an array of rows. Each row is an array of data for each column.... read more »