<% ' Create a recordset object to store specific table information Set objRS = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblAlphabet" 'Set the recordset object equal to the SQL query string objRS.Open SQL, objADO, 1, 3 ' Create a recordset object to store specific table information Set objRS2 = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select distinct AgencyName From TblLogin where (AccessLevel = '3' or AccessLevel = '7') order by AgencyName" 'Set the recordset object equal to the SQL query string objRS2.Open SQL, objADO, 1, 3 ' Create a recordset object to store specific table information Set objRS3 = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblStates order by StateId" 'Set the recordset object equal to the SQL query string objRS3.Open SQL, objADO, 1, 3 ' Create a recordset object to store specific table information Set objRS4 = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblGenres" 'Set the recordset object equal to the SQL query string objRS4.Open SQL, objADO, 1, 3 %>

BAND SEARCH

Find a band by alphabetical listing, name, or state.

1. Find A Band by Alphabetical Listing:
<% while not objRS.EOF %> <% objRs.MoveNext %> <% wend %>

"><%= objRS("Alphabet") %>

2. Find A Band By Name:

3. Find A Band By Genre:

4. Find A Band by State / Province / Territory: