1. I have a query that uses a variable passed to it from the previous page: <CFQUERY NAME="List" DATASOURCE="dsn" USERNAME="usr" PASSWORD="pswd" CACHEDWITHIN="#CreateTimeSpan(0,0,0,0)#"> SELECT DISTINCT Task.Task_ID AS ID,Task.Task_Description AS WORDS FROM Task INNER JOIN Service_Scope3 ON Task.Service_Scope3_ID = Service_Scope3.Service_Scope3_ID WHERE 1 = 1 AND Task.Service_Scope3_ID IN (#PreserveSingleQuotes(Form.Scope3_Selected)#); </CFQUERY> 2. I have an output from this query that creates a list of check boxes: <CFOUTPUT Query="List"> <input type="checkbox" name="Task_Selected" value="'#ID#'"> #ID# #Words#<br> </cfoutput> <input type="hidden" name="username" value=" <cfoutput>#session.userid#</cfoutput> "> 3. The problem I need help with: I want to add a whole list of parameters to input into a database that is directly linked to each of these "Task_Selected" checkbox values. For instance: <CFOUTPUT Query="List"> <input type="checkbox" name="Task_Selected" value="'#ID#'"> #ID# #Words# <input type="text" name="param1" value=""> <input type="text" name="param2" value=""> <input type="text" name="param3" value=""> <input type="text" name="param4" value=""> <input type="text" name="param5" value=""> <input type="text" name="param6" value=""> <br> </cfoutput> <input type="hidden" name="username" value=" <cfoutput>#session.userid#</cfoutput> "> My NEWBIE dilemna is how do I grab this information on the next page? Each checkbox, etc. has the exact same name. If I dynamically generate a name, how do I grab a hold of it to place it in a database? I am lost on how to correctly format this and how to process it on the following page. Thank you. /mdeane ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
