Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since Dec 11, 2008

Recent Blog Comments By Steve

  • Converting ISO Date/Time To ColdFusion Date/Time

    Posted on Jan 29, 2013 at 4:42 PM

    Usually when it comes to finding a better function my google searches are usually Ben Nadel _______________ This is great to find a post from 2007, updated in late 2012 Thanks Ben, and Adam... read more »

  • Caution: ColdFusion Zero Date vs. SQL Zero Date

    Posted on Dec 2, 2010 at 4:24 PM

    It's worse than that.... in SQL Select @curDate = getDate() Select DATEADD(qq, DATEDIFF(qq,0,@curDate), 0) QuarterFirstDate, DATEADD(qq, DATEDIFF(qq,-1,@curDate), -1) QuarterLastDate, DATEADD(qq, DATEDIFF(qq,-1,@curDate), 0) NextQuarterFirstDate easy enough right? Well apparently SQL knows that 12/... read more »

  • ColdFusion 8 ImageResize() / ImageWrite() Bug?

    Posted on Jan 15, 2010 at 11:40 AM

    @Tim, > hosting company has confirmed they have installed it too. My ImageResize() code works great on my localhost... Well I guess there's only 2 things to assume here... Who's right and who's wrong :P (Working = right)... read more »

  • ColdFusion 8 ImageResize() / ImageWrite() Bug?

    Posted on Oct 2, 2008 at 1:44 PM

    After the newer cfimage related hotfixes is this still an issue? either the completely transparent gif, and or gif looses transparency?... read more »

  • CFERROR ColdFusion Error Template Will Not Catch Its Own Errors

    Posted on Aug 25, 2008 at 1:41 PM

    You may have some type of syntax cvalidation error, which I am noticing cfError will not handle. if your error is in an included file, then the include validate fails and it falls under "fail to include x file" and becomes a different type of error.... read more »

  • CSVToArray() ColdFusion UDF For Parsing CSV Data / Files

    Posted on Jun 2, 2008 at 11:18 AM

    @Chris You need to perform all your validation before attempting database insert. Say I want 5 columns... <cfif ArrayLen(arrData[i]) LT 5> <!--- Do Nothing, Exel empty line ---> <cfelseif NOT isnumeric(arrData[i][1])> <!--- error field ivalid data ---> <cfelse> Do dtaba... read more »

  • CSVToArray() ColdFusion UDF For Parsing CSV Data / Files

    Posted on May 30, 2008 at 4:33 PM

    @Chris The array will contain the number of fields that exist in that row, Some rows may be 3, some 1 , some 4 (1 and 3empty) What I do is when I am iterating over the array is I check that the array row has the number of fields I am expecting, then I do any data validation I expect on each field (n... read more »

  • CSVToArray() ColdFusion UDF For Parsing CSV Data / Files

    Posted on Jan 21, 2008 at 5:52 PM

    Since Excel does not use the backslash as an escape character, but instead escapes quote literals with two quotes, which does your regex use? I presume it is "" based on some of your writings, but I am no regex expert.... read more »

  • Stripping XML Name Spaces And Node Prefixes From ColdFusion XML Data (To Simplify XPath)

    Posted on Oct 24, 2007 at 5:18 PM

    Thanks for your article. It has the perfect solution I implemented (although I brute forced the namespace removal in a specific xml) Now I can use your function globally! However, with your code it leaves spaces after the nodename... <Envelope ><Body><GetSOListByCustomerIdResult &... read more »