<?xml version="1.0" encoding="utf-8"?>
			
			<rss version="2.0">
			<channel>
			<title>Rob Brooks-Bilson&apos;s Blog - Blogging</title>
			<link>http://www.brooks-bilson.com/blogs/rob/index.cfm</link>
			<description>A blog for ColdFusion and other topics by Rob Brooks-Bilson, author of the O&apos;Reilly book Programming ColdFusion MX</description>
			<language>en-us</language>
			<pubDate>Thu, 09 Sep 2010 11:35:59 -0400</pubDate>
			<lastBuildDate>Sun, 20 Jul 2008 18:23:00 -0400</lastBuildDate>
			<generator>BlogCFC</generator>
			<docs>http://blogs.law.harvard.edu/tech/rss</docs>
			<managingEditor>rbils@amkor.com</managingEditor>
			<webMaster>rbils@amkor.com</webMaster>
			
			
			
			
			
			<item>
				<title>Moderating Comments</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2008/7/20/Moderating-Comments</link>
				<description>
				
				Due to the amount of comment spam getting by the captcha these days, I&apos;ve decided to remove the captcha and instead turn on moderated comments.  I hate to have to do this, but the amount of comment spam was starting to get ridiculous, and I really hate to see people who have left legitimate comments on the blog get hammered by spammers.

So, please stick with me while I transition to moderated comments.  I&apos;ll try to get legitimate comments approved as quickly as possible. If your comment doesn&apos;t show up right away, don&apos;t worry, I haven&apos;t forgotten about you, and I certainly won&apos;t censor non-spam comments.
				
				</description>
						
				
				<category>Misc</category>				
				
				<category>Blogging</category>				
				
				<pubDate>Sun, 20 Jul 2008 18:23:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2008/7/20/Moderating-Comments</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>Geexoo Aggregates ColdFusion Blogs</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2008/4/25/Geexoo-Aggregates-ColdFusion-Blogs</link>
				<description>
				
				I haven&apos;t seen this posted around the ColdFusion blogosphere, so here goes.  Looks like there&apos;s a &quot;new&quot; aggregator out there called &lt;a href=&quot;http://www.geexoo.com/&quot;&gt;Geexoo&lt;/a&gt; that&apos;s &lt;a href=&quot;http://www.geexoo.com/t/cold_fusion_1.html&quot;&gt;hosting ColdFusion feeds&lt;/a&gt; (although they spell it Cold Fusion).  

Right now, they are only aggregating 4 CF blogs, including Ray Camden&apos;s.
				
				</description>
						
				
				<category>Blogging</category>				
				
				<category>ColdFusion</category>				
				
				<pubDate>Fri, 25 Apr 2008 12:10:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2008/4/25/Geexoo-Aggregates-ColdFusion-Blogs</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>Resources for New ColdFusion Developers</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/10/3/Resources-for-New-ColdFusion-Developers</link>
				<description>
				
				Dave Shuck had a &lt;a href=&quot;http://www.daveshuck.com/blog/index.cfm/2006/10/3/Is-ColdFusion-harming-itself&quot;&gt;great post today&lt;/a&gt; that discussed the seeming lack of content focused on helping those new to ColdFusion development.  Inspired by his post, I decided to put together a list of online resources that contain lots of good information, geared toward those who are new to ColdFusion.

&lt;strong&gt;Getting Started Tutorials from Adobe&lt;/strong&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/guide_content.html&quot;&gt;Getting Started Guide to ColdFusion MX 7 and Its Resources&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/connecting_database.html&quot;&gt;Connecting to a Database with ColdFusion MX 7&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/display_dyn_data.html&quot;&gt;Displaying Database Data on a Web Page&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/rd_cf.html&quot;&gt;Multimedia Tutorial Series: Building Your First Database Application with ColdFusion MX 7&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/cfwak_2_5_6.html&quot;&gt;ColdFusion MX Web Application Construction Kit: Databases and SQL&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/adv_queries.html&quot;&gt;Building Advanced Queries in ColdFusion MX&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/beg_storedproc.html&quot;&gt;A Beginner&apos;s Guide to Using Stored Procedures with ColdFusion&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/stored_procs.html&quot;&gt;Learning Stored Procedure Basics in ColdFusion MX&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/ben_forta_faster.html&quot;&gt;Faster and safer database queries using the CFQUERYPARAM tag&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/validvariables.html&quot;&gt;Validating Input Parameters with ColdFusion&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.adobe.com/devnet/coldfusion/articles/richforms.html&quot;&gt;Creating Better Forms Faster with ColdFusion MX 7&lt;/a&gt;&lt;br /&gt;

