I am creating an array of records in a single query.
I want the user to be able to select the records the wish to update, input the
new values for each record they with to update, then update.
I have my form which diplayes the infomation with the folloing checkbox. There
may be one record for one customers and five records for another.
If I check all of the checkboxes it works fine, If I don't I get this error.
This information is going into a holding database to be verified befor the
update takes place. That is the reason I am useing insert statments instead of
update statments.
Element fld_bussPurpChange_2 is undefined in a Java object of type class
coldfusion.filter.FormScope referenced as
Here is my code
Form.
<cfinput type="checkbox"
name="fld_bussPurpChange_#oracle_cust_bussPurp.currentrow#" value="Yes" />
Action.
<cfloop from="1" to="#form.bussPurpRecords#" index="ii">
<cfset variables.fld_bussPurpChange = form["fld_bussPurpChange_"&ii]/>
<cfset variables.SITE_USE_ID = form["fld_SITE_USE_ID_"&ii]/>
<cfset variables.SITE_USE_CODE = form["fld_SITE_USE_CODE_"&ii]/>
<cfset variables.LOCATION = form["fld_LOCATION_"&ii]/>
<cfset variables.TAX_REFERENCE = form["fld_TAX_REFERENCE_"&ii]/>
<cfset variables.TAX_CODE = form["fld_TAX_CODE_"&ii]/>
<cfset variables.PRIMARY_SALESREP_ID = form["fld_PRIMARY_SALESREP_"&ii]/>
<cfset variables.SHIP_PARTIAL = form["fld_SHIP_PARTIAL_"&ii]/>
<cfset variables.FREIGHT_TERM = form["fld_FREIGHT_TERM_"&ii]/>
<cfset variables.PRICE_LIST_ID = form["fld_PRICE_LIST_ID_"&ii]/>
<cfset variables.WAREHOUSE_ID = form["fld_WAREHOUSE_ID_"&ii]/>
<cfif variables.fld_bussPurpChange EQ "Yes">
<!--- Update this product with the new id --->
<cfquery name="insertSiteUseinfo" datasource="cust_profile">
INSERT INTO AR_RA_SITE_USES_ALL
(SITE_USE_ID,
FORM_REQUEST_ID,
NEW_OLD,
SITE_USE_CODE,
ADDRESS_ID,
LOCATION,
TAX_REFERENCE,
TAX_CODE,
PRIMARY_SALESREP_ID,
SHIP_PARTIAL,
FREIGHT_TERM,
PRICE_LIST_ID,
WAREHOUSE_ID)
VALUES
('#(variables.SITE_USE_ID)#',
'#(getRequestNo.New_req_num)+1#',
'New',
'#(variables.SITE_USE_CODE)#',
'#form.fld_ADDRESS_ID#',
'#(variables.LOCATION)#',
'#(variables.TAX_REFERENCE)#',
'#(variables.TAX_CODE)#',
'#(variables.PRIMARY_SALESREP_ID)#',
'#(variables.SHIP_PARTIAL)#',
'#(variables.FREIGHT_TERM)#',
'#(variables.PRICE_LIST_ID)#',
'#(variables.WAREHOUSE_ID)#')
</cfquery>
</cfif>
</cfloop>
Thank you,
Keith
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253540
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
