Technote Details :: Manually add fields to a NeXTensio Form
Issue
I need to add some extra fields to a form (a field that uploads a file, or another transaction that is linked to the form's transaction). For one single record it works fine, but when trying to do a multiple insert, only the first one is taken into consideration.
Reason
This happens because the name of the form elements are different for each instance in a multiple insert / update. This is necessary in order to identify which elements belong to which transaction. The names differ only slightly (the main name is the same) - from the code, a parameter is added to the name and ID of elements. This allows using them in the multiple insert/update transactions. The parameter name is cnt1 .
Solution
In order for the additional fields to work on the multiple insert/update, you must edit their names and ID's from the code. In Dreamweaver, switch to code view, and locate for each element the name="element_name" and id="element_name" HTML text. After the element name add a trailing underscore (it will become name= "element_name_" and id="element_name_"). Next add the parameter. This part is different based on your server model:
For PHP_MySQL and PHP_ADODB: you have to add the <?php echo $cnt1;?> section after the trailing underscore for the name and ID. The code becomes: name= "element_name_<?php echo $cnt1;?>"
For ASP VbScript: <%= cnt1 %>. The code becomes: name= "element_name_<%= cnt1 %>"
For ColdFusion: <cfoutput>#cnt1#</cfoutput>. The code becomes: name= "element_name_<cfoutput>#cnt1#</cfoutput".
Now the elements will work for all records you are trying to insert/update (the number you select in the list drop-down).