Loop over form values & insert into db

form

prod_id     prod_name       prod_price    prod_status
001         product 001     1.00          1            
002         product 002     2.00          1      
003         product 003     3.00          0      
004         product 004     4.00          0      

 

form dump
prod_name      product 001,product 002,product 003,product 004
fieldnames     prod_id, prod_name, prod_price, prod_status
prod_price     1.00,2.00,3.00,4.00
prod_status    1,1,0,0
prod_id        001,002,003

i want update few fields, prod_price , prod_status. submit these values update page i'm not sure how loop on these values , update prod_id. in update page i'm using cfdump , see structure of form, fieldnames prod_id, prod_name, etc , values.

 

my question how loop on these form values i'll able update each prod_id? i've played around looping on form collection values no luck.

if each form field (prod_name, prod_price, etc.) contains comma delimited list of values can use cf's list functions parse data.

 

http://help.adobe.com/en_us/coldfusion/9.0/cfmlref/wsc3ff6d0ea77859461172e0811cbec1a60c-7f fc.html#wsc3ff6d0ea77859461172e0811cbec22c24-6a42

More discussions in ColdFusion

adobe