ColdFusion Error - Error Executing Database Query

Sites using MySQL databases and the cfqueryparam tag will see the following error message:

CF Error: Error Executing Database Query. Communication link failure: Unknown command

The error will point to a line within the site's code containing a database query. That line will have something like this in it:

WHERE example =
cfsqltype='cf_sql_varchar'>

This can be fixed by changing the code to remove the cfqueryparam tag. For this example, this would be changed to:

WHERE example = '#examplevalue#'

Please note: this only affects sites running under Cold Fusion 7.0.2.

Add Feedback