Use the Value="" attribute of the select tag. I modified your code below.
<select name="lname">
<option>
<cfoutput query="qryUsers" group="lname">
<cfif lname NEQ "" and Inactive NEQ 1>
<option value="#id#">#lname#, #fname#">#lname#,
#fname#</option>
</cfif>
</cfoutput>
</select>
|-----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