<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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
