%@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
|
|
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)) {
%>
">" 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)%> |
|
|
|
|
<%
startrw = startrw+1;
rsResale.MoveNext();
}
%>
|
|
<% }%>
|
<% 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)) {
%>
">" 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)%> |
|
|
|
|
<%
startrw = startrw+1;
Recordset1.MoveNext();
}
%>
<% }%>
<% } // end !Recordset1.EOF || !Recordset1.BOF %> |
|
|
|
|
copyright 2009 MAINVIEW GALLERY L.L.C.
|
|
<%
rsResale.Close();
%>
<%
Recordset1.Close();
%>