<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var rsArtistGallery_cmd = Server.CreateObject ("ADODB.Command"); rsArtistGallery_cmd.ActiveConnection = MM_cnMAINVIEWDB_STRING; rsArtistGallery_cmd.CommandText = "SELECT * FROM JewelryCategories"; rsArtistGallery_cmd.Prepared = true; 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
  
  Home Artists About Events Contact Tour
Resale
 
Romanov Fine Jewelry
 

 
<% 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(); } %> <% }%>
Back
For immediate assistance/questions contact Steve Shorr at 480.748.9100
 
  Home Artists About Events Contact Tour Resale
 
 
copyright 2009-2011 MAINVIEW GALLERY L.L.C.
<% rsArtistGallery.Close(); %> <% rsArtist.Close(); %>