<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var rsArtistGallery__MMColParam = "576"; if (String(Request.QueryString("InvID")) != "undefined" && String(Request.QueryString("InvID")) != "") { rsArtistGallery__MMColParam = String(Request.QueryString("InvID")); } %> <% var rsArtistGallery_cmd = Server.CreateObject ("ADODB.Command"); rsArtistGallery_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsArtistGallery_cmd.CommandText = "SELECT InvID, InvTitle, InvMedium, InvHeight, InvWidth, InvDepth, InvPrice, InvDescription, InvThumb, InvDetail, Sold, ArtistNameToAppear, ArtistID, ArtistUsername, InvArtistUsername FROM Inventory, Artists WHERE InvID = ? AND InvArtistUsername= ArtistUsername ORDER BY InvTitle ASC"; rsArtistGallery_cmd.Prepared = true; rsArtistGallery_cmd.Parameters.Append(rsArtistGallery_cmd.CreateParameter("param1", 5, 1, -1, rsArtistGallery__MMColParam)); // adDouble var rsArtistGallery = rsArtistGallery_cmd.Execute(); var rsArtistGallery_numRows = 0; %> <% var rsSOLD__MMColParam = "1"; 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; %> 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
 
">

<%=(rsArtistGallery.Fields.Item("InvTitle").Value)%>
by <%=(rsArtistGallery.Fields.Item("ArtistNameToAppear").Value)%>
<%=(rsArtistGallery.Fields.Item("InvHeight").Value)%>" x <%=(rsArtistGallery.Fields.Item("InvWidth").Value)%>"   <%=(rsArtistGallery.Fields.Item("InvMedium").Value)%>
<% if (!rsSOLD.EOF || !rsSOLD.BOF) { %> <%= DoCurrency((rsArtistGallery.Fields.Item("InvPrice").Value), -1, -2, -2, -2) %> <% } // end !rsSOLD.EOF || !rsSOLD.BOF %>
<% if (rsSOLD.EOF && rsSOLD.BOF) { %> SOLD <% } // end rsSOLD.EOF && rsSOLD.BOF %>


 
Back
 
 
 
 
copyright 2009-2011 MAINVIEW GALLERY L.L.C.
<% rsArtistGallery.Close(); %> <% rsSOLD.Close(); %>