%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
var rsArtistGallery__MMColParam = "1";
if (String(Request.QueryString("Artist")) != "undefined" &&
String(Request.QueryString("Artist")) != "") {
rsArtistGallery__MMColParam = String(Request.QueryString("Artist"));
}
%>
<%
var rsArtistGallery_cmd = Server.CreateObject ("ADODB.Command");
rsArtistGallery_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING;
rsArtistGallery_cmd.CommandText = "SELECT * FROM [Artists Query] WHERE ArtistNameToAppear = ? ORDER BY InvTitle ASC";
rsArtistGallery_cmd.Prepared = true;
rsArtistGallery_cmd.Parameters.Append(rsArtistGallery_cmd.CreateParameter("param1", 200, 1, 255, rsArtistGallery__MMColParam)); // adVarChar
var rsArtistGallery = rsArtistGallery_cmd.Execute();
var rsArtistGallery_numRows = 0;
%>
<%
var rsArtist__MMColParam = "1";
if (String(Request.QueryString("Artist")) != "undefined" &&
String(Request.QueryString("Artist")) != "") {
rsArtist__MMColParam = String(Request.QueryString("Artist"));
}
%>
<%
var rsArtist_cmd = Server.CreateObject ("ADODB.Command");
rsArtist_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING;
rsArtist_cmd.CommandText = "SELECT * FROM Artists WHERE ArtistNameToAppear = ?";
rsArtist_cmd.Prepared = true;
rsArtist_cmd.Parameters.Append(rsArtist_cmd.CreateParameter("param1", 200, 1, 255, rsArtist__MMColParam)); // adVarChar
var rsArtist = rsArtist_cmd.Execute();
var rsArtist_numRows = 0;
%>
<%
var HLooper1__numRows = -3;
var HLooper1__index = 0;
rsArtistGallery_numRows += HLooper1__numRows;
%>
MAINVIEW GALLERY | SCOTTSDALE, ARIZONA
|
|
| |
<%=(rsArtist.Fields.Item("ArtistNameToAppear").Value)%> |
| |
| <%=(rsArtist.Fields.Item("Bio").Value)%> |
| |
|
| |
| |
|
|
|
| |
| |
copyright 2009-2011 MAINVIEW GALLERY L.L.C.
|
|
|
<%
rsArtistGallery.Close();
%>
<%
rsArtist.Close();
%>