dynamic check box variables
Posted on 2004-04-18
I am dynamically creating input checkboxes with the following query:
<cfquery name="getModels1" datasource="#DSN#" username="#UN#" password="#PW#">
SELECT tblModel.Model_id, tblModel.Model, tbl.Model.Comp_id, tblCompanies.Comp_id, tblModel.BitValue, tblCompanies.CompName
WHERE tblModel.Comp_id = 1 and tblCompanies.Comp_id = 1
<input type="checkbox" name="yachts" value="#Model#">#Model#<br></cfoutput>
I want to use the submitted variables in a cfmail to display the requested yacht model information. I have tried numerous methods including #evaluate(form.yachts)# and the other examples found here as well as Macromedia's "Developing Cold Fusion Applications". I have tried ListQualify, list loops ect and it is just a complete nightmare for me. I just can't seem to pass the list of variables. I have tried to set the cfparam default="no" and even tried to dynamically give the cfparam a value. I really could use some Expert advice.