Try
SELECT PRESENT.SNoRegistrants AS myfirstvariable, REGSUM.SNoRegistrants AS
mysecondvarible.....
-----Original Message-----
From: Victor Mendez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 1:03 AM
To: CF-Server
Subject: Please advice to output Query
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
