%@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
|
|
|
"> |
<%=(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 %>
|
|
|
|
|
|
|
|
|
|
|
copyright 2009-2011 MAINVIEW GALLERY L.L.C.
|
|
<%
rsArtistGallery.Close();
%>
<%
rsSOLD.Close();
%>