Becky,
You could try this, where I have passed the ID of the employee to
be pre-selected as a URL variable. You can then change the selection.
<select name="EMPID">
<cfoutput query="qryUpEquip">
<option value="#empID#"
<cfif qryUpEquip.EmpID IS
#URL.EmpID#>
SELECTED
</cfif>>
#LName# #FName#
</cfoutput>
</select>
HTH
Tristram Charnley
-----------------
[EMAIL PROTECTED]
"If something is hard to do, its not worth doing!"
Homer Simpson.
> -----Original Message-----
> From: Jones, Becky [mailto:[EMAIL PROTECTED]]
> Sent: 28 March 2001 01:17
> To: CF-Talk
> Subject: output
>
>
> i have an update form. and i want to be able to have a
> select box of all
> users. but i want the user that i am currently updating to
> be "selected"
> but i want to have the ability to select someone else. is
> this possible?
> right now i have this:
> <tr>
> <td>User Name:</td>
> <td><select name="empid">
> <cfoutput query="qryUpEquip">
> <option value="#empID#">#lname# #fname#
> </cfoutput>
> </select> </td>
> </tr>
> and it shows up the correct selected user, but i want to be
> able to choose
> someone else from the list and it is only showing this
> particular user.
> thanks,
> 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
