I figured it out!!
The answer (or at least the one I'm using):
<!--- Query to convert NOTIFY from the iMIS UserID to the UserName for a more
user-friendly message in the email --->
<!--- Loops over the Notify variable to break out the list items. --->
<CFLOOP INDEX="get_count"
LIST="#form.notify#">
<CFQUERY NAME="notify_email" DATASOURCE="iMIS Enterprise">
SELECT Users.UserName
FROM Users Users
WHERE Users.UserId IN (#ListQualify(form.NOTIFY, "'")#)
</cfquery>
<!--- Creates a new list called Dear to output in the email --->
<CFSET Dear="">
<CFLOOP QUERY="notify_email">
<CFSET Dear = ListAppend(Dear, ' #notify_email.UserName#')>
</CFLOOP> <!--- ends QUERY loop over "NOTIFY" conversion to UserName --->
</CFLOOP> <!--- ends INDEX loop over "NOTIFY" conversion to UserName --->
Thank you to David & Matt
:-)
Oriole
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
