<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE TAF SYSTEM "tango.dtd" >
<TAF Version="0x02000002">
	<Comments />

	<!--Main program-->
	<Program>
		<ActionRef Ref="FeaturedAudio" />
	</Program>

	<!--Program actions-->
	<Actions>
		<DirectDBMSAction DSID="epicsony.world" DeploymentDSID="epicsony.world.1" ID="FeaturedAudio" Sig="cust">
			<Custom><![CDATA[SELECT 

MJJFEATUREDCLIP.CLIPID,

CLIPVIEW.CLIPNAME,

CLIPVIEW.CLIPDESCRIP, 

ARTIST.ARTISTID, 

LTRIM(RTRIM(ARTIST.FNAME)||' '||RTRIM(ARTIST.LNAME)) ARTIST,           

LOWER(ARTIST.LNAME||ARTIST.FNAME) OARTIST,

LTRIM(RTRIM(ARTIST.HOMEDIR)||RTRIM(ARTIST.HOMEDOC)||RTRIM(ARTIST.HOMEPARAM)),

RTRIM(CLIPVIEW.DISCID), 

CLIPVIEW.CLIPSUFFIXTYPE SUFFIXTYPE,

CLIPVIEW.SUBDIR,

CLIPVIEW.SUFFIX,

CLIPVIEW.TRACKID



FROM EPIC.MJJFEATUREDCLIP, EPIC.CLIPVIEW, EPIC.ARTIST



WHERE 

CLIPVIEW.CLIPID=MJJFEATUREDCLIP.CLIPID AND

ARTIST.ARTISTID=CLIPVIEW.ARTISTID AND 

(SUFFIXTYPE='RA' OR SUFFIXTYPE='AIFF' OR SUFFIXTYPE='WAV')



ORDER BY OARTIST, CLIPNAME, SUFFIXTYPE

]]></Custom>
			<StartRow>1</StartRow>
			<ResultsOutput Ref="FeaturedAudio.Results" />
		</DirectDBMSAction>
	</Actions>

	<!--Data sources-->
	<DataSources>
		<DataSource ID="epicsony.world">
			<DSType>Oracle</DSType>
			<DSN>epicsony.world</DSN>
			<DBMS />
			<Host>epic</Host>
			<Database />
			<UserInfo Encrypted="True">
				<UserName>%9A%1B%E59%B0X%82u</UserName>
				<Password>%F5%CA%C4%AB%93%DA%F9%F9</Password>
			</UserInfo>
		</DataSource>
		<DataSource ID="epicsony.world.1">
			<DSType>Oracle</DSType>
			<DSN>epicsony.world</DSN>
			<DBMS />
			<Host>epicsony.world</Host>
			<Database />
			<UserInfo Encrypted="True">
				<UserName>%9A%1B%E59%B0X%82u</UserName>
				<Password>%F5%CA%C4%AB%93%DA%F9%F9</Password>
			</UserInfo>
		</DataSource>
	</DataSources>

	<!--Output blocks-->
	<Outputs>
		<Output ID="FeaturedAudio.Results" Type="HTML"><![CDATA[<@INCLUDE "<@APPFILEPATH>audio.html">]]></Output>
	</Outputs>
</TAF>
