% search=Trim(request("searchfor")) If replace(search,"'","''")<>"" then Set RS=server.createobject("ADODB.recordset") SQL="Select * from Records where (Title like '%"&search&"%') and (status='' or isnull(status)) " SQL=SQL & " order by date" call openrs(RS,SQL) If RS.RECORDCOUNT<>0 then numResults=RS.RECORDCOUNT PageSize=50 rs.pagesize=PageSize If request.querystring("page")<>"" then currpage=cint(request.querystring("page")) Else currpage=1 End If rs.AbsolutePage=CINT(currpage) rowcount=0 'Title= numResults & " Results found for "&search Title="Following result(s) found for "&search Else Title="Sorry, there are no results for '"&search&"'.
Can't find what you are looking for?
Try browsing by series or our calendar.
Also, remember that you can enter anything in the search field above. (Examples include: a month of the year, a composer, an instrument, a song, or anything relating to the event you are looking for.)
|
|||||||||||
![]() |
| |
Web Site Design by Design Extensions