<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var rsArtistGallery__MMColParam = "J.D. Challenger"; if (String(Request.QueryString("Artist")) != "undefined" && String(Request.QueryString("Artist")) != "") { rsArtistGallery__MMColParam = String(Request.QueryString("Artist")); } %> <% var rsArtistGallery__MediumParam = "Giclee"; if (String("Giclee") != "undefined" && String("Giclee") != "") { rsArtistGallery__MediumParam = String("Giclee"); } %> <% var rsArtist__MMColParam = "1"; if (String(Request.QueryString("Artist")) != "undefined" && String(Request.QueryString("Artist")) != "") { rsArtist__MMColParam = String(Request.QueryString("Artist")); } %> <% var rsArtist_cmd = Server.CreateObject ("ADODB.Command"); rsArtist_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsArtist_cmd.CommandText = "SELECT * FROM Artists WHERE ArtistNameToAppear = ?"; rsArtist_cmd.Prepared = true; rsArtist_cmd.Parameters.Append(rsArtist_cmd.CreateParameter("param1", 200, 1, 255, rsArtist__MMColParam)); // adVarChar var rsArtist = rsArtist_cmd.Execute(); var rsArtist_numRows = 0; %> <% var rsArtistGallery_cmd = Server.CreateObject ("ADODB.Command"); rsArtistGallery_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsArtistGallery_cmd.CommandText = "SELECT * FROM [Artists Query] WHERE ArtistNameToAppear = ? AND InvMedium<>? AND InvPrice >1 ORDER BY InvMedium DESC, InvTitle ASC"; rsArtistGallery_cmd.Prepared = true; rsArtistGallery_cmd.Parameters.Append(rsArtistGallery_cmd.CreateParameter("param1", 200, 1, 255, rsArtistGallery__MMColParam)); // adVarChar rsArtistGallery_cmd.Parameters.Append(rsArtistGallery_cmd.CreateParameter("param2", 200, 1, 255, rsArtistGallery__MediumParam)); // adVarChar var rsArtistGallery = rsArtistGallery_cmd.Execute(); var rsArtistGallery_numRows = 0; %> <% var rsGiclees__MMColParam = "J.D. Challenger"; if (String(Request.QueryString("Artist")) != "undefined" && String(Request.QueryString("Artist")) != "") { rsGiclees__MMColParam = String(Request.QueryString("Artist")); } %> <% var rsGiclees__MediumParam = "Giclee"; if (String("Giclee") != "undefined" && String("Giclee") != "") { rsGiclees__MediumParam = String("Giclee"); } %> <% var rsGiclees_cmd = Server.CreateObject ("ADODB.Command"); rsGiclees_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsGiclees_cmd.CommandText = "SELECT * FROM [Artists Query] WHERE ArtistNameToAppear = ? AND InvMedium=? ORDER BY InvTitle ASC"; rsGiclees_cmd.Prepared = true; rsGiclees_cmd.Parameters.Append(rsGiclees_cmd.CreateParameter("param1", 200, 1, 255, rsGiclees__MMColParam)); // adVarChar rsGiclees_cmd.Parameters.Append(rsGiclees_cmd.CreateParameter("param2", 200, 1, 255, rsGiclees__MediumParam)); // adVarChar var rsGiclees = rsGiclees_cmd.Execute(); var rsGiclees_numRows = 0; %> <% var rsSOLD__MMColParam = "579"; if (String(Request.QueryString("InvID")) != "undefined" && String(Request.QueryString("InvID")) != "") { rsSOLD__MMColParam = String(Request.QueryString("InvID")); } %> <% var rsSOLD_cmd = Server.CreateObject ("ADODB.Command"); rsSOLD_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsSOLD_cmd.CommandText = "SELECT InvPrice FROM Inventory WHERE InvID = ? AND InvPrice> 1"; rsSOLD_cmd.Prepared = true; rsSOLD_cmd.Parameters.Append(rsSOLD_cmd.CreateParameter("param1", 5, 1, -1, rsSOLD__MMColParam)); // adDouble var rsSOLD = rsSOLD_cmd.Execute(); var rsSOLD_numRows = 0; %> <% var HLooper1__numRows = -3; var HLooper1__index = 0; rsArtistGallery_numRows += HLooper1__numRows; %> MAINVIEW GALLERY | SCOTTSDALE, ARIZONA

Mainview Gallery Scottsdale, AZ

    

7120 E. Main Street
Scottsdale, AZ 85251

(480)990-1515

E-MAIL:
MAINVIEWGALLERY@AOL.COM
MAINVIEW
GALLERY
  
  Home Artists About Events Contact Tour
Resale
 
<%=(rsArtist.Fields.Item("ArtistNameToAppear").Value)%>
<%=(rsArtist.Fields.Item("ArtistSubtitle").Value)%>
<% if (!rsArtistGallery.EOF || !rsArtistGallery.BOF) { %> " class="style1 style7 style8">Biography <% } // end !rsArtistGallery.EOF || !rsArtistGallery.BOF %>
 

<% if (!rsGiclees.EOF || !rsGiclees.BOF) { %> Originals <% } // end !rsGiclees.EOF || !rsGiclees.BOF %>
Click Image to Enlarge

<% var startrw=0; var endrw=HLooper1__index; var numberColumns=3; var numrows=-1; while((numrows-- !=0) && (!rsArtistGallery.EOF)) { startrw=endrw + 1; endrw = endrw + numberColumns; %> <% while ((startrw <= endrw) && (!rsArtistGallery.EOF)) { %> <% startrw = startrw+1; rsArtistGallery.MoveNext(); } %> <% }%>
">" width="300" height="300">

"><%=(rsArtistGallery.Fields.Item("InvTitle").Value)%>
<%=(rsArtistGallery.Fields.Item("InvMedium").Value)%>   <%=(rsArtistGallery.Fields.Item("InvHeight").Value)%>" x <%=(rsArtistGallery.Fields.Item("InvWidth").Value)%>"
<%= DoCurrency((rsArtistGallery.Fields.Item("InvPrice").Value), -1, -2, -2, -2) %>
 
<% if (!rsGiclees.EOF || !rsGiclees.BOF) { %>
 
Giclees
Click Image to Enlarge
 
<% var startrw=0; var endrw=HLooper1__index; var numberColumns=3; var numrows=-1; while((numrows-- !=0) && (!rsGiclees.EOF)) { startrw=endrw + 1; endrw = endrw + numberColumns; %> <% while ((startrw <= endrw) && (!rsGiclees.EOF)) { %> <% startrw = startrw+1; rsGiclees.MoveNext(); } %> <% }%>
">" alt="" width="300" height="300">
"><%=(rsGiclees.Fields.Item("InvTitle").Value)%>
<%=(rsGiclees.Fields.Item("InvMedium").Value)%>   <%=(rsGiclees.Fields.Item("InvHeight").Value)%>" x <%=(rsGiclees.Fields.Item("InvWidth").Value)%>"
<%= DoCurrency((rsGiclees.Fields.Item("InvPrice").Value), 2, -2, -2, -2) %>
 
<% } // end !rsGiclees.EOF || !rsGiclees.BOF %>
  Home Artists About Events Contact Tour Resale
 
 
copyright 2009-2011 MAINVIEW GALLERY L.L.C.
<% rsArtistGallery.Close(); %> <% rsGiclees.Close(); %> <% rsSOLD.Close(); %> <% rsArtist.Close(); %>