To answer your question - yes you can. Just change the value clause of the
<option> statement to the empID.
<cfquery name="qryUsers">
select fname, lname, empID
from table
</cfquery>
<select name="lname">
<option>
<cfoutput query="qryUsers" group="lname">
<cfif lname NEQ "">
<cfif Inactive NEQ 1>
<option value="#empID#">#lname#, #fname#</option>
</cfif>
</cfif>
</cfoutput>
</select>
When the form is submitted, the value of lname will be the ID number even
though the text on the screen says LastName, FirstName.
Brian
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 11:43 AM
To: CF-Talk
Subject: output
i want to insert equipment data into my equipment database based on my
employee id. but i cant have a drop down list of just id numbers because
people wont know who the number belongs to.
is there a way i can show the names, but when the data gets inserted into my
equipment table that the corresponding employee id goes in, not the full
name?
i have this as my select box:
<select name="lname">
<option>
<cfoutput query="qryUsers" group="lname">
<cfif lname NEQ "">
<cfif Inactive NEQ 1>
<option value="#lname#, #fname#">#lname#, #fname#
</cfif>
</cfif>
</cfoutput>
</select>but when i submit this form...i want the employee id to go over,
not the
name
thanks for your help,
bec.
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
