Community Member Profile

Recent Blog Comments By Tom

• My First ColdFusion 8 CFFTP Experience - Rocky But Triumphant

  Posted on Sep 23, 2009 at 2:38 PM

  @Terri, The most common problem people have with uploading files in CF is they fail to account for the cffile variable. This article sums it up pretty nicely: http://www.quackit.com/coldfusion/tutor... read more »

• Steven Levithan Rocks Hardcore (Regular Expression Optimization Case Study)

  Posted on Aug 13, 2009 at 12:08 PM

  @Ben, Okay, so I've got this thing working, or so I think. The csv file has 18k rows and 11 columns (3mb file/ 3,083,493 chars with spaces). The process takes about 30 seconds per 1000 records which is nowhere near the performance levels you presented in the beginning of this thread and i... read more »

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

  Posted on Aug 5, 2009 at 2:08 PM

  @Ben, Sorry Ben, I didn't see your reply until BYJ just replied. I ended up using the cfparam approach and it worked (removing the isDefinedValueMX udf).... read more »

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

  Posted on May 7, 2009 at 9:02 AM

  @Ben Nadel, Yes. Based on my understanding of the way arrays work, if the array is empty it doesn't really exists (e.g. /start Array[1][1] = "Adam" Array[1][2] = "Microsoft Server 2003" Array[1][3] = [empty string] Array[1][4] = "Module 1" ... Array[1... read more »

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

  Posted on May 6, 2009 at 1:29 PM

  @Ben, I love it when I see your site show up in Google Search results as I know I'm heading in the right direction. Dave (Apr 16, 2009 at 5:01 PM) issue is what brought me here, I believe, which utlimately displayed your CSVToArray function. To Dave, I suspect you are looping over your Ar... read more »

• Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set

  Posted on Jan 28, 2009 at 1:50 PM

  It looks like this post is about to go off in a tangent so I'll provide a little bit more insight to keep the focus on "how to display results with some weighted randomness." When I originally posted the question and since I was referencing Google's Adwords, I thought the question could be made... read more »

• Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set

  Posted on Jan 27, 2009 at 12:17 PM

  @Ben, Regarding the (N) and the relationship to accuracy, thanks for clarifying.... read more »

• Ask Ben: Selecting A Random Row From A Weighted, Filtered Record Set

  Posted on Jan 27, 2009 at 12:06 PM

  @Josh I, too, had tried the rand() function but came up with effectively an ineffective solution. The newid() is a great touch. I was wondering if randrange(1,10) would work but I haven't tried it yet. Thanks for the link, you approach is short and simple. @Ben, Your details w... read more »

• My First ColdFusion 8 CFFTP Experience - Rocky But Triumphant

  Posted on Oct 28, 2008 at 9:12 AM

  To Todd and other readers, the purpose of naming your connection is so that you actually know which connection to refer to when making calls (e.g. lets say you have multiple FTP calls happening simutaneously). If you allow CF to create/name the call, you wont know which one to refer to during mu... read more »

• First Attempt At Excel Document Formatting Hooks Using ColdFusion And POI

  Posted on Mar 15, 2007 at 11:07 AM

  How funny I found two solutions I needed from your web site, two days apart! I also wanted to offer you my condolences on your father's passing. I'm sure you are making him proud. Now to my question, can you post what became of your inquiry to Alan about feeding the formatted xls (se... read more »

• Ask Ben: Displaying A Query Vertically Instead Of Horizontally

  Posted on Mar 15, 2007 at 9:50 AM

  Thanks for the help, err. the code. I wasn't able to solve the problem but you sure did! I look forward to seeing your posts in the other TAGS .... read more »

• Ask Ben: Displaying A Query Vertically Instead Of Horizontally

  Posted on Mar 14, 2007 at 8:54 AM

  I'm having trouble substituting a query in place of the number array you setup. I'm getting the right number of rows/columsn but as soon as I put the cfquery tag in, the output is wrong. I'm assuming I need to replace one of the cfloops with my cfoutput statements.... read more »