Error after applying CF2021 Update 2 and CF2018 Update 12 : The IndexOf method was not found

[moalspvic]

We recently updated two customers with the latest security hotfix, Coldfusion 2021 Standard Update 2 and Coldfusion 2018 Update 12 Enterprise.

After applying the update portions of our code broke.  We need to know if this is an unsupported feature, a deprecated feature, or a bug in each of the updates. 

This code allows us to reference a value within a query using the underlying Java method IndexOf and prior to the updates, has worked correctly since Coldfusion 9.

Code: getCCRepairs["MAP_CustID"].IndexOf(JavaCast("string","#session.MAP_CustID#"))

    :: getCCRepairs is a Query 

    :: object "MAP_CustID" is a column in the query object

    :: #session.MAP_CustID# is a variable that contains the current value of MAP_CustID

Error: The IndexOf method was not found

I can confirm that this is related to each of the updates and previous versions/updates are not affected and work as expected.

Have any of you experienced this?  Any thoughts?  

I appreciate your help.

[BKBK · Accepted solution]

The issue you face looks similar to the toArray() issue reported earlier. There, the following line of code broke when CF2018 Update 12 or CF2021 Update 2 were installed:

<cfset myQueryColumnArray=myQuery["myColumn"].toArray()>

Adobe confirmed it is a bug, and has fixed it. It might be worth your while to request a hotfix from them: cfinstal[at]adobe.com

[moalspvic]

Thank you BKBK.  I have been chatting / emailing with Ravi at cfsup@ in hopes of a resolution.  I will share this with him to get his thoughts.

I appreciate your follow-up.  Thanks!

[Greg P]

@moalspvic, do you have any updates on this issue? We are upgrading our servers as well and just ran into this issue.

[moalspvic · Accepted solution]

@Greg P   There is a hotfix which addressed the bug we encounted.  If you reach out to cfsup@adobe.com, they will provide you with the patch that is applicable to your version of CF.

I hope that this helps.