rendered paste body<html> <head> <link rel="stylesheet" type="text/css" href="style.css"> <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.FP_CharSet = "windows-1252"FP_CodePage = 1252 %></head> <body link="white" alink="white" vlink="white"> <center> <div id="banner"> <a href="index.htm"> <img border="0" src="banner.jpg" width="750" height="130"> </a> </div> </center> <br> <center> <div id="navbar"> <FONT COLOR="white"><a href="../login/register_new.asp">Register</a> | <a href="../login/Login.asp">Login</a> | <a href="browse.asp">Browse</a> </font> </div> </center> <center> <FONT COLOR="white"> <br> <div id="users" style="width: 557px; height: 379px"> <h2>Browse Bloggers</h2> A list of all the bloggers in the site is right here:<form BOTID="3" METHOD="POST" action="browse.asp"> <input type="hidden" name="fpdbr_3_PagingMove" value=" |< "> <p><nobr> <!--webbot bot="DatabaseRegionStart" s-columnnames="owner" s-columntypes="202" s-dataconnection="blog_database" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="owner" s-menuvalue="owner" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="owner" s-criteria s-order s-sql="SELECT DISTINCT Results.owner<br>FROM Results<br>ORDER BY Results.owner;" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="4" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " startspan --><!--#include file="../_fpclass/fpdblib.inc"--><% if 0 then %><SCRIPT Language="JavaScript">document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");</SCRIPT><% end if %><%fp_sQry="SELECT DISTINCT Results.owner FROM Results ORDER BY Results.owner;"fp_sDefault=""fp_sNoRecords="No records returned."fp_sDataConn="blog_database"fp_iMaxRecords=256fp_iCommandType=1fp_iPageSize=0fp_fTableFormat=Falsefp_fMenuFormat=Truefp_sMenuChoice="owner"fp_sMenuValue="owner"fp_sColTypes="&owner=202&"fp_iDisplayCols=1fp_fCustomQuery=TrueBOTID=4fp_iRegion=BOTID%><!--webbot bot="DatabaseRegionStart" endspan i-checksum="44289" --><select NAME="owner" SIZE="1"> <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" --> <option><%=FP_FieldHTML(fp_rs,"owner")%></option> <!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" --> </select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --></nobr></p> <br> <input TYPE="submit" value="View Blogs"><!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --><p> </p> </form> <!--webbot bot="DatabaseRegionStart" s-columnnames="db_submission_key,owner,blog_title,submission_date,no_views,comment_bodys,no_comments,blog_body,Remote_computer_name,User_name,Browser_type,Timestamp" s-columntypes="3,202,202,202,2,202,202,203,202,202,202,135" s-dataconnection="blog_database" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-listformat="0" b-makeform="TRUE" s-recordsource="Results" s-displaycolumns="db_submission_key,owner,blog_title" s-criteria="[owner] EQ {owner} +" s-order s-sql="SELECT * FROM Results WHERE (owner = '::owner::')" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="owner=" s-norecordsfound="Please select a blogger" i-maxrecords="256" i-groupsize="0" botid="3" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdblib.inc"--><% if 0 then %><SCRIPT Language="JavaScript">document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");</SCRIPT><% end if %><%fp_sQry="SELECT * FROM Results WHERE (owner = '::owner::')"fp_sDefault="owner="fp_sNoRecords="Please select a blogger"fp_sDataConn="blog_database"fp_iMaxRecords=256fp_iCommandType=1fp_iPageSize=0fp_fTableFormat=Falsefp_fMenuFormat=Falsefp_sMenuChoice=""fp_sMenuValue=""fp_sColTypes="&db_submission_key=3&owner=202&blog_title=202&submission_date=202&no_views=2&comment_bodys=202&no_comments=202&blog_body=203&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"fp_iDisplayCols=3fp_fCustomQuery=FalseBOTID=3fp_iRegion=BOTID%><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="DatabaseRegionStart" endspan i-checksum="38910" --><p> <b> <!--webbot bot="DatabaseResultColumn" s-columnnames="db_submission_key,owner,blog_title,submission_date,no_views,comment_bodys,no_comments,blog_body,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="owner" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>owner<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"owner")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12325" -->'s Blogs:</b> <a href="browseComment.asp?db_submission_key=<%=FP_FieldURL(fp_rs,"db_submission_key")%>&owner=<%=FP_FieldURL(fp_rs,"owner")%>"> <!--webbot bot="DatabaseResultColumn" s-columnnames="db_submission_key,owner,blog_title,submission_date,no_views,comment_bodys,no_comments,blog_body,Remote_computer_name,User_name,Browser_type,Timestamp" s-column="blog_title" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>blog_title<font size="-1">&gt;&gt;</font>" s-ColumnTypes="3,202,202,202,2,202,202,203,202,202,202,135" startspan --><%=FP_FieldVal(fp_rs,"blog_title")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30854" --></a></p> <!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --><p><br> </div> <br> <div id="popularity"> <h2>Browse Popular</h2> The most viewed blogs are listed here.<br> <h3>Most Popular:</h3> </div> <br> <div id="commented"> <h2>Browse Most Commented</h2> The most commented-on blogs are listed here.<br> <h3>Most Commented:</h3> <!--webbot bot="DatabaseRegionStart" s-columnnames="db_submission_key,owner,blog_title,submission_date,CountOfcomment" s-columntypes="3,202,202,202,3" s-dataconnection="blog_database" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="db_submission_key,owner,blog_title,submission_date,CountOfcomment" s-criteria s-order s-sql="SELECT Results.db_submission_key, Results.owner, Results.blog_title, Results.submission_date, Count(comments.comment) AS CountOfcomment<br>FROM Results INNER JOIN comments ON Results.db_submission_key = comments.db_submission_key<br>GROUP BY Results.db_submission_key, Results.owner, Results.blog_title, Results.submission_date<br>ORDER BY Count(comments.comment) DESC;<br>" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="20" botid="2" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdblib.inc"--><% if 0 then %><SCRIPT Language="JavaScript">document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");</SCRIPT><% end if %><%fp_sQry="SELECT Results.db_submission_key, Results.owner, Results.blog_title, Results.submission_date, Count(comments.comment) AS CountOfcomment FROM Results INNER JOIN comments ON Results.db_submission_key = comments.db_submission_key GROUP BY Results.db_submission_key, Results.owner, Results.blog_title, Results.submission_date ORDER BY Count(comments.comment) DESC; "fp_sDefault=""fp_sNoRecords="No records returned."fp_sDataConn="blog_database"fp_iMaxRecords=256fp_iCommandType=1fp_iPageSize=20fp_fTableFormat=Falsefp_fMenuFormat=Falsefp_sMenuChoice=""fp_sMenuValue=""fp_sColTypes="&db_submission_key=3&owner=202&blog_title=202&submission_date=202&CountOfcomment=3&"fp_iDisplayCols=5fp_fCustomQuery=TrueBOTID=2fp_iRegion=BOTID%><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="DatabaseRegionStart" endspan i-checksum="51132" --><p> <b> <!--webbot bot="DatabaseResultColumn" s-columnnames="db_submission_key,owner,blog_title,submission_date,CountOfcomment" s-column="owner" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>owner<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"owner")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12325" -->:</b> <a href="browseComment.asp?db_submission_key=<%=FP_FieldURL(fp_rs,"db_submission_key")%>&owner=<%=FP_FieldURL(fp_rs,"owner")%>"> <!--webbot bot="DatabaseResultColumn" s-columnnames="db_submission_key,owner,blog_title,submission_date,CountOfcomment" s-column="blog_title" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>blog_title<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"blog_title")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30854" --></a> <b>Comments</b>(<!--webbot bot="DatabaseResultColumn" s-columnnames="db_submission_key,owner,blog_title,submission_date,CountOfcomment" s-column="CountOfcomment" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>CountOfcomment<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"CountOfcomment")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="42765" -->)</p> <!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="20" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD VALIGN=MIDDLE><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/20]</NOBR><BR></td></tr></table>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --><p> </div> </font> </center> <font size="1"> <center> blogRoll -- Josh Lockhart 13E </center> </font> </body></html>