Troy

Recent Blog Comments By Troy

• 19.0 Must Be Within Range: ( 1 : 12 )

  Posted on Nov 3, 2009 at 2:43 PM

  I recently had a similar ColdFusion error with no line number information to help: 11.0 must be within range: ( 1 : 7 ) The date in my Form variable was "11/11/2009" and I was doing this: DayOfWeekAsString(Day(Form.menu_dt) After finding this blog entry, I quickly discovered I was out of the ran... read more »

• cf.Objective() Photo Raffle With Me (Ben Nadel)

  Posted on May 21, 2009 at 11:48 AM

  so who won the prize?... read more »

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

  Posted on Oct 13, 2007 at 8:37 PM

  I found a dumb mistake in my code and now my TAB parsing works with Chr(9). I would like the final blank line to be ignored if it's a simple tweak Ben can make. But not a showstopper, and I'm grateful to Ben for all his help, good stuff!... read more »

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

  Posted on Oct 12, 2007 at 1:07 PM

  That's what I noted I tried in the first comment I made "Chr(9)". Maybe you need to translate that inside the UDF to "\t" in the places needed in your regex lines of code?... read more »

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

  Posted on Oct 12, 2007 at 12:07 PM

  I was using the double hash to escape them. I thought you wanted the single hashes passed into the UDF. Using your way, CF throws this error: Variable CHAR is undefined.... read more »

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

  Posted on Oct 12, 2007 at 11:40 AM

  Ok, I see there is a carraige return at the end of the final row of data in my CSV files and then a final line that is blank. After I removed the blank line, all was well. However, your old UDF seemed to account for this case and handled it gracefully, not putting the blank line into the array of a... read more »

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

  Posted on Oct 12, 2007 at 11:04 AM

  In the previous UDF, I would pass in "Chr(9)" for a TAB. This is not working now, nor is passing in "\t". What is needed in this new regex UDF to represent TAB? It looks like the example you show for overriding TAB delimiter just has a space " ". Also, I'm seeing an extra array element which is e... read more »