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>
<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
Thanks for the fix!
>> 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.
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.