%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
var rsArtists__MMColParam = "None";
if (String(Request("MM_EmptyValue")) != "undefined" &&
String(Request("MM_EmptyValue")) != "") {
rsArtists__MMColParam = String(Request("MM_EmptyValue"));
}
%>
<%
var rsArtists_cmd = Server.CreateObject ("ADODB.Command");
rsArtists_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING;
rsArtists_cmd.CommandText = "SELECT * FROM Artists WHERE ArtistThumbNail <> ? ORDER BY ArtistLastName ASC";
rsArtists_cmd.Prepared = true;
rsArtists_cmd.Parameters.Append(rsArtists_cmd.CreateParameter("param1", 200, 1, 255, rsArtists__MMColParam)); // adVarChar
var rsArtists = rsArtists_cmd.Execute();
var rsArtists_numRows = 0;
%>
<%
var HLooper1__numRows = -3;
var HLooper1__index = 0;
rsArtists_numRows += HLooper1__numRows;
%>
MAINVIEW GALLERY | SCOTTSDALE, ARIZONA
|
|
|
<%
var startrw=0;
var endrw=HLooper1__index;
var numberColumns=3;
var numrows=-1;
while((numrows-- !=0) && (!rsArtists.EOF)) {
startrw=endrw + 1;
endrw = endrw + numberColumns;
%>
<%
while ((startrw <= endrw) && (!rsArtists.EOF)) {
%>
|
<%
startrw = startrw+1;
rsArtists.MoveNext();
}
%>
<% }%>
|
|
|
|
|
copyright 2009-2011 MAINVIEW GALLERY L.L.C.
|
|
<%
rsArtists.Close();
%>