<% '//// Receive Search Criteria //// search=request("search")&"" ssearch=replace(search,"'","''") zoneid=request("zoneid")&"" sarchives=request("sarchives") psql="select * from articles where (headline like '%"&ssearch&"%' or article like '%"&ssearch&"%' or summary like '%"&ssearch&"%' or source like '%"&ssearch&"%') and (article not like '' or articleurl not like '')" if zoneid<>"" then psql=psql & " and articleid in (select articleid from iArticlesZones where zoneid="&zoneid&")" end if if sarchives<>"" then psql=psql & " and (status=1 or status=4)" else psql=psql & " and status=1 " end if psql=psql & " order by startdate , headline asc" searchsql=psql mypage=request("whichpage") if mypage="" then mypage=1 mypagesize=10 scriptname="PPL.Search.asp?search="&server.urlencode(search)&"&zoneid="&zoneid&"&sarchives="&sarchives set conn=server.createobject("ADODB.Connection") conn.open connection %> Search articles
HOME   POLITICS   BUSINESS   HEALTH   ENTERTAINMENT   SPORTS   OBITUARIES   AFRICAN NEWS   WRITER'S LOUNGE   COMMENTS   SPECIALS
 

Enter your email to receive Alerts and Breaking News.

Email

Subscribe
Remove

 

The Article you're trying to access may either be archived or can be found via our search mechanism - please search below for article.

Search Results

Keywords :
Category : > Search archives [If you can't find your story, it has been archived.  Please go to Research Vault.]
<% set rs=server.createobject("ADODB.Recordset") rs.open searchsql,conn,1 if not(rs.eof) then maxval=rs.recordcount rs.movefirst rs.pagesize=mypagesize maxcount=cint(rs.pagecount) rs.absolutepage=mypage howmanyrecs=0 howmanyfields=rs.fields.count-1 %> <%else%> <%end if rs.close set rs=nothing conn.close set conn=nothing %>
<% cc=(mypagesize*mypage)-mypagesize if zoneid<>0 then zone="&z="&zoneid do until rs.eof or howmanyrecs>=rs.pagesize cc=cc+1 articleid=rs("articleid") headline=rs("headline") headlinedate=rs("headlinedate") source=rs("source") summary=rs("summary") %> <% rs.movenext howmanyrecs=howmanyrecs+1 loop %>
<%=cc%>. <%=headline%> (<%=headlinedate & " - " & source%>)
<%=server.htmlencode(summary)%>
Articles Found : <%=maxval%>
Page <%=mypage%> of <%=maxcount%>
Go to Page : <%if cint(mypage)>1 then response.write "<< " if cint(mypage)>>"%>

 

No Articles were found for the specified criteria

 

 
     HOME   POLITICS   BUSINESS   HEALTH   ENTERTAINMENT   SPORTS   OBITUARIES   AFRICAN NEWS   WRITER'S LOUNGE   COMMENTS   SPECIALS