BlogCFC Update

This post is more than 2 years old.

I've updated BlogCFC with a few minor fixes. I didn't update the version number because, well, I forgot, and to be honest, it's a real minor update, but important for BlueDragon users. Anyway, here we go:

  • The error template wasn't working for BlueDragon. BD doesn't support the "rootcause" key in the error structure. They have noted this as a bug and it's already recorded.
  • BlueDragon was a bit tighter in the use of cfqueryparam under Access. This isn't a bug I believe - just something I think CFMX was loser on. Either way - it works in both now. :)
  • layout.cfm has a cfproc directive now.
  • mysql.sql specifies utf8 now instead of latin1

Enjoy.

Raymond Camden's Picture

About Raymond Camden

Raymond is a senior developer evangelist for Adobe. He focuses on document services, JavaScript, and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support. You can even buy me a coffee!

Lafayette, LA https://www.raymondcamden.com

Archived Comments

Comment 1 by Brian posted on 6/7/2005 at 11:39 PM

I'm trying your blog out on a Mac running BD 6.2 and mysql. It chokes on posting an entry...

Type Application
Function(s) addEntry
Detail Data not supported
Tag Context CFIF: Line=77; Column=1
|
+-- CFIF: Line=129; Column=2
|
+-- CFIF: Line=130; Column=3
|
+-- CFELSE: Line=132; Column=3
|
+-- CFSET: Line=133; Column=4
|
+-- CFFUNCTION: Line=215; Column=27
|
+-- CFQUERY: Line=227; Column=3
|
+-- CFIF: Line=245; Column=8
|
+-- CFELSE: Line=247; Column=7
|
+-- CFQUERYPARAM: Line=248; Column=6
Source
245: <cfif instance.blogDBType is not "MYSQL">
246: <cfqueryparam value="#arguments.allowcomments#" cfsqltype="CF_SQL_BIT">
247: <cfelse>
248: <cfqueryparam value="#arguments.allowcomments#" cfsqltype="CF_SQL_TINYINT">
249: </cfif>
^ Snippet from underlying CFML source

Hope to get this going. It looks promising.

Comment 2 by Raymond Camden posted on 6/7/2005 at 11:42 PM

Are you using the very latest build? I updated it in the last hour.

Comment 3 by Brian posted on 6/8/2005 at 5:43 AM

Hi again. I downloaded the latest one, installed it, deleted the database and reapplied the mysql script. It still errors out at the same spot. I'm running BD 6.2, mysql 4.1.12 on OS X 10.2.8. Has anyone else gotten it to work with this setup? I can email you the a link to my set up so you can try it, if you have the time. I just want it to work for Mac users similiar to my set up.

Thanks!

Comment 4 by Raymond Camden posted on 6/8/2005 at 6:22 PM

I've confirmed the bug and will try to get it fixed asap.