rothkamm source

------------------------------------------------------------
* copyright Rothkamm.com 2004-2013 - all rights reserved *
------------------------------------------------------------

<CFIF findnocase('star',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Frank-Genius-is-Star-Struck" addtoken="no"></CFIF>
<CFIF findnocase('opus',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Opus-Spongebobicum" addtoken="no"></CFIF>
<CFIF findnocase('FB03',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?FB03" addtoken="no"></CFIF>
<CFIF findnocase('FB01',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?FB01" addtoken="no"></CFIF>
<CFIF findnocase('FB02',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?FB02" addtoken="no"></CFIF>
<CFIF findnocase('Moers',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Moers-Works" addtoken="no"></CFIF>
<CFIF findnocase('organs',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?just-3-organs" addtoken="no"></CFIF>
<CFIF findnocase('LAX',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?LAX" addtoken="no"></CFIF>
<CFIF findnocase('Fish',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Mystery-of-the-Leaping-Fish" addtoken="no"></CFIF>
<CFIF findnocase('ghost',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Ghost-of-New-York" addtoken="no"></CFIF>
<CFIF findnocase('zahra',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Zahra-Fugues" addtoken="no"></CFIF>
<CFIF findnocase('fugues',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Zahra-Fugues" addtoken="no"></CFIF>
<CFIF findnocase('birth',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Birth-Of-Primary-Cinema-From-The-Spirit-of-Sound" addtoken="no"></CFIF>
<CFIF findnocase('cinema',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Birth-Of-Primary-Cinema-From-the-Spirit-of-Sound" addtoken="no"></CFIF>
<CFIF findnocase('ameri',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?Amerika" addtoken="no"></CFIF>
<CFIF findnocase('alt',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?ALT" addtoken="no"></CFIF>
<CFIF findnocase('reno',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?RENO" addtoken="no"></CFIF>
<CFIF findnocase('k5',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/multiple.cfm?K5" addtoken="no"></CFIF>
<CFIF findnocase('radio',CGI.QUERY_STRING)><CFLOCATION url="http://rothkamm.com/radio.cfm" addtoken="no"></CFIF>

<CFQUERY NAME="records" DATASOURCE="#ds#">
SELECT * from Album
</CFQUERY>

<CFQUERY NAME="solo" DATASOURCE="#ds#">
SELECT * from Album
where solo = '1' and Released <= '<CFOUTPUT>#DateFormat(now(),"YYYY-MM-DD")#</CFOUTPUT>'
ORDER by Released DESC
</CFQUERY>

<CFQUERY NAME="com" DATASOURCE="#ds#">
SELECT * from Album
where solo = 'com'
ORDER by Released DESC
</CFQUERY>

<CFQUERY NAME="col" DATASOURCE="#ds#">
SELECT * from Album
where solo = 'col'
ORDER by Released DESC
</CFQUERY>

<CFQUERY NAME="rem" DATASOURCE="#ds#">
SELECT * from Album
where solo = 'rem'
ORDER by Released DESC
</CFQUERY>

<CFQUERY NAME="FluxCD" DATASOURCE="#ds#">
SELECT * from Album
where  Released > '1994-01-01' AND Released <= '#DateFormat(now(),"YYYY-MM-DD")#'
AND label like '%Flux Records%' OR label like '%Monochrome Vision%' OR label like '%baskaru%'
ORDER by Released DESC
</CFQUERY>

<HTML>

<HEAD>
<TITLE>Frank Rothkamm | <CFOUTPUT>#records.recordcount# multiples | 1986-#DateFormat(now(),"YYYY")#</CFOUTPUT></TITLE>
<CFINCLUDE TEMPLATE="_javascript.cfm">
<LINK HREF="css.css" REL="stylesheet" TYPE="text/css"></HEAD>

<BODY>
<div id="margin-left:auto; margin-right:auto;">
<DIV ID="menue"><CFINCLUDE TEMPLATE="_menue2.cfm"></DIV>
<DIV ID="Layer2"><CFINCLUDE TEMPLATE="_header.cfm"></DIV>
<CFINCLUDE TEMPLATE="_layers.cfm">

<DIV ID="Layer1">
<TABLE WIDTH="100%" BORDER="0" ALIGN="right" CELLPADDING="1" CELLSPACING="0" BGCOLOR="#3F3F3F">

<TR>
<TD VALIGN="TOP" BGCOLOR="#3F3F3F"><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="5" BGCOLOR="#FFFFFF">

<TR>
<TD COLSPAN="5" ALIGN="center"><img src="pictures/press/rothkamm-Amerika.jpg" width="600" vspace="5" border="0" ><br><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="8" BACKGROUND="pictures/shimWhiteChecker.gif" >
<cfoutput query="FluxCD">
<CFIF (currentrow-1) MOD 3 EQ 0><TR></CFIF>
<TD ALIGN="CENTER" NOWRAP VALIGN="TOP"><A HREF='multiple.cfm?#Replace(name," ","-","ALL")#'><IMG SRC='product/small/#trim(lcase(Replace(name," ","","ALL")))#cd.jpg' BORDER="0"></A></TD>
<TD width="94" align="center" class="style2b"><A HREF='multiple.cfm?#Replace(name," ","-","ALL")#'><strong>#name#</strong><cfif NameExt neq ''><br />(#NameExt#)</cfif></A><br /><SPAN CLASS="styleTiny">#DateFormat(Released,"M/D/YYYY")#</SPAN></TD>
<CFIF (currentrow-1) MOD 3 EQ 2></TR></CFIF>
</cfoutput>
</TABLE>

</TD></TR>

<TR><TD COLSPAN="5"><IMG SRC="pictures/shimblack.gif" WIDTH="100%" HEIGHT="1"></TD></TR>

<CFOUTPUT query="solo">

<TR>
<TD ALIGN="left" VALIGN="top" CLASS="style2">#NumberFormat(Evaluate(abs(recordcount-currentrow)+1),"00")#</TD>
<TD CLASS="style2cfade" COLSPAN="4" >#Format#</TD>
</TR>
<TR>

<TD VALIGN="TOP" CLASS="styleTimes" ALIGN="center"><CFIF FileExists('#GetDirectoryFromPath(ExpandPath("*.*"))#pictures\icons\#trim(lcase(Replace(name,' ','_','ALL')))#.jpg')><CFIF DateFormat(now(),'YYYYMMDD') GTE DateFormat(Released,'YYYYMMDD')><A href='http://rothkamm.com/multiple.cfm?#REReplace(name,"( )","-","all")#'></CFIF><IMG SRC="pictures/icons/#trim(lcase(Replace(name,' ','_','ALL')))#.jpg" BORDER="0" ALIGN="ABSMIDDLE"></A><CFELSE><IMG SRC="pictures/icons/apple15.gif" BORDER="0">
</CFIF></TD>
<TD VALIGN="TOP" CLASS="style3">#name#<BR><SPAN CLASS="style2cfade">#label#</SPAN></TD>
<TD VALIGN="TOP" CLASS="style3"><STRONG>#Replace(artist,","," ","ALL")#</STRONG></TD>

<TD VALIGN="TOP" CLASS="style2cfade">#DateFormat(Released,"YYYY")#</TD>
<TD VALIGN="TOP" ><IMG SRC="pictures/shim.gif" WIDTH="10" HEIGHT="3"><BR><IMG SRC="pictures/flags/flag_#trim(lcase(country))#.gif" TITLE="Country of Release: #trim(country)#"></TD>
</TR>

<TR><TD COLSPAN="5"><IMG SRC="pictures/shimblack.gif" WIDTH="100%" HEIGHT="1"></TD></TR>

</CFOUTPUT>

<TR>
<TD COLSPAN="5" CLASS="style3b"><IMG SRC="pictures/shim.gif" WIDTH="30" HEIGHT="10"><EM> </EM><EM CLASS="secHeadmedia1">colaborations</EM></TD>
</TR>
<TR><TD COLSPAN="5"><IMG SRC="pictures/shimblack.gif" WIDTH="100%" HEIGHT="1"></TD></TR>

<CFOUTPUT query="col">

<TR>
<TD ALIGN="left" VALIGN="top" CLASS="style2">#NumberFormat(Evaluate(abs(recordcount-currentrow)+1),"00")#</TD>
<TD CLASS="style2cfade" COLSPAN="4" >#Format#</TD>
</TR>
<TR>

<TD VALIGN="TOP" CLASS="styleTimes" ALIGN="center"><CFIF DateFormat(now(),'YYYYMMDD') GTE DateFormat(Released,'YYYYMMDD')><A href='http://rothkamm.com/multiple.cfm?#REReplace(name,"( )","-","all")#'></CFIF><IMG SRC="pictures/icons/#trim(lcase(Replace(name,' ','_','ALL')))#.jpg" ALIGN="ABSMIDDLE" border="0"></A></TD>
<TD VALIGN="TOP" CLASS="style3">#name#<BR><SPAN CLASS="style2cfade">#label#</SPAN></TD>
<TD VALIGN="TOP" CLASS="style3"><STRONG>#Replace(artist,","," ","ALL")#</STRONG></TD>

<TD VALIGN="TOP" CLASS="style2cfade">#DateFormat(Released,"YYYY")#</TD>
<TD VALIGN="TOP" ><IMG SRC="pictures/shim.gif" WIDTH="10" HEIGHT="3"><BR><IMG SRC="pictures/flags/flag_#trim(lcase(country))#.gif" TITLE="Country of Release: #trim(country)#"></TD>
</TR>

<TR><TD COLSPAN="5"><IMG SRC="pictures/shimblack.gif" WIDTH="100%" HEIGHT="1"></TD></TR>

</CFOUTPUT>

<TR>
<TD COLSPAN="5" CLASS="style3b"><IMG SRC="pictures/shim.gif" WIDTH="30" HEIGHT="10"><EM CLASS="secHeadmedia1"> compilations</EM></TD>
</TR>
<TR><TD COLSPAN="5"><IMG SRC="pictures/shimblack.gif" WIDTH="100%" HEIGHT="1"></TD></TR>

<CFOUTPUT query="com">

<TR>
<TD ALIGN="left" VALIGN="top" CLASS="style2">#NumberFormat(Evaluate(abs(recordcount-currentrow)+1),"00")#</TD>
<TD CLASS="style2cfade" COLSPAN="4" >#Format#</TD>
</TR>
<TR>

<TD VALIGN="TOP" CLASS="styleTimes" ALIGN="center"><IMG SRC="pictures/icons/#trim(lcase(Replace(name,' ','_','ALL')))#.jpg" ALIGN="ABSMIDDLE"></TD>
<TD VALIGN="TOP" CLASS="style3">#name#<BR><SPAN CLASS="style2cfade">#label#</SPAN></TD>
<TD VALIGN="TOP" CLASS="style3"><STRONG>#Replace(artist,","," ","ALL")#</STRONG></TD>

<TD VALIGN="TOP" CLASS="style2cfade">#DateFormat(Released,"YYYY")#</TD>
<TD VALIGN="TOP" ><IMG SRC="pictures/shim.gif" WIDTH="10" HEIGHT="3"><BR><IMG SRC="pictures/flags/flag_#trim(lcase(country))#.gif" TITLE="Country of Release: #trim(country)#"></TD>
</TR>

<TR><TD COLSPAN="5"><IMG SRC="pictures/shimblack.gif" WIDTH="100%" HEIGHT="1"></TD></TR>

</CFOUTPUT>

<TD COLSPAN="5" CLASS="style3b"><IMG SRC="pictures/shim.gif" WIDTH="30" HEIGHT="10"><EM CLASS="secHeadmedia1"> remixes</EM></TD>
</TR>
<TR><TD COLSPAN="5"><IMG SRC="pictures/shimblack.gif" WIDTH="100%" HEIGHT="1"></TD></TR>

<CFOUTPUT query="rem">

<TR>
<TD ALIGN="left" VALIGN="top" CLASS="style2">#NumberFormat(Evaluate(abs(recordcount-currentrow)+1),"00")#</TD>
<TD CLASS="style2cfade" COLSPAN="4" >#Format#</TD>
</TR>
<TR>

<TD VALIGN="TOP" CLASS="styleTimes" ALIGN="center"><IMG SRC="pictures/icons/#trim(lcase(Replace(name,' ','_','ALL')))#.jpg" ALIGN="ABSMIDDLE"></TD>
<TD VALIGN="TOP" CLASS="style3">#name#<BR><SPAN CLASS="style2cfade">#label#</SPAN></TD>
<TD VALIGN="TOP" CLASS="style3"><STRONG>#Replace(artist,","," ","ALL")#</STRONG></TD>

<TD VALIGN="TOP" CLASS="style2cfade">#DateFormat(Released,"YYYY")#</TD>
<TD VALIGN="TOP" ><IMG SRC="pictures/shim.gif" WIDTH="10" HEIGHT="3"><BR><IMG SRC="pictures/flags/flag_#trim(lcase(country))#.gif" TITLE="Country of Release: #trim(country)#"></TD>
</TR>

<TR><TD COLSPAN="5"><IMG SRC="pictures/shimblack.gif" WIDTH="100%" HEIGHT="1"></TD></TR>

</CFOUTPUT>

</TABLE>
<CFINCLUDE TEMPLATE="foot.cfm"></TD>
</TR>
</TABLE>

</DIV>
</BODY>

</HTML>