|
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
selcting multiple values to insert into database
Hi Guyspaul . 05/16/01 09:08 A
Author: paul .
Hi Guys i have an issuse please help. i have a select menu where i select multiple select to insert the code is ---------------- <select name="team_member" size="4" multiple> <option value="0"></option><cfoutput query=qry_get_team_members> <option value="#rec_id#">#name#</option></cfoutput> </select> ------------------------------- the selcted member-idx is inserted into taht table with rec_id as the primary key which is appended for every member_idx inserted , AND now the case is the for multilple member_idx slected it has to insert into tabel.. ex: if 3 member_idx is selected for inserting it has to insert one after another 3 times appending the rec_id value..since its a primary key .. Please do suggest , the query is like this ----------------------------- <Cfquery datasource=qrtreports> insert into UHC.PCA_TRAIN_PART (rec_id, member_idx, team_idx, quarter_idx, classification, training_course_id, atten) values(#record_count#, #attributes.team_member#, #session.team_idx#, #session.quarter_idx#, #attributes.classification#, #attributes.training_course# ,'p') </cfquery> ------------ i was told that it can be done with arrays do help me out place -paul Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority. com/bkinfo.cfm
|
Mailing Lists
|
Latest Fusion Authority Articles
|
||||||
