Sponsors

Links

Subscribe

Archives by Subject

• Lap Band Surgery

Earlier today someone suggested adding a tag cloud to ColdFusionBloggers. I'm just enough of a nerd to think that would be something fun to do Friday night. In the meantime, I whipped up a quick SQL statement and dumped the results into a structure and sorted it:

<cfquery name="cats" datasource="#application.dsn#">
select   categories
from   entries
where   year(posted) = 2008
and      categories != ''
</cfquery>

<cfset d = {}>
<cfloop query="cats">
   <cfloop index="c" list="#categories#">
      <cfif len(trim(c))>
         <cfif not structKeyExists(d, c)>
            <cfset d[c] = 0>
         </cfif>
         <cfset d[c]++>
      </cfif>
   </cfloop>
</cfloop>

<cfoutput>
#numberFormat(cats.recordcount)# entries.
<p/>
<table border="1" cellpadding="10" style="margin-top:0px;padding-top:0px;">
   <tr>
      <th> </th>
      <th>Tag</th>
      <th>Count</th>
   </tr>
</cfoutput>

<cfset sorted = structSort(d,"numeric", "desc")>

<cfloop index="x" from="1" to="#min(100,arrayLen(sorted))#">
   <cfset k = sorted[x]>
   <cfoutput>
   <tr>
      <td>#x#</td>
      <td>#k#</td>
      <td>#numberFormat(d[k])#</td>
   </tr>
   </cfoutput>
</cfloop>
<cfoutput></table></cfoutput>

Not the prettiest code in the world, but it worked. All 3 of you using copies of the CFB code base are welcome to it. And now the results. I've printed out the top 100. The top ten aren't surprising, especially #2. It almost matches exactly with what my top 10 concerns of year were (except for Lost of course!). ColdBox shows up rather high in the list, well over Model-Glue and Fusebox. I'm not surprised to see Mac at #17.

Anyway, enjoy the table-y goodness (need to find a simple, scrollable table for static data) and forgive the huge page size.

11,813 entries.

Comments (13) Jan 7, 2009 4:43 PM Views: 1389

Comments

haha I came in at No. 78... I know some folks who will find that amusing.. ;)

# Posted By Shane Zehnder | 1/7/09 5:03 PM

Cool stuff! thanks

# Posted By John Gag | 1/7/09 8:19 PM

Hmm - a simple, scrollable table you say? I have this book on ColdFusion by these really smart guys, Camden and Forta. Anyway there's this one chapter in the book where this Camden guy talks about cflayoutareas and cfpods. I think they scroll.

LOL

# Posted By Andy Sandefer | 1/7/09 8:37 PM

Andy! That was a brilliant idea. Unfortunately I can't use it here as the blog entries are entirely database driven, but I tried a simple cfpod with a height and it worked perfectly. I'll blog a quick example of this in a few minutes. I tend to dismiss cfpod as being kinda useless, but this was a perfect use of it.

# Posted By Raymond Camden | 1/7/09 10:00 PM

CFPod ...

Hmmm ... Kinda' Like Stats Pod ... Heh

;)

# Posted By Edward Beckett | 1/7/09 10:14 PM

@Ray: You started by mention "tag cloud". In my world a tag cloud looks like this <a href="http://www.smashingmagazine.com/images/tagclouds/p... Cloud Example</a>.

Another great example with code is here:
<a href="http://www.petefreitag.com/item/396.cfm">h...;

# Posted By Mikkel Johansen | 1/8/09 1:23 AM

Now with working links.

@Ray: You started by mention "tag cloud". In my world a tag cloud looks like this:
http://www.smashingmagazine.com/images/tagclouds/p...

Another great example with code is here:
http://www.petefreitag.com/item/396.cfm

# Posted By Mikkel Johansen | 1/8/09 1:26 AM

@Shane: Now I expect that in the 50s by next year. :)

# Posted By Todd Rafferty | 1/8/09 5:19 AM

@Mikkel: Oh yeah, if it wasn't clear, I wasn't trying to say my table was a cloud. The initial request from the user was for a cloud and that's what spurred me to just get the dats.

# Posted By Raymond Camden | 1/8/09 6:46 AM

@Todd: I will try to do better this year. ;)

# Posted By Shane Zehnder | 1/8/09 9:49 AM

Hey Ray, if you decide to go ahead and create a real tag cloud, there are a couple of free tools to help: tagcrowd.com and wordle.net. Just pass them the list of words (rather than aggregate them) and drop them in (or point to a URL). With the latter, it could be a dynamic, ever-changing cloud.

@Andy, are you saying there were only 2 smart guys on the author list for the book? :-(

# Posted By charlie arehart | 1/8/09 1:51 PM

@Charlie
It was kind of like the Oscars. If you try to thank everyone the orchestra just starts playing and cuts to commercial anyway. LOL, seriously though Ray did write the chapter I was talking about - I dusted the book off and checked last night. I've benefited from all of the talented folks who have co-authored CF books going back to the Macromedia MX editions. I've even learned a few tricks from some of your blogs and chapters! :)

# Posted By Andy Sandefer | 1/8/09 1:58 PM

@Andy, fair enough. It was hard for me to make any comment without sounding whiney. Lesson learned. :-) Thanks for the kind regards.

# Posted By Charlie Arehart | 1/8/09 4:03 PM