Use the id for the option tag value attribute, and display the name.
<select name="lname">
<option>
<cfoutput query="qryUsers" group="lname">
<cfif lname NEQ "">
<cfif Inactive NEQ 1>
<option value="#id#">#lname#, #fname#
</cfif>
</cfif>
</cfoutput>
</select>
~Simon
Simon Horwith
Allaire Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-----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
