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
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
