Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Doug Hughes and Ezra Parker and Dan Wilson and John Mason and Jason Dean and Luis Majano and Mark Mandel and Brian Kotek and Wil Genovese and Rob Brooks-Bilson and Andy Matthews and Simeon Bateman and Ray Camden and Chris Rockett and Joe Bernard and Dan Skaggs and Byron Raines and Barney Boisvert and Simon Free and Steve 'Cutter' Blades and Seth Bienek and Katie Bienek and Jeff Coughlin
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Doug Hughes@doughughes ) , Ezra Parker , Dan Wilson@DanWilson ) , John Mason@john_mason_ ) , Jason Dean@JasonPDean ) , Luis Majano@lmajano ) , Mark Mandel@Neurotic ) , Brian Kotek , Wil Genovese@wilgeno ) , Rob Brooks-Bilson@styggiti ) , Andy Matthews@commadelimited ) , Simeon Bateman@simBateman ) , Ray Camden@cfjedimaster ) , Chris Rockett ( @RockettMan ) , Joe Bernard@JEBernard ) , Dan Skaggs@dskaggs ) , Byron Raines ( @byronraines ) , Barney Boisvert@barneyb ) , Simon Free@simonfree ) , Steve 'Cutter' Blades@cutterbl ) , Seth Bienek@sethbienek ) , Katie Bienek@KatieBienek ) , and Jeff Coughlin@jeffcoughlin )

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 »