you have to do another query to get a list of users then put that list under
the initial option in your select list.
cfquery name=1 //returns one record
cfquery name=2 //returns all users
select
output query=1
option value=id selected
/output
output query=2
option value=id
/outout
/select
good luck,
Alexander Sicular
Technical Director, Information Technology
The Neurological Institute of New York
Columbia University
212.305.1318
[EMAIL PROTECTED]
> -----Original Message-----
> From: Jones, Becky [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 7:30 PM
> To: CF-Talk
> Subject: RE: output
>
>
> <cfquery datasource="ITData" name="qryUpEquip">
> Select
> tblEquipment.EquipID,
> tblEquipment.CompanyNM,
> tblEquipment.ModelNo,
> tblEquipment.OS,
> tblEquipment.HardDrive,
> tblEquipment.RAM,
> tblEquipment.Leased,
> tblEquipment.LeaseTerm,
> tblEquipment.LeaseDate,
> tblEquipment.LeaseMods,
> tblEquipment.AddInfo,
> tblEquipment.Description,
> tblEquipment.SerialNo,
> tblEquipment.EquipType,
> tblEquipment.LeaseScheduleNumber,
> tblEquipment.Location,
> tblEquipment.ServiceAgree,
> tblEquipment.ServiceExp,
> tblEquipment.ServiceCert,
> tblEquipment.ServicePhone,
> tblEmployees.EmpID,
> tblEmployees.LName,
> tblEmployees.FName,
> tblEmployees.MI,
> tblEmployees.Dept,
> tblEmployees.Office,
> tblEmployees.Floor,
> tblEmployees.Phone,
> tblEmployees.Inactive
> FROM {oj tblEquipment RIGHT OUTER JOIN tblEmployees ON
> tblEquipment.EmpId
> = tblEmployees.EmpId }
> Where tblEquipment.SerialNo LIKE '%#SerialNo#%'
> <cfif EquipType NEQ "">
> OR tblEQuipment.EquipType LIKE '#EquipType#'
> </cfif>
>
> -----Original Message-----
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 7:28 PM
> To: CF-Talk
> Subject: Re: output
>
>
> what does your query look like? (qryUpEquip)
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
> ----- Original Message -----
> From: "Jones, Becky" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 27, 2001 5:16 PM
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
