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.”

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate. He focuses on JavaScript, serverless 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

Comments