I think I know what you mean. If all the checkboxes have the same name, then when you submit to the second page, the values of the checkboxes will be sent in the form variable as a comma separated list. So you could just use that in you're query.
select .. from .... where in (#form.items#) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 April 2002 22:03 To: CF-Talk Subject: <CF_Append_2_Query_Results> User does a search from a page that queries a table and displays the results. I then have a checkbox next to each result, (for 1 or more result items) each checkbox form value is dynamically assigned key_id value from table. This uniquely identifies each result set. I'm giving user the ability to select the items (checkbox) from the result set they want to save and display when they run their second (same as the first) search from within the results page. What's the best way to carry over the selected results and append them to the secondary searches? Do I use a list? An Array? Make Sense? D- ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
