<%@LANGUAGE="VBSCRIPT"%> <% set Rsok = Server.CreateObject("ADODB.Recordset") Rsok.ActiveConnection = MM_conncanto_STRING Rsok.Source = "SELECT * FROM QueryOk WHERE Price<>0 AND autore<>'on demand' AND autore<>'napoli' ORDER BY autore" Rsok.CursorType = 0 Rsok.CursorLocation = 2 Rsok.LockType = 3 Rsok.Open() Rsok_numRows = 0 %> <% set Rsgratis = Server.CreateObject("ADODB.Recordset") Rsgratis.ActiveConnection = MM_conncanto_STRING Rsgratis.Source = "SELECT * FROM QueryOk WHERE Price=0 and Autore<>'napoli' ORDER BY autore" Rsgratis.CursorType = 0 Rsgratis.CursorLocation = 2 Rsgratis.LockType = 3 Rsgratis.Open() Rsgratis_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Rsgratis_numRows = Rsgratis_numRows + Repeat1__numRows %> <% Repeat1__numRows = -1 Repeat1__index = 0 Rsok_numRows = Rsok_numRows + Repeat1__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables ' set the record count Rsok_total = Rsok.RecordCount ' set the number of rows displayed on this page If (Rsok_numRows < 0) Then Rsok_numRows = Rsok_total Elseif (Rsok_numRows = 0) Then Rsok_numRows = 1 End If ' set the first and last displayed record Rsok_first = 1 Rsok_last = Rsok_first + Rsok_numRows - 1 ' if we have the correct record count, check the other stats If (Rsok_total <> -1) Then If (Rsok_first > Rsok_total) Then Rsok_first = Rsok_total If (Rsok_last > Rsok_total) Then Rsok_last = Rsok_total If (Rsok_numRows > Rsok_total) Then Rsok_numRows = Rsok_total End If %> <% Dim MM_paramName %> <% ' *** Move To Record and Go To Record: declare variables Set MM_rs = Rsok MM_rsCount = Rsok_total MM_size = Rsok_numRows MM_uniqueCol = "" MM_paramName = "" MM_offset = 0 MM_atTotal = false MM_paramIsDefined = false If (MM_paramName <> "") Then MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "") End If %> <% ' *** Move To Record: handle 'index' or 'offset' parameter if (Not MM_paramIsDefined And MM_rsCount <> 0) then ' use index parameter if defined, otherwise use offset parameter r = Request.QueryString("index") If r = "" Then r = Request.QueryString("offset") If r <> "" Then MM_offset = Int(r) ' if we have a record count, check if we are past the end of the recordset If (MM_rsCount <> -1) Then If (MM_offset >= MM_rsCount Or MM_offset = -1) Then ' past end or move last If ((MM_rsCount Mod MM_size) > 0) Then ' last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' move the cursor to the selected record i = 0 While ((Not MM_rs.EOF) And (i < MM_offset Or MM_offset = -1)) MM_rs.MoveNext i = i + 1 Wend If (MM_rs.EOF) Then MM_offset = i ' set MM_offset to the last possible record End If %> <% ' *** Move To Record: if we dont know the record count, check the display range If (MM_rsCount = -1) Then ' walk to the end of the display range for this page i = MM_offset While (Not MM_rs.EOF And (MM_size < 0 Or i < MM_offset + MM_size)) MM_rs.MoveNext i = i + 1 Wend ' if we walked off the end of the recordset, set MM_rsCount and MM_size If (MM_rs.EOF) Then MM_rsCount = i If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount End If ' if we walked off the end, set the offset based on page size If (MM_rs.EOF And Not MM_paramIsDefined) Then If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then If ((MM_rsCount Mod MM_size) > 0) Then MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' reset the cursor to the beginning If (MM_rs.CursorType > 0) Then MM_rs.MoveFirst Else MM_rs.Requery End If ' move the cursor to the selected record i = 0 While (Not MM_rs.EOF And i < MM_offset) MM_rs.MoveNext i = i + 1 Wend End If %> <% ' *** Move To Record: update recordset stats ' set the first and last displayed record Rsok_first = MM_offset + 1 Rsok_last = MM_offset + MM_size If (MM_rsCount <> -1) Then If (Rsok_first > MM_rsCount) Then Rsok_first = MM_rsCount If (Rsok_last > MM_rsCount) Then Rsok_last = MM_rsCount End If ' set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount) %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each Item In Request.QueryString NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item)) End If Next ' add the Form variables to the MM_keepForm string For Each Item In Request.Form NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) if (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <% ' *** Move To Record: set the strings for the first, last, next, and previous links MM_keepMove = MM_keepBoth MM_moveParam = "index" ' if the page has a repeated region, remove 'offset' from the maintained parameters If (MM_size > 0) Then MM_moveParam = "offset" If (MM_keepMove <> "") Then params = Split(MM_keepMove, "&") MM_keepMove = "" For i = 0 To UBound(params) nextItem = Left(params(i), InStr(params(i),"=") - 1) If (StrComp(nextItem,MM_moveParam,1) <> 0) Then MM_keepMove = MM_keepMove & "&" & params(i) End If Next If (MM_keepMove <> "") Then MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1) End If End If End If ' set the strings for the move to links If (MM_keepMove <> "") Then MM_keepMove = MM_keepMove & "&" urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "=" MM_moveFirst = urlStr & "0" MM_moveLast = urlStr & "-1" MM_moveNext = urlStr & Cstr(MM_offset + MM_size) prev = MM_offset - MM_size If (prev < 0) Then prev = 0 MM_movePrev = urlStr & Cstr(prev) %> イタリア・オペラ - 入手可能なオペラ・アリア <% While ((Repeat1__numRows <> 0) AND (NOT Rsok.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Rsok.MoveNext() Wend %>
イタリア・オペラを歌う人のためのサイトです
ホームページ English 日本語 Italiano アリアをお選び下さい アリアをリクエストして下さい ナポリ民謡(カンツォーネ) お問い合わせ
入手可能な曲の一覧表
作曲家 オペラ アリア 登場人物 声域 価格 (ユーロ) 無料です!
Bellini Vincenzo La sonnambula Vi ravviso o luoghi ameni Rodolfo basso Free! アリアをダウンロードして下さい。
Bellini Vincenzo La sonnambula Oh! se una volta sola Amina soprano Free! アリアをダウンロードして下さい。
Bellini Vincenzo La sonnambula Ah non credea mirarti Amina soprano Free! アリアをダウンロードして下さい。
Bellini Vincenzo I Puritani Son vergin vezzosa Elvira soprano Free! アリアをダウンロードして下さい。
Bellini Vincenzo I Puritani Oh rendetemi la speme Elvira soprano Free! アリアをダウンロードして下さい。
Bellini Vincenzo Norma Casta diva Norma soprano Free! アリアをダウンロードして下さい。
Bellini Vincenzo La sonnambula Come per me sereno Amina soprano Free! アリアをダウンロードして下さい。
Bononcini G.G. 17th-Century Italian Songs Deh, a me piu non v'ascondete on demand Free! アリアをダウンロードして下さい。
Donizetti Gaetano Don Pasquale Bella siccome un angelo Malatesta baritono Free! アリアをダウンロードして下さい。
Donizetti Gaetano L'elisir d'amore Una furtiva lagrima Nemorino tenore Free! アリアをダウンロードして下さい。
Gian Giacomo Carissimi 17th-Century Italian Songs Vittoria Vittoria on demand Free! アリアをダウンロードして下さい。
Mozart W.A. Le nozze di Figaro Non so pi・cosa son cosa faccio Cherubino mezzosoprano Free! アリアをダウンロードして下さい。
Mozart W.A. Don Giovanni Batti, batti, o bel Masetto Zerlina soprano Free! アリアをダウンロードして下さい。
Mozart W.A. Le nozze di Figaro Deh vieni non tardar Susanna soprano Free! アリアをダウンロードして下さい。
Mozart W.A. Le nozze di Figaro Porgi amor Contessa soprano Free! アリアをダウンロードして下さい。
Mozart W.A. Le nozze di Figaro Voi che sapete Cherubino mezzosoprano Free! アリアをダウンロードして下さい。
Rossini Gioacchino Il barbiere di Siviglia La calunnia Don Basilio basso Free! アリアをダウンロードして下さい。
Verdi Giuseppe La Traviata Addio del passato (la lettera) Violetta soprano Free! アリアをダウンロードして下さい。
Verdi Giuseppe La Traviata Di Provenza il mare il suol Germont baritono Free! アリアをダウンロードして下さい。
Verdi Giuseppe La Traviata Pura siccome un angelo Germont baritono Free! アリアをダウンロードして下さい。
Verdi Giuseppe Il Trovatore Stride la vampa Azucena mezzosoprano Free! アリアをダウンロードして下さい。
お探しの曲を見つけられませんでしたか? リクエストして下さい!
リクエストされた曲は、直接あなたの電子メール・ボックスに、ZIP形式に圧縮して送られます。


さあ、リクエストして下さい!
ホームページ English 日本語 Italiano アリアをお選び下さい アリアをリクエストして下さい ナポリ民謡(カンツォーネ) お問い合わせ

© 2007- Non-profit association "Cantare l'Opera" ©
All rights reserved
Use of text, images, layout, format, look, or feel of these pages,
without the written permission of the copyright holder is strictly prohibited.
Policy

<% Rsok.Close() %> <% Rsgratis.Close() %>