BlogCFC 5.9.4.001

I just pushed up a minor update to 5.9.4. Release notes are below.

/org/camden/blog/blog.cfc - Fix to rss code to not output image stuff if the itunesimage value not specified
/org/camden/blog/blog.cfc - case sensitivity issue for mysql fixed
/client/stats.cfm - Added numerFormat around most stats. Makes the #s a bit nicer.
/client/admin/settings.cfm - Support setting Use cfFormProtect (thanks Todd Sharp!)

Upcoming changes:

My next update will be to add metadata keyword/description support for the blog entry/blog category level. The flow will be: If keyword/desc defined for entry, use it. Else check category. Finally use the default settings.

TweetBacks
Comments
todd sharp's Gravatar I should mention that it doesn't seem to be 'enough' to just enable cfformprotect. You'll need to tweak some settings too.

This blog post from Aaron West helped make it really easy for me:

http://www.trajiklyhip.com/blog/index.cfm/2009/6/2...

Yeah, you probably mention this in your docs, but who reads the docs?

Thanks Ray, we <3 blogcfc
# Posted By todd sharp | 9/2/09 9:26 AM
Raymond Camden's Gravatar It was my understanding - and I'm definitely not 100% sure on this - that enabling CFP turns on SOME features of CFP. I know I've tested this before and seen it catch things like 'too many urls in a comment'. So I think it DOES work out of the box, but you _can_ configure even more stuff to make it tighter.

Am I wrong?
# Posted By Raymond Camden | 9/2/09 9:28 AM
todd sharp's Gravatar Yeah, you get "some" protection I think. But, mine was already on yesterday morning when I got about 300 spam comments. So, that's how good it works "out of the box" (not so good). Once I tweaked they stopped all together.
# Posted By todd sharp | 9/2/09 9:46 AM
Doug Ward's Gravatar Just a note. The Oracle build script doesn't include the new tables (TBLBLOGROLES,TBLUSERROLES), nor the added column to the TBLUSERS table (Blog).
# Posted By Doug Ward | 9/11/09 10:22 AM
Raymond Camden's Gravatar Feel free to add that and I'll check it in. :)
# Posted By Raymond Camden | 9/11/09 10:32 AM
Dean Bunting's Gravatar Issue with getComment(s) and Oracle:

CF query of query doesn't like clob fields. Oracle's to_char returns a varchar2, which supports a max 4000 bytes. Older versions would automatically truncate, but newer versions will throw an error when the content is greater than 4000. I've found only the following to work correctly...
<code>
<cfif instance.blogDBTYPE is NOT "ORACLE">tblblogcomments.comment<cfelse>to_char(dbms_lob.substr(tblblogcomments.comments,4000,1)) as comments</cfif>
</code>
# Posted By Dean Bunting | 10/29/09 11:12 AM
BlogCFC was created by Raymond Camden. This blog is running version 5.9.6.001. Contact Blog Owner