Mickey

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 h... 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 »