Search Results

<%genre=request("genre")%> <% if genre <> "" then sql = "SELECT bandname, imgpath, pagepath FROM bands WHERE genre = " & genre Set Rs = Server.CreateObject("ADODB.Recordset") set Rs.ActiveConnection = Conn Rs.LockType = adLockReadOnly Rs.CursorType = adOpenForwardOnly Rs.Open sql 'Do until Rs.EOF ' response.write Rs("bandname") & "
" ' Rs.movenext 'Loop response.write "" response.write "" rowcount = 0 Do until Rs.EOF rowcount = rowcount + 1 response.write "" 'if rowcount = 6 then response.write "" if rowcount = 3 then response.write "" rowcount = 0 end if Rs.movenext Loop response.write "
" response.write "" if Rs("pagepath") <> "" then response.write "" response.write Rs("bandname") response.write "" else response.write Rs("bandname") end if response.write "

" if Rs("imgpath") <> "" then response.write "
" end if response.write "

" Rs.Close Set Rs = Nothing Conn.Close Set Conn = Nothing end if %>

Bandtunes.com

The home of all musicians on the Web tm

copyright 2001 BT Media LLC