2 Correct answers
Try wrapping the value with toString() first, eg: toString(manager).split(",")[1]
--
Pete Freitag
I now suspect the error arises because ColdFusion is confusing the manager in variables scope with the manager in query scope. So, separate the concerns. For example, by introducing a new variable, currentManager, in variables scope.
To be clear, here's the suggestion in full
<cfloop query="Q_ADResults">
<cftry>
<cfset currentManager = trim(toString(Q_ADResults.manager[currentrow]))>
<cfif len(currentManager) gt 0>
<cfset mgr = currentManager.split(",")[1]/>
26
Replies
Like @aliaspooryorik , I too did a test on CFFiddle using Update 17 of ColdFusion 2021. There was no error.
<cfset manager ="John James Smith,Mary Jane Robinson">
<cfif len(trim(manager)) gt 0>
<cfset mgr = manager.split(",")[2]/>
<cfset mgr = mgr.substring(5,len(mgr))/>
<cfset mgr_middle_name = mgr.split(' ')[1]/>
<cfset mgr_last_name = mgr.split(' ')[2]/>
<cfelse>
<cfset mgr = ''/>
<cfset mgr_fname = ''/>
<cfset mgr_lname = ''/>
</cfif>
<cfoutput>
mgr_middle_name: #mgr_middle_name# <br>
mgr_last_name: #mgr_last_name#
</cfoutput>
Taking the hint from you, I ran the following code on CF2021 Update 17 on Cffiddle:
<cfset manager ="CN=Maria Guadalupe López,OU=Human Resources,OU=Nogales,OU=Mexico,OU=North America,OU=Domain Users,OU=Offices,DC=humanscale,DC=com">
<cfif len(trim(manager)) gt 0>
<cfset mgr = manager.split(",")[1]/>
<cfset mgr = mgr.substring(3,len(mgr))/>
<cfset mgr_fname = mgr.split(' ')[1]/>
<cfset mgr_mname = mgr.split(' ')[2]/>
<cfset mgr_lname = mgr.split(' ')[3]/>
<cfelse>
<cfset mgr = ''/>
<cfset mgr_fname = ''/>
<cfset mgr_mname = ''/>
<cfset mgr_lname = ''/>
</cfif>
<cfoutput>
mgr_fname: #mgr_fname# <br>
mgr_mname: #mgr_mname# <br>
mgr_lname: #mgr_lname# <br>
</cfoutput>
As you can see, it works as expected.
If you're still having an issue with this, then you will probably have to look elsewhere. For example, shouldn't the line
<cfset mgr = manager.split(",")[1]/>
be
<cfset mgr = Q_ADResults.manager.split(",")[1]/>
instead?
Hi Support,
Thanks for the suggestion. Unfortunately, we tried it, and still got the split method was not found error.
Thanks for your time.
Thanks for the suggestion. Unfortunately, we tried it, and still got the split method was not found error.
<cfloop query=#Q_ADResults#>By @patrick_8394
As I said, change that line to
<cfloop query="Q_ADResults">
and apply Pete's suggestion, too.
Charlie, my last post contains your suggestion. It is clear from my last post that the issue is caused by the variable manager calling the split method.
In fact, you can reproduce it yourself, using:
<cfset Q_ADResults = queryNew("manager","varchar", {manager="CN=Maria Guadalupe López,OU=Human Resources,OU=Nogales,OU=Mexico,OU=North America,OU=Domain Users,OU=Offices,DC=humanscale,DC=com"})>
<cfloop query="Q_ADResults">
<cftry>
<cfset mgr = manager.split(",")[1]/>
<cfcatch>
manager variable is of type:<cfoutput> #manager.getClass().getName()#</cfoutput> <br><br>
<cfdump var="#cfcatch#" label="cfcatch dump">
</cfcatch>
</cftry>
</cfloop>
The result is
The cause of the issue is that the method split() is being called by manager, which is not of String type. It is of type coldfusion.sql.QueryColumn.
Are you trying to assert in your code that you've found the exact cause and solution?
By @Charlie Arehart
Yes. My last post shows the cause: calling split() on an object of type coldfusion.sql.QueryColumn.
For a solution, see the above code containing the line
<cfset currentManager = trim(toString(Q_ADResults.manager[currentrow]))>
I don't see how your conclusion closes those considerations.
By @Charlie Arehart
The error is "The split method was not found". I just wanted to clear any questions about the root cause of the error.
AdChoices