<option value="#employID#">#lname#, #fname#
You don't have to pass the same var for both. Just query the DB for name and
ID then the output will loop through like you have it.
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
Office: 909-943-8428
www.red-omega.com <http://www.red-omega.com>
15 people are known to have been crushed to death tilting soda
machines towards them in order to receive free soda.
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 8: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
