Community Member Profile

Recent Blog Comments By David

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on Nov 20, 2010 at 6:49 PM

  @Ben, value="hyperlink( ""your_url_here"" )" Works great thanks...... read more »

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on Nov 20, 2010 at 4:20 PM

  Hey, I'm trying to add a clickable url string value in a cell. I think POI supports it with hyperlink(url,displayText) where displayText is optional. I've tried a few things including this but no joy: <poi:cell value="hyperlink(read more »

• Ask Ben: Creating A Fixed-Field-Width Data File With ColdFusion

  Posted on Sep 30, 2009 at 2:34 AM

  once again Ben saves the day, cheers man!... read more »

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

  Posted on Aug 14, 2009 at 1:03 PM

  Thanks Alex, i think this may still be on-topic, as lot of developers will want to avoid Null fields after reading this blog. Knowing how to specify default values in SQL is surely the key? Your explanation on how to create columns with default values is great thanks, and will be very usefu... read more »

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

  Posted on Aug 14, 2009 at 10:14 AM

  Does anyone know how to set a default value using Alter Table sql. ALTER TABLE addresses add city varchar(64) default noCity is not working: Throws: ][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement. CF 8, Access DB Thanks... read more »

• My First ColdFusion 8 CFFTP Experience - Rocky But Triumphant

  Posted on May 5, 2009 at 5:38 PM

  Thanks Ian for your post. you saved me a lot of hair, ie. The biggest thing I ran into when I upgraded to CF 8 was that CF 8 required the connection attribute but the error you get without it "Null, Null" doesn't give you a clue that that is the problem... read more »

• ColdFusion / SQL Error: Invalid Precision Value

  Posted on Feb 25, 2009 at 6:04 AM

  great thanks Ben, you saved the day again!... read more »