BlogCFC Update

A user reported an issue with BlueDragon/MySQL. I was able to reproduce the issue. I used code like this:

,allowcomments = <cfqueryparam value="#arguments.allowcomments#" cfsqltype="CF_SQL_TINYINT">

Which worked fine under CFMX even when the value was a boolean. In BD, it seems as if the queryparam was a bit stricter, which seems to make sense. So I simply added this code (where applicable):

<cfif arguments.allowcomments>
   <cfset arguments.allowcomments = 1>
<cfelse>
   <cfset arguments.allowcomments = 0>
</cfif>

As a warning - watch those queryparams if building code that needs to run both on CFMX and BD. I won't say one is wrong and one is right - but there are definitely differences. Luckily, I've been able to tweak things to run nicely on both platforms w/o using any "hacks."

Archived Comments

Comment 1 by Brian posted on 6/8/2005 at 7:29 PM

Thanks for the fix!

Comment 2 by Michael Schmidt posted on 6/8/2005 at 8:21 PM

>> I won't say one is wrong and one is right

Of course one is right CFMX is the real thing and BD is the non-perfect copy.

Comment 3 by Raymond Camden posted on 6/8/2005 at 9:01 PM

Well, I don't know. I think I found 3 issues w/ queryparam, and in 2 of the cases it seemed like BD was being more precise, which I think is a good thing. In one case it was more vague as to why BD acted differently.