Well just with the information given I would crate a 2 dimensional array and loop over the array inserting each record into the database
<cfloop your array>
<cfquery insert your data>
</cfquery>
</cfloop>
 
 Id also use the array to display the user selections. Is that what you are after?
 
Adaryl "Did you reboot?" Wakefield
Aviator by passion
Programmer by sheer force of will
----- Original Message -----
Sent: Thursday, May 27, 2004 11:47 AM
Subject: [KCFusion] Select Boxes

I would like to have 2 select boxes on a page.  The select boxes are 2 different tables not related.

 

I need to select one item from the first box and multiple items from the second box.

 

Then I need to display the items selected.  I also need to save the selected items by their UUID to a table.  In other words, I need the  #1 UUID and #2 UUID as a record and #1 UUID and #3 UUID as a record, etc.   The new table would look like PKUUID,FKUUID  (1,1  1,2  1,3  1,4 etc.)

 

 

I hope that I have made this clear.  If you have any questions, email me at [EMAIL PROTECTED]

 

Thanks for any help.

 

George Quade

 

Reply via email to