<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var rsResale__prmArtistName = "Pino"; if (String("Pino") != "undefined" && String("Pino") != "") { rsResale__prmArtistName = String("Pino"); } %> <% var rsResale_cmd = Server.CreateObject ("ADODB.Command"); rsResale_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsResale_cmd.CommandText = "SELECT * FROM Inventory, Artists WHERE InvResale= True AND ArtistUsername= InvArtistUsername AND ArtistUsername=? ORDER BY ArtistLastName, InvTitle"; rsResale_cmd.Prepared = true; rsResale_cmd.Parameters.Append(rsResale_cmd.CreateParameter("param1", 200, 1, 255, rsResale__prmArtistName)); // adVarChar var rsResale = rsResale_cmd.Execute(); var rsResale_numRows = 0; %> <% var Recordset1__prmArtistName = "Pino"; if (String("Pino") != "undefined" && String("Pino") != "") { Recordset1__prmArtistName = String("Pino"); } %> <% var Recordset1_cmd = Server.CreateObject ("ADODB.Command"); Recordset1_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; Recordset1_cmd.CommandText = "SELECT * FROM Inventory, Artists WHERE InvResale= True AND ArtistUsername= InvArtistUsername AND ArtistUsername<>? ORDER BY ArtistLastName, InvTitle"; Recordset1_cmd.Prepared = true; Recordset1_cmd.Parameters.Append(Recordset1_cmd.CreateParameter("param1", 200, 1, 255, Recordset1__prmArtistName)); // adVarChar var Recordset1 = Recordset1_cmd.Execute(); var Recordset1_numRows = 0; %> <% var HLooper1__numRows = -3; var HLooper1__index = 0; rsResale_numRows += HLooper1__numRows; %> <% var HLooper2__numRows = 9; var HLooper2__index = 0; Recordset1_numRows += HLooper2__numRows; %> MAINVIEW GALLERY | SCOTTSDALE, ARIZONA

Mainview Gallery Scottsdale, AZ

   

7137 E. Main Street
Scottsdale, AZ 85251

(480)990-1515

E-MAIL:

MAINVIEWGALLERY@AOL.COM

MAINVIEW
GALLERY
 
Home
Artists
About
Events
Contact
Tour
Re-Sale
 
<% var startrw=0; var endrw=HLooper1__index; var numberColumns=3; var numrows=-1; while((numrows-- !=0) && (!rsResale.EOF)) { startrw=endrw + 1; endrw = endrw + numberColumns; %> <% while ((startrw <= endrw) && (!rsResale.EOF)) { %> <% startrw = startrw+1; rsResale.MoveNext(); } %> <% }%>
">" width="300" height="300">  
 
<%=(rsResale.Fields.Item("ArtistNameToAppear").Value)%>
 
<%=(rsResale.Fields.Item("InvMedium").Value)%>  <%=(rsResale.Fields.Item("InvHeight").Value)%>" x <%=(rsResale.Fields.Item("InvWidth").Value)%>"
 
<%=(rsResale.Fields.Item("Sold").Value)%>
 
   
 
 
<% if (!Recordset1.EOF || !Recordset1.BOF) { %> <% var startrw=0; var endrw=HLooper2__index; var numberColumns=3; var numrows=3; while((numrows-- !=0) && (!Recordset1.EOF)) { startrw=endrw + 1; endrw = endrw + numberColumns; %> <% while ((startrw <= endrw) && (!Recordset1.EOF)) { %> <% startrw = startrw+1; Recordset1.MoveNext(); } %> <% }%>
">" alt="" width="300" height="300">  
 
<%=(Recordset1.Fields.Item("ArtistNameToAppear").Value)%>
 
<%=(Recordset1.Fields.Item("InvMedium").Value)%>  <%=(Recordset1.Fields.Item("InvHeight").Value)%>" x <%=(Recordset1.Fields.Item("InvWidth").Value)%>"
 
<%=(Recordset1.Fields.Item("Sold").Value)%>
 
   
<% } // end !Recordset1.EOF || !Recordset1.BOF %>
  Home Artists About Events ContactTour
 
 
copyright 2009 MAINVIEW GALLERY L.L.C.
<% rsResale.Close(); %> <% Recordset1.Close(); %>