Community Member Profile

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 »

• Ask Ben: Query Loop Inside CFScript Tags

  Posted on Jun 18, 2012 at 12:03 PM

  @Larry, Hehe and I can totally appreciate your posting name :P Lets see how many people have to look it up! (My friend was just showing me the open source sierra project a few minutes ago and we were reliving some 1980's glory!)... read more »

• Ask Ben: Query Loop Inside CFScript Tags

  Posted on Oct 30, 2011 at 11:16 PM

  @Chris, You need to do the set lastval = col If lastval neq curVal then do new groupset... read more »

• Ask Ben: Query Loop Inside CFScript Tags

  Posted on Mar 9, 2011 at 5:02 PM

  That is almost the same, except you are using a while loop instead of a for loop. http://www.petefreitag.com/cheatsheets/coldfusion/cfscript/ I would reach for a better grasp of th... 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 rig... 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 »

• Ask Ben: Query Loop Inside CFScript Tags

  Posted on Jun 16, 2009 at 3:10 PM

  You need to backdate our points from kinky posts :P err, umm, our kinky points from posts.... 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 »

• Reminder: Duplicate() Does Not Work With ColdFusion Images

  Posted on Sep 26, 2008 at 1:14 PM

  How about this. It seems to show duplicate DOES duplicate the image data, and I can change thm without changing the original, (I can also change the original without changing the thm) [code] <cfimage action="read" source="#photo#" name="objImage"> <cfset thm = Dupl... read more »

• Reminder: Duplicate() Does Not Work With ColdFusion Images

  Posted on Sep 26, 2008 at 12:35 PM

  Steve here: taking fault for having the thumbnail set problem :P Actually Ben has exposed something here that wasn't really my issue, Duplicate() seems to be working for ME LOL, My REAL issue was: if I read a file in with <cfimage action="read" name="myImage"> then de... 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 dat... 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 expec... read more »

• Ask Ben: Query Loop Inside CFScript Tags

  Posted on Jan 28, 2008 at 1:27 PM

  in cf7 at least while testing for 46028 records, 109-125ms <cfoutput query="qryTest"> #field1# </cfoutput> was faster than 172-219ms <cfscript> for(i=1; i lte qryGetAMFiles.recordcount; i=i+1) { writeOutput(qryTest.field1[i]... 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 »

• ColdFusion CFHttp To Query Much Faster Than Java Buffered Reader

  Posted on Jan 21, 2008 at 2:44 PM

  Do you think it was the reading of the file, or cfaddquery? what is the difference between the java buffered file reader and java.io.FileReader?... 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><G... read more »