In your query select out employeeID along with lname and fname and then your
option line should look like this:
<CFQUERY name="qryUsers" .....
Select EmployeeID, lname, fname
FROM employee
........
</CFQUERY>
<cfoutput query="qryUsers" group="lname">
<option value="#employeeID#">#lname#, #fname#
........
-----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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
