MAINVIEW GALLERY | SCOTTSDALE, ARIZONA

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var rsArtistGallery__MMColParam = "1"; if (String(Request.QueryString("Category")) != "undefined" && String(Request.QueryString("Category")) != "") { rsArtistGallery__MMColParam = String(Request.QueryString("Category")); } %> <% var rsArtistGallery_cmd = Server.CreateObject ("ADODB.Command"); rsArtistGallery_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsArtistGallery_cmd.CommandText = "SELECT * FROM Inventory WHERE InvJewelCategory = ? And InvCategory=1"; 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 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

Mainview Gallery Scottsdale, AZ

7120 E. Main Street
Scottsdale, AZ 85251

(480)990-1515

E-MAIL:
MAINVIEWGALLERY@AOL.COM

MAINVIEW
GALLERY

Click Images to Enlarge

<% var startrw=0; var endrw=HLooper1__index; var numberColumns=3; var numrows=-1; while((numrows-- !=0) && (!rsArtistGallery.EOF)) { startrw=endrw + 1; endrw = endrw + numberColumns; %> <% while ((startrw <= endrw) && (!rsArtistGallery.EOF)) { %> <% startrw = startrw+1; rsArtistGallery.MoveNext(); } %> <% }%>

" width="300" height="300">

"><%=(rsArtistGallery.Fields.Item("InvTitle").Value)%>
<%= DoCurrency((rsArtistGallery.Fields.Item("InvPrice").Value), 2, -2, -2, -2) %>

For immediate assistance/questions contact Steve Shorr at 480.748.9100

<% rsArtistGallery.Close(); %> <% rsArtist.Close(); %>