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?