<%@LANGUAGE="VBSCRIPT"%> <% Page_Title = "Recommendations" %> <% '********************************* Recordsets **********************************' %> <% Dim Recommendation_Set__MMColParam Recommendation_Set__MMColParam = "all" If (Request.QueryString("category") <> "") Then Recommendation_Set__MMColParam = Request.QueryString("category") End If %> <% Dim Recommendation_Set Dim Recommendation_Set_numRows Set Recommendation_Set = Server.CreateObject("ADODB.Recordset") Recommendation_Set.ActiveConnection = MM_DATA_STRING Recommendation_Set.Source = "SELECT Recommendation.*, RecommendationGroup.RecommendationGroupTitle FROM RecommendationGroup INNER JOIN Recommendation ON RecommendationGroup.RecommendationGroupID = Recommendation.RecommendationGroupID WHERE Recommendation.RecommendationGroupID LIKE '" + Replace(Recommendation_Set__MMColParam, "'", "''") + "' OR 'all' = '" + Replace(Recommendation_Set__MMColParam, "'", "''") + "' ORDER BY RecommendationGroup.RecommendationGroupSortOrder, RecommendationGroup.RecommendationGroupTitle, Recommendation.RecommendationSortOrder, Recommendation.RecommendationTitle" Recommendation_Set.CursorType = 0 Recommendation_Set.CursorLocation = 2 Recommendation_Set.LockType = 1 Recommendation_Set.Open() Recommendation_Set_numRows = 0 %> <% Dim AmazonSearch_Set Dim AmazonSearch_Set_numRows Set AmazonSearch_Set = Server.CreateObject("ADODB.Recordset") AmazonSearch_Set.ActiveConnection = MM_DATA_STRING AmazonSearch_Set.Source = "SELECT * FROM AmazonSearch" AmazonSearch_Set.CursorType = 0 AmazonSearch_Set.CursorLocation = 2 AmazonSearch_Set.LockType = 1 AmazonSearch_Set.Open() AmazonSearch_Set_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Recommendation_Set_numRows = Recommendation_Set_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = -1 Repeat2__index = 0 AmazonSearch_Set_numRows = AmazonSearch_Set_numRows + Repeat2__numRows %> <%=Website_Name%> - <%=Page_Title%>

Recommended Music and Books

 

20000 Voices runs a huge variety of projects - many of which introduce singers to new ideas and music styles. We also run courses and workshops extending people's interest and awareness of vocal matters. We can only scratch the surface of the massive amount of information which is available. Many singers want to research and develop more widely - one way of doing this is through the internet, where you can browse and search for information about your chosen topic.

Up to 15% of each sale made from amazon.co.uk via our website goes towards funding 20,000 Voices Charity. Thankyou

 
<% Dim fs Dim FilePath Set fs=Server.CreateObject("Scripting.FileSystemObject") Dim prevcategory, colcount prevcategory = -1 colcount = 0 %>
<% While ((Repeat1__numRows <> 0) AND (NOT Recommendation_Set.EOF)) %> <% If CInt(Recommendation_Set.Fields.Item("RecommendationGroupID").Value) <> prevcategory Then %>
 

<%=(Recommendation_Set.Fields.Item("RecommendationGroupTitle").Value)%>

 
<% colcount = 0 %> <% End If %> <% If colcount >= 2 Then colcount = 0 %>
 
<% End If %> <% prevcategory = CInt(Recommendation_Set.Fields.Item("RecommendationGroupID").Value) colcount = colcount + 1 %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recommendation_Set.MoveNext() Wend %>
 
 

<% Recommendation_Set.Close() Set Recommendation_Set = Nothing %> <% AmazonSearch_Set.Close() Set AmazonSearch_Set = Nothing %>