Hire Me! I'm currently looking for my next role in developer relations and advocacy. If you've got
an open role and think I'd be a fit, please reach out. You can also find me
on LinkedIn.
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."