How to set an index of an array within a struct as a variable(Coldfusion)

Question

This is the first error that I am getting: Invalid data [d6-2014-74, , ] for CFSQLTYPE CF_SQL_VARCHAR

Here is the corresponding code.

 <cfset x = Arguments.surveyDocNo>
 <cfprocparam cfsqltype="cf_sql_varchar" value="#x#">

To solve that problem, I changed my code to this:

 <cfset x = Arguments.surveyDocNo[1]>

However, that returns this error:

500 You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members.

So the array issue is fixed, but I don't know how to fix the second error.

 <cfdump var="#arguments.surveyDocNo#">

In your first screen shot surveyDocNo is an Array but in your second screenshot it is a string. If you changed the variable to no longer be an array then you can go back to your original reference Arguments.surveyDocNo without the index value. — Miguel-F
– Miguel-F, Commented Nov 17, 2016 at 20:43
@Miguel-F Thanks for the quick response. Maybe I'm not understanding correctly, but when I go back to my original reference, it becomes an array again. — Simran Litt
– Simran Litt, Commented Nov 17, 2016 at 20:58
To avoid confusion, can you please dump the Arguments.surveyDocNo variable (not the whole structure) and post a screen shot. — Leigh
– Leigh, Commented Nov 17, 2016 at 21:30
Thanks. It clearly is an array, so I do not see how <cfset x = Arguments.surveyDocNo[1]> could possibly throw the error "...attempted to dereference a scalar variable". Seems like either different code is causing that error OR there is something more going on that we are aware of ...? — Leigh
– Leigh, Commented Nov 17, 2016 at 21:41

Alex · Accepted Answer · 2016-11-18 01:50:50Z

4

I assume you pass the surveyDocNo argument sometimes as string and sometimes as an array of strings.

<!--- if argument is passed as array, take the first element --->
<cfif isArray(Arguments.surveyDocNo) and (not arrayIsEmpty(Arguments.surveyDocNo))>
    <cfset x = Arguments.surveyDocNo[1]>
<cfelse>
    <cfset x = Arguments.surveyDocNo>
</cfif>

<!--- if the provided argument is not a string, throw an exception --->
<cfif not isSimpleValue(x)>
    <cfthrow type="IllegalArgumentException" message="The provided value for argument [surveyDocNo] is invalid. Expected a string.">
</cfif>

<cfprocparam cfsqltype="cf_sql_varchar" value="#x#">

edited Nov 18, 2016 at 1:50

answered Nov 18, 2016 at 1:45

Alex

7,8331 gold badge23 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to set an index of an array within a struct as a variable(Coldfusion)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related