CF 2016 Update 17 errors

I am getting the following messages after applying cf 2016 update 17:

Invalid attribute value cf_sql_int for attribute CFSQLType

any ideas?

This topic has been closed for replies.

Correct answer George____

Hard to tell without any code, but my guess is that you're using cf_sql_int in a cfqueryparam. Take a look at https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfqueryparam.html that's not a valid value for the CFSQLType attribute. You need to use cf_sql_integer instead.

Invalid CFSQLTypes used to get treated as CF_SQL_CHAR, but at some point that behaviour changed to where they're now treated as invalid.

George____Correct answer

Inspiring

Hard to tell without any code, but my guess is that you're using cf_sql_int in a cfqueryparam. Take a look at https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfqueryparam.html that's not a valid value for the CFSQLType attribute. You need to use cf_sql_integer instead.

Invalid CFSQLTypes used to get treated as CF_SQL_CHAR, but at some point that behaviour changed to where they're now treated as invalid.

Sign up