variable named field calculated from variable named fields

[Chris Kemp]

I have two form fields per line defined in a cfloop thusly:


<cfloop index="i" from= "1" to= "100" Step="1">
<cfif isdefined("form.item_number_" & "#i#")>
<tr>
<td>
<input type=text name="item_Quantity_" & "#i#"
value="#FORM["item_Quantity_" & i]#">

<input type=text readonly name="amount_" & "#i#"
value="#FORM["amount_" & i]#">

</td>
</tr>
</cfif>
</cfloop>

I want to add a third field name "extended_amount_" & "#i#"

whose value will be the product of the variably named item_quantity
and item amount fields.

What is the grammatical construction to calculate the extended amount
for each line?

[mxstu]

One way ..


<cfset extendedAmount = VAL(FORM["item_Quantity_" & i]) * VAL(FORM["amount_" & i])>
<input type="text" readonly name="extended_amount_#i#" value="#extendedAmount#">