the query i wrote below gives me a list of users that are assigned to an
application.
my question is, how do i get the list of 400 or so users that ARE NOT
assigned to that application to display somewhere else on the page so i
could then check a box to add them? i quess i could write a second query
that would show me all users, but how would i get it on the page that i
would just display everyone but those users from the first query?
thanks for your help,
bec.
<cfquery name="qryAppDetails" datasource="ITData">
SELECT qryIAPeople.*,
tblLicense.Password,
tblLicense.FileSrvr,
tblLicense.Expiration,
tblLicense.Quantity,
tblLicense.SerialNum,
tblLicense.LicenseKey,
tblLicense.LicenseID,
tblLicense.LAddInfo,
tblApplications.AppName,
tblApplications.AppVersion,
tblApplications.AppDesc,
tblApplications.AppQuantity,
tblApplications.AddInfo,
tblCompanyInfo.CompanyNm,
tblCompanyInfo.CompanyPhone
FROM qryIAPeople INNER JOIN ((tblCompanyInfo INNER
JOIN ((tblAppIAUsers INNER JOIN tblApplications ON tblAppIAUsers.AppID =
tblApplications.AppID)
INNER JOIN tblCompApps ON
tblApplications.AppID = tblCompApps.AppID)
ON tblCompanyInfo.CompanyID =
tblCompApps.CompanyID)
INNER JOIN tblLicense ON
tblApplications.AppID = tblLicense.AppID)
ON qryIAPeople.LISTING_ID =
tblAppIAUsers.Listing_ID
WHERE tblApplications.AppID = #url.AID#
ORDER by qryIAPeople.LAST_NM, qryIAPeople.FIRST_NM
</cfquery>
*************************************************
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
