strange ouput

Question

the values of variables.otherfundingsource is 9,21,97.

<cfset variables.otherfundingsource = "9,21,97">
And before inserting they are same which are 9,21,97.

debugging: before insert - variables.otherfundingsource: <cfoutput>#variables.otherfundingsource#</cfoutput>

<cfquery name="r03201_child_insert" datasource ="testdb">
<cfloop list="#variables.otherfundingsource#" index="variables.otherfundingsource">
insert into #variables.sub01table#
([#variables.foreignid#],
[otherfundingsource])

values (#variables.index_id#,
#variables.otherfundingsource#)
</cfloop>
</cfquery>
</cfif>

debugging: after insert - variables.otherfundingsource: <cfoutput>#variables.otherfundingsource#</cfoutput>
after inserting, the output of variables.otherfundings shows only "97"

why the one value which is "97" is showing up other than three of them which are 9,21,97. what went wrong? shouldn't it output 9,21,97?

Newsgroup_User · Answer

Because of this line

<cfloop list="#variables.otherfundingsource#"
index="variables.otherfundingsource">

The index parameter is the variable to store each value of the list as
it is looped over. So as you loop over the list, [9,21,97], you are
assigning each of these values to "variables.otherfundingsource". Thus
at the end of the loop, variables.otherfundingsource is going to equal
the last value in the list, i.e. 97.

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.

Scanning file for viruses.

This file cannot be downloaded