Can I pass multiple values from a select box?

[ljevans]

I have a select box that is populated using 2 queries, each from different tables. They both pass pkey for value. Based on which table's value is selected, determines another setting when an update takes place. I may have a pkey value of 8 for a department and a pkey value of 8 for an employee. I need to know which table the pkey value came from. Any thoughts?

Code:

<!---
<select name="assignment">
<cfoutput query="dept">
<option value="#pkey#">#dept#</option>
</cfoutput>
<cfoutput query="emp">
<option value="#pkey#>#employee#</option>
</cfoutput>
</select>
--->

 

[ecobb]

<select name="assignment">
   <cfoutput query="dept">
       <option value="[red]dept_[/red]#pkey#">#dept#</option>
   </cfoutput>
   <cfoutput query="emp">
        <option value="[red]emp_[/red]#pkey#>#employee#</option>
   </cfoutput>
</select>

Your results will look like "dept_8" or "emp_8". On your action page check for "dept_" or "emp_" in your form values, this will tell you which table it came from.

<cfif ListFirst(Form.assignment,'_') EQ "dept">
   This is from the DEPT Table
<cfelseif ListFirst(Form.assignment,'_') EQ "emp">   
   This is from the EMP Table
</cfif>

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher