Element CF022 is undefined in a CFML structure referenced as part of an expression

Forum|Forum|17 years ago
October 16, 2008
6 replies
3543 views

I have a structrue called vRollCodes. It is defined and has a single key,value pair stored in it... i.e.,

<cfdump var=#Request.vSurveyLmicodes#>
CF022 | NY

but when I pass in the key 'CF022'

Request.vRollCodes[request.vRollCode] - where req.vRollCode = 'CF022'

it doesn't return 'NY' instead i get...

Element CF022 is undefined in a CFML structure referenced as part of an expression.

The error occurred in D:\Inetpub\wwwroot\USW\Common\PROF\Industry\Compare\cmpMainDsp.cfm: line 278

278 : in #request.vRollCodes[request.vRollCode]#

This topic is closed to new replies. Start a new post to keep the conversation going.

Correct answer brad92008

Thanks - that helped me find the issue... there was padding in the structure[key] - value... I had looked for that earlier using Enterprise Manager but it automatically trimmed the values for me so even though the value was really - 'CF022 ' sql was returning 'CF022' or len = 5 not 10..... I ended up writing a test app to interogate the key length in multiple DBs adn tables.. and check the actual lengths. When I found the offending table/fields I just did a quick update table set field = rtrim(field).. and it worked fine.

B

brad92008AuthorCorrect answer

Participant

Thanks - that helped me find the issue... there was padding in the structure[key] - value... I had looked for that earlier using Enterprise Manager but it automatically trimmed the values for me so even though the value was really - 'CF022 ' sql was returning 'CF022' or len = 5 not 10..... I ended up writing a test app to interogate the key length in multiple DBs adn tables.. and check the actual lengths. When I found the offending table/fields I just did a quick update table set field = rtrim(field).. and it worked fine.

-

-__cfSearching__-

Inspiring

Try comparing the ascii values. Are there any differences?

<cfset string1 = structKeyList(request.vRollCodes)>
<cfset string2 = request.vRollCode>

<cfoutput>
string1: 
<cfloop from="1" to="#len(string1)#" index="c">
<cfset char = mid(string1, c, 1)>
position[#c#]: #char# #asc(char)# 
</cfloop>

string2: 
<cfloop from="1" to="#len(string2)#" index="c">
<cfset char = mid(string2, c, 1)>
position[#c#]: #char# #asc(char)# 
</cfloop>
</cfoutput>

B

brad92008Author

Participant

If I dump just the structure: vRollCodes - I get:

CF022 | NY

If I try to dump the structure with the key index:
vRollCodes[vRollCode] - I get the error.. i.e., vRollCode = 'CF022'..

'Element CF022 is undefined....'

-

-__cfSearching__-

Inspiring

I would say first verify the simple things. Dump the structureKeyList and the key (before the error). Just to be absolutely certain the values are what you think they are.

<cfdump var="#structKeyList(request.vRollCodes)#">
<cfdump var="#request.vRollCode#">

If they appear the match visually, examine the ascii values of each character. Leading or trailing whitespace might account for the difference. Notice the key is not found due to the trailing whitespace.

<cfset request.vRollCodes = structNew()>

<cfset request.vRollCodes["CF022 "]= "NY">
<cfset request.vRollCode = "CF022">
<cfif structKeyExists(request.vRollCodes, request.vRollCode)>
Key found
<cfelse>
NOT FOUND
</cfif>

-

-__cfSearching__-

Inspiring

brad92008 wrote:
> <cfdump var=#Request.vSurveyLmicodes#>
> #request.vRollCodes[request.vRollCode]#

Those are two different structures. Is that a typo?

B

brad92008Author

Participant

Yeah thats a typo - I was trying to change the names to protect the innocent.. The structure is populated however, when I try to access the value when passing in the key.. ie.., #Request.vStrucure[Request.Key].... I get the error.

Thanks

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.