&lt;strong&gt;Websites&lt;/strong&gt;&lt;br /&gt;
&lt;a href=&quot;http://livedocs.macromedia.com/coldfusion/7/&quot;&gt;Adobe ColdFusion MX 7 LiveDocs&lt;/a&gt; (documentation)&lt;br /&gt;
&lt;a href=&quot;http://www.cfquickdocs.com/&quot;&gt;CF QuickDocs&lt;/a&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.coldfusioncookbook.com&quot;&gt;ColdFusion Cookbook&lt;/a&gt; (problems/solutions)&lt;br /&gt;
&lt;a href=&quot;http://www.cflib.org/&quot;&gt;CFLib&lt;/a&gt; (UDFs)&lt;br /&gt;
&lt;a href=&quot;http://www.easycfm.com&quot;&gt;EasyCFM&lt;/a&gt; (tutorials, reviews, forums, community)&lt;br /&gt;
&lt;a href=&quot;http://www.houseoffusion.com&quot;&gt;House Of Fusion&lt;/a&gt; (mailing lists, articles, tutorials)&lt;br /&gt;
&lt;a href=&quot;http://www.tek-tips.com/threadminder.cfm?pid=232&quot;&gt;Tek-Tips Forums&lt;/a&gt;&lt;br /&gt;

&lt;strong&gt;Blogs&lt;/strong&gt;&lt;br /&gt;
&lt;a href=&quot;http://ray.camdenfamily.com&quot;&gt;Ray Camden&apos;s Blog&lt;/a&gt; (general tips, guides, ask a jedi series)&lt;br /&gt;

&lt;strong&gt;Listservers&lt;/strong&gt;&lt;br /&gt;
&lt;a href=&quot;http://www.houseoffusion.com/groups/cf-newbie/&quot;&gt;CF-Newbie Listserv&lt;/a&gt;&lt;br /&gt;

While this list is by no means exhaustive, if you know of any other sites that should be here, let me know and I&apos;ll be happy to add them.

Also, more to Dave&apos;s point - while a list like this is a good starting point for nudging new developers in the right direction, what&apos;s really needed is more blog and list content geared toward new and lesser experienced developers.  Taking that to heart, I&apos;m planning to do more blogging geared toward the beginner crowd.
				
				</description>
						
				
				<category>Blogging</category>				
				
				<category>ColdFusion</category>				
				
				<pubDate>Tue, 03 Oct 2006 16:15:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/10/3/Resources-for-New-ColdFusion-Developers</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>Another blogCFC Upgrade Gotcha</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/7/24/Another-blogCFC-Upgrade-Gotcha</link>
				<description>
				
				Over the weekend, I noticed that several of my older blog posts weren&apos;t showing up when I searched for them on my site.  After a little more digging, I found that several hundred seemed to be missing.  I couldn&apos;t get to them via a search, by date, or even by their UUID directly in the URL.  I checked the database tables, and sure enough they were there.

After a little more digging, it turns out the problem has to do with having upgraded from blogCFC 3.x to 4.x to 5.x.  Along the upgrade path, changes there were several additions to the blogCFC database, as well as the core CFC code.  One of those changes introduced a new field in the tblBlogEntries table called username.  The username is supposed to contain the username of the person making the blog entry.  In my case, all  &quot;new&quot; blog entries from blog CFC 4.x on had a value in this field.  Older entries, from the blogCFC 3.x days didn&apos;t.  Instead, they were NULL. This caused the main method in blogCFC.cfc to return no results for entries with NULL for the username.  You can see why in the WHERE clause for the getEntry method:

&lt;code&gt;
where	tblblogentries.id = &lt;cfqueryparam value=&quot;#arguments.id#&quot; cfsqltype=&quot;CF_SQL_VARCHAR&quot; maxlength=&quot;35&quot;&gt;
and	tblblogentries.blog = &lt;cfqueryparam value=&quot;#instance.name#&quot; cfsqltype=&quot;CF_SQL_VARCHAR&quot; maxlength=&quot;50&quot;&gt;
and	tblblogentries.username = tblusers.username
&lt;/code&gt;

