How can I output this duplicate field using the same query..
<CFQUERY NAME="SNoReg" DATASOURCE="iucAccess1">
SELECT PRESENT.SNoRegistrants, REGSUM.SNoRegistrants, PRESENT.AModPackID,
PRESENT.SPresCounter, PRESENT.DeginDate, REGSUM.AModulePackageID, REGSUM.DPresDate,
REGSUM.SPresCounter
FROM REGSUM, PRESENT
WHERE PRESENT.AModPackID = REGSUM.AModulePackageID AND
PRESENT.SPresCounter = REGSUM.SPresCounter AND
PRESENT.DeginDate = REGSUM.DPresDate AND
(PRESENT.AModPackID = 'M3578') AND (PRESENT.SPresCounter = 1) AND (PRESENT.DeginDate
= ##9/5/2001##) AND (REGSUM.AModulePackageID = 'M3578') AND (REGSUM.DPresDate =
##9/5/2001##) AND (REGSUM.SPresCounter = 1)
</CFQUERY>
<cfoutput>
#PRESENT.SNoREgistrants#
#PREGSUM.SNoRegistrants#
</cfoutput>
Thank You,
_________________________
Victor Mendez
Network Administrator
Phone 310.825.6053
Fax 310.206.0364
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
