CF 2016 Update 17 errors

New Here ,
May 02, 2021 May 02, 2021

Copy link to clipboard

Copied

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

Invalid attribute value cf_sql_int for attribute CFSQLType 

 

any ideas?

Views

49

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Explorer , May 03, 2021 May 03, 2021
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.

Likes

Translate

Translate
Explorer ,
May 03, 2021 May 03, 2021

Copy link to clipboard

Copied

LATEST

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines