Brobst Violin Shop - Instruments for the Advancing Player

<% sql = "select * from category" 'response.write(sql) sql = sql & " having category_id>1 " rs.open sql, conn, 3, 3 if rs.eof then %> <% else %>

Brobst Violin Shop offers several models of violin, viola, cello and bass for the aspiring player. Each instrument is carefully crafted from seasoned maple and spruce, hand varnished, and meticulously shop-adjusted to ensure ease in tuning and comfort of fingering. Because each players needs are different, we offer instruments from a variety of makers to satisfy each and every customer.

No Instruments are available for viewing at this time. Please check back soon.

<% rs.movefirst do while not rs.eof sql2 = "Select count(*) as reccnt from master where category_id=" & rs.fields("category_id").value rs2.open sql2, conn, 3, 3 reccnt = rs2.fields("reccnt").value rs2.close if len(reccnt)=0 or isnull(reccnt) then reccnt=0 if reccnt>0 then %> <% if reccnt<=6 then sql2 = "Select * from master where category_id=" & rs.fields("category_id").value & " order by IType, LastName " rs2.open sql2, conn, 3, 3 do while not rs2.eof %> <% rs2.movenext loop rs2.close else %> <% end if end if rs.movenext loop end if rs.close set rs=Nothing set conn=nothing %>

<%=rs.fields("category").value%>

"><%=rs2.fields("Instrument").value & " - " & rs2.fields("alttag").value%>

"><%=reccnt%> Instruments found

Find an Instrument for Advancing Players By Type

Violin Viola Cello Bass