Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Kirsty Lansdell

Mickey

Member since Aug 25, 2010

Recent Blog Comments By Mickey

  • ColdFusion Component Wrapper For POI To Read And Write Excel Files

    Posted on Jun 8, 2011 at 5:54 PM

    Searching Ben's blog is a GREAT resource... I had not seen that error but I found this post http://www.bennadel.com/blog/624-ColdFusion-POIUtility-cfc-Updates-And-Bug-Fixes.htm and someone named Chad had that exact problem. Turned out to be some rogue text in the input excel sheet that was cau... read more »

  • ColdFusion Component Wrapper For POI To Read And Write Excel Files

    Posted on Jun 1, 2011 at 8:27 AM

    @Gabe, Yeah it's great isn't it?! I just updated one of those old HTML based sheets and it's a world of difference. Using the template file I now have company branding, landscape formatting, and just an overall MUCH better looking spreadsheet. The Hyperlink didn't work for me the first time I trie... read more »

  • ColdFusion Component Wrapper For POI To Read And Write Excel Files

    Posted on May 31, 2011 at 6:27 PM

    @Gabe You can do something like this: <poi:cell type="formula" value="hyperlink(""#variables.my_email#"",""#variables.my_email_disp#"")" style="color:blue;" />... read more »

  • Paginating Record Sets In ColdFusion With One SQL Server Call

    Posted on May 24, 2011 at 4:46 PM

    @Ben Just wanted to say THANKS for posting this. I know it was over 3 years ago but it really inspired me to re-design a dynamic report that was killing us. I wasn't so concerned with pagination, but I used the table variable as a "base query" to get the primary recordset, and then did m... read more »

  • ColdFusion Component Wrapper For POI To Read And Write Excel Files

    Posted on Apr 14, 2011 at 5:35 PM

    Update: I know this was frowned upon in an earlier post but I solved my rowheight problem by commenting the offending variable. I can't seem to find any reference to it anywhere else and things seem to work swimmingly without it. Here is what it looks like in row.cfm <!--- Get the row height p... read more »

  • ColdFusion Component Wrapper For POI To Read And Write Excel Files

    Posted on Apr 13, 2011 at 8:18 PM

    I love this utility! I wish I had this for my last release when I had to use HTML. Now they want it all prettied up so of course I came here to see what Ben had done to solve this. Glad I did! One problem... I too am getting the error setting the row height. I see one or two people asked about this... read more »

  • Using ColdFusion Query's Underlying Java Methods For Query Manipulation And Logic

    Posted on Aug 25, 2010 at 10:37 PM

    Oh this is awesome... and I don't use that word casually. I just used this logic to remove those pesky empty rows that show up on the last page of a CFGRID when the number of rows returned doesn't match up to your page size. Very Cool!! Thanks.... read more »