Skip to main content


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 »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
Ben Nadel