SELECT * FROM newmaster WHERE UPC = #url.upc# and complete = 'y' Download tracks by <cfoutput query="album" maxrows=1> <cfif label eq "hjb"> Various Artists - #recording_title# <cfelseif comp eq "c"> Various Artists - #recording_title# <cfelse> #recording_artist# - #recording_title#</cfif> </cfoutput>

UPC - 0#val(upc)#
UPC - #val(upc)#
Various Artists - #recording_title# Various Artists - #recording_title# #recording_artist# - #recording_title#

Release Date - #DateFormat(release_date, "MMM, YYYY")#
$#numberformat(PRICE, '99.99')#

SELECT * FROM newmaster WHERE UPC = #url.upc# #recording_artist# - #artist# - #time#
#recording_artist# - #artist# - #time#
#artist# - #time#