Once I made an entry in the username column for all of my &quot;legacy&quot; entries, all of the posts started showing up as expected.
				
				</description>
						
				
				<category>blogCFC</category>				
				
				<category>Blogging</category>				
				
				<category>Announcements</category>				
				
				<category>ColdFusion</category>				
				
				<pubDate>Mon, 24 Jul 2006 15:29:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/7/24/Another-blogCFC-Upgrade-Gotcha</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>Blog Updated to blogCFC 5.1.001</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/7/18/Blog-Updated-to-blogCFC-51001</link>
				<description>
				
				It took all weekend, but I was finally able to get my blog updated to the (almost) latest version of &lt;a href=&quot;http://www.blogcfc.com&quot;&gt;blogCFC&lt;/a&gt;.  It looks like I wasn&apos;t the only one who had a &lt;a href=&quot;http://www.forta.com/blog/index.cfm/2006/7/17/Blog-Updated-To-BlogCFC-51&quot;&gt;hard time&lt;/a&gt; with the upgrade.  Admittedly, my troubles were all self inflicted as I had quite a bit of customization to both the look and feel, and some code I had in place to manage two blogs from a single codebase.  

If you don&apos;t use &lt;a href=&quot;http://winmerge.sourceforge.net/&quot;&gt;WinMerge&lt;/a&gt;, I suggest taking a look.  Without a diff/merge tool like this, it would have taken me a heck of a lot longer to perform the upgrade.

So far, everything with 5.1 seems to be working ok.  I had some errors from the Yahoo slurp spider trying to follow my Print links.  Not sure why it&apos;s doing that as the links are clearly labeled NOFOLLOW.
				
				</description>
						
				
				<category>blogCFC</category>				
				
				<category>Blogging</category>				
				
				<category>Announcements</category>				
				
				<category>ColdFusion</category>				
				
				<pubDate>Tue, 18 Jul 2006 10:05:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/7/18/Blog-Updated-to-blogCFC-51001</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>Reminder:  CFUNITED Flickr Pool</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/6/26/Reminder--CFUNITED-Flickr-Pool</link>
				<description>
				
				Just a reminder for folks headed to &lt;a href=&quot;http://www.cfunited.com/&quot;&gt;CFUNITED&lt;/a&gt; (and those watching from home), there&apos;s an active &lt;a href=&quot;http://www.flickr.com/groups/cfunited/&quot;&gt;Flickr Pool&lt;/a&gt; where you can post and view photos from the event as well as post messages.  The group currently contains a lot of photos from last year&apos;s event, and I&apos;m hoping it&apos;s just as popular this year!
				
				</description>
						
				
				<category>Blogging</category>				
				
				<category>Announcements</category>				
				
				<category>CFUnited</category>				
				
				<pubDate>Mon, 26 Jun 2006 17:04:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/6/26/Reminder--CFUNITED-Flickr-Pool</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>The Best of CFGURU</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/6/5/The-Best-of-CFGURU</link>
				<description>
				
				Other than a &lt;a href=&quot;http://www.horwith.com/index.cfm?mode=entry&amp;entry=A1144F6E-E081-0478-47D20828C74DAC4C&quot;&gt;blog post&lt;/a&gt; by &lt;a href=&quot;http://www.horwith.com/&quot;&gt;Simon Horwith&lt;/a&gt;, I haven&apos;t seen much chatter regarding the new &lt;a href=&quot;http://www.cfguru.org&quot;&gt;CFGURU blog&lt;/a&gt;.  The CFGURU blog is a companion site to the private CFGURU mailing list.  The site is moderated by &lt;a href=&quot;http://www.shlomygantz.com/&quot;&gt;Shlomy Gantz&lt;/a&gt;, with a charter to share useful discussions from the mailing list with the ColdFusion community at large. 

There are currently only a handful of posts on the site, but you can expect a lot more great content as Shlomy compiles and publishes posts from the list.
				
				</description>
						
				
				<category>Misc</category>				
				
				<category>Blogging</category>				
				
				<category>Announcements</category>				
				
				<category>ColdFusion</category>				
				
				<pubDate>Mon, 05 Jun 2006 16:26:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/6/5/The-Best-of-CFGURU</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>New Stats in blogCFC 4.03</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/1/20/New-Stats-in-blogCFC-403</link>
				<description>
				
				In case you missed the &lt;a href=&quot;http://ray.camdenfamily.com/index.cfm/2006/1/20/BlogCFC-403-Released&quot;&gt;announcement&lt;/a&gt;, Ray Camden released version 4.03 of blogCFC.  Included in the point release is an updated stats template I worked on that has the addition of a linked table of contents as well as stats about TrackBacks.
				
				</description>
						
				
				<category>blogCFC</category>				
				
				<category>Blogging</category>				
				
				<category>ColdFusion</category>				
				
				<pubDate>Fri, 20 Jan 2006 14:54:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2006/1/20/New-Stats-in-blogCFC-403</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>The Top ColdFusion Blog Posts of 2005</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2005/12/23/The-Top-ColdFusion-Blog-Posts-of-2005</link>
				<description>
				
				Waxing nostalgic this week, I spent some time looking over some  of what I considered the best ColdFusion related blog posts of 2005.  These posts represent my own personal slant.  They&apos;ve been culled from some of the most popular ColdFusion bloggers out there.  Here they are in no particular order:

&lt;a href=&quot;http://www.d-ross.org/index.cfm?objectid=2EC8FF78-EF49-4E45-CDFEF2DA7F393A25&quot;&gt;Factory vs. Service Locator vs. IoC/DI&lt;/a&gt; | Dave Ross

&lt;a href=&quot;http://clearsoftware.net/index.cfm?mode=entry&amp;entry=33C8370A-E081-2BAC-69489A4F0A7A3576&quot;&gt;ColdSpring vs. Anemic Domains: DAO is Good!&lt;/a&gt; | Joe Rinehart

&lt;a href=&quot;http://www.corfield.org/blog/index.cfm/do/blog.entry/entry/If_It_Walks_and_Talks&quot;&gt;If It Walks and Talks...&lt;/a&gt; | Sean Corfield

&lt;a href=&quot;http://www.barneyb.com/blog/archives/000580.jsp&quot;&gt;Designing an OO Backend&lt;/a&gt; | Barney Boisvert

&lt;a href=&quot;http://clearsoftware.net/index.cfm?mode=entry&amp;entry=3D094697-E081-2BAC-6954375379A8F68A&quot;&gt;The Pattern Prerequisite is Pain&lt;/a&gt; | Joe Rinehart

&lt;a href=&quot;http://www.corfield.org/blog/index.cfm/do/blog.entry/entry/Asynchronous_Development__Things_to_Consider&quot;&gt;Asynchronous Development - Things to Consider&lt;/a&gt; | Sean Corfield

&lt;a href=&quot;http://ray.camdenfamily.com/index.cfm/2005/8/30/Ask-a-Jedi-ColdFusion-Components-and-Validation&quot;&gt;Ask a Jedi: ColdFusion Components and Validation&lt;/a&gt; | Ray Camden

&lt;a href=&quot;http://www.corfield.org/blog/index.cfm/do/blog.entry/entry/Sharing_Application_Scope&quot;&gt;Sharing Application Scope&lt;/a&gt; | Sean Corfield

&lt;a href=&quot;http://www.mattwoodward.com/blog/index.cfm?commentID=78&quot;&gt;What&apos;s an Object?&lt;/a&gt; | Matt Woodward

&lt;a href=&quot;http://www.corfield.org/blog/index.cfm/do/blog.entry/entry/Too_Small_For_A_Framework&quot;&gt;Too Small For A Framework?&lt;/a&gt; | Sean Corfield

&lt;a href=&quot;http://www.mattwoodward.com/blog/index.cfm?commentID=107&quot;&gt;DAOs and Composition&lt;/a&gt; | Matt Woodward

&lt;a href=&quot;http://clearsoftware.net/index.cfm?mode=entry&amp;entry=4492E3A9-E081-2BAC-6969DBF6739A5A92&quot;&gt;CFCs, Cohesion, and Where I&apos;ve Gone Wrong&lt;/a&gt; |Joe Rinehart

&lt;a href=&quot;http://cdscott.blogspot.com/2005/11/coldspring-aop-tutorial-part-two.html&quot;&gt;ColdSpring AOP Tutorial ? Part Two, Around Advice&lt;/a&gt; | Chris Scott
 
&lt;a href=&quot;http://cdscott.blogspot.com/2005/10/coldspring-aop-tutorial-part-one.html&quot;&gt;ColdSpring AOP Tutorial ? Part One&lt;/a&gt; | Chris Scott

&lt;a href=&quot;http://www.daveshuck.com/index.cfm?commentID=57&quot;&gt;Head First Design Patterns SimUDuck in ColdFusion&lt;/a&gt; | Dave Shuck

&lt;a href=&quot;http://www.talkingtree.com/blog/index.cfm/2005/11/16/HowColdFusionRequestsProcess&quot;&gt;How ColdFusion Receives and Processes Requests&lt;/a&gt; | Steven Erat

&lt;a href=&quot;http://www.web-relevant.com/blogs/cfobjective/index.cfm?mode=entry&amp;entry=F2BEA2B4-BDB9-5320-E5C3E71176231252&quot;&gt;nOOb&apos;s Composition (or How to Avoid an Ungainly Inheritance)&lt;/a&gt; | Jared Rypka-Hauer

&lt;a href=&quot;http://www.web-relevant.com/blogs/cfobjective/index.cfm?mode=entry&amp;entry=D045D211-BDB9-5320-E97301A93C972448&quot;&gt;What&apos;s Wrong With the F-Word?&lt;/a&gt; | Jared Rypka-Hauer

I know not everyone may agree with me here, and that&apos;s fine.  I&apos;m also sure I left out quite a few good posts.  To those of you I may have omitted, no offense is meant!  If there&apos;s something I missed here that you feel should be on the list, leave me a comment!
				
				</description>
						
				
				<category>Blogging</category>				
				
				<category>ColdFusion</category>				
				
				<pubDate>Fri, 23 Dec 2005 17:03:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2005/12/23/The-Top-ColdFusion-Blog-Posts-of-2005</guid>
				
			</item>
			
		 	
			
			
			<item>
				<title>BlogCFC Tip:  Including Code</title>
				<link>http://www.brooks-bilson.com/blogs/rob/index.cfm/2005/12/8/BlogCFC-Tip--Including-Code</link>
				<description>
				
				If you&apos;re a blog CFC user, you&apos;re probably aware that you can easily include code snippets in your posts by surrounding the code with &amp;lt;code&amp;gt;...&amp;lt;/code&amp;gt;.  What you may not be aware of is how auto-formatting is handled within the code blocks.  Take the following two examples:

Example 1:
&lt;code&gt;
&lt;cfif arraylen(results.len) is 0&gt;
  &lt;cfset arrayappend(results.len, 0)&gt;
  &lt;cfset arrayappend(results.pos, 0)&gt;
&lt;/cfif&gt;
&lt;/code&gt;

Example 2:
&lt;code&gt;
&lt;cfif arraylen(results.len) is 0&gt;
	&lt;cfset arrayappend(results.len, 0)&gt;
	&lt;cfset arrayappend(results.pos, 0)&gt;
&lt;/cfif&gt;
&lt;/code&gt;

At first glance, you&apos;re probably thinking &quot;what&apos;s the big deal?  The first example has no indenting and the second one does&quot;.  You would be partially right.  What isn&apos;t obvious at first glance, though, is that both code example I posted DO have indenting.  The difference is the first example indents using spaces while the second one uses tabs.  The color coding method used by blogCFC will only auto-indent code that&apos;s been indented using tabs.  

I know people debate the tabs vs. spaces issue all the time.  Bottom line here, though, is that if you want to have your code intented in blogCFC, you&apos;ll need to make sure your IDE uses tabs and not spaces for indents.
				
				</description>
						
				
				<category>blogCFC</category>				
				
				<category>Blogging</category>				
				
				<category>ColdFusion</category>				
				
				<pubDate>Thu, 08 Dec 2005 17:31:00 -0400</pubDate>
				<guid>http://www.brooks-bilson.com/blogs/rob/index.cfm/2005/12/8/BlogCFC-Tip--Including-Code</guid>
				
			</item>
			
		 	
			</channel></rss>