Output the user_id in the option value:
<select name="lname">
<option>
<cfoutput query="qryUsers">
<cfif lname NEQ "">
<cfif Inactive NEQ 1>
<option value="#user_id#">#lname#, #fname#
</cfif>
</cfif>
</cfoutput>
</select>
Then if you need to output the last and first name in the form landing page,
do a query based on the:
SELECT * FROM users
WHERE user_id eq #form.lname#
Or something like this....
James
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2001 17:43
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