Dominic Watson

Recent Blog Comments By Dominic Watson

• CF_SQL_DATE Issues with MS SQL Server 2005

  Posted on Apr 21, 2008 at 8:21 PM

  Love it, saved my ass ;)... read more »

• Creating ColdFusion Components In Parent Directories (From Sub Directories) Without Mapped Paths

  Posted on Jan 29, 2008 at 12:26 PM

  Oh lol, just noticed it was Ben that posted that - I guess I don't need to extol the virtues of ColdSpring to ya! :blushes:... read more »

• Creating ColdFusion Components In Parent Directories (From Sub Directories) Without Mapped Paths

  Posted on Jan 29, 2008 at 12:25 PM

  Yeh, it took me about 10 minutes of going through the ColdSpring tutorial to switch to using it to generate my components. At its most basic level it is like your udfs and you can very quickly just use it at that level. But then it offers so much more... :) Higly recommended, Dominic... read more »

• Creating ColdFusion Components In Parent Directories (From Sub Directories) Without Mapped Paths

  Posted on Nov 16, 2007 at 11:18 AM

  @Ben, my sentiment exactly. If someone makes a typo in setting up a mapping for one of our govornment projects it can take 5days+ for them to resolve it! So my philosophy is to give them as little to do as possible... Anyways, we are talking the same talk ;)... read more »

• Creating ColdFusion Components In Parent Directories (From Sub Directories) Without Mapped Paths

  Posted on Nov 16, 2007 at 11:05 AM

  Like it. I remember putting something like this to the CFDev list sometime ago and getting a "why bother, just use mappings" response. Our company too uses shared hosting by other companies and portability was my motivation. On another note, my udf used cfinvoke and allowed you to supply the met... read more »

• Using ColdFusion Query's Underlying Java Methods For Query Manipulation And Logic

  Posted on Jun 29, 2007 at 5:59 AM

  I'm an even bigger eejit, that won't work - must loop backwards: <cfscript> qMyQuery.AfterLast(); while(qMyQry.Previous()) { if(qMyQry.GetString(sColName) EQ sCondition) qMyQry.RemoveRows(javacast('int',qMyQry.getRow() -1), javacast('int',1)); } </cfscript>... read more »

• Using ColdFusion Query's Underlying Java Methods For Query Manipulation And Logic

  Posted on Jun 29, 2007 at 5:55 AM

  I'm an eejit, this is far better: <cfscript> while(qMyQry.Next()) { if(qMyQry.GetString(sColName) EQ sCondition) qMyQry.RemoveRows(javacast('int',qMyQry.getRow() -1), javacast('int',1)); } </cfscript>... read more »

• Using ColdFusion Query's Underlying Java Methods For Query Manipulation And Logic

  Posted on Jun 28, 2007 at 2:32 PM

  Great info and code dude, thanks. I've always found looping queries in cfscript a bit clunky, with this info however, you can do something like this: <cfscript> qMyQry.afterLast(); do { qMyQry.previous(); // condition met... qMyQry.RemoveRows(javacast('int',qMyQr... read more »