<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit. FP_CharSet = "windows-1252" FP_CodePage = 1252 %>


Browse Bloggers

A list of all the bloggers in the site is right here:

<% if 0 then %> <% 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=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=True fp_sMenuChoice="owner" fp_sMenuValue="owner" fp_sColTypes="&owner=202&" fp_iDisplayCols=1 fp_fCustomQuery=True BOTID=4 fp_iRegion=BOTID %>


 

<% if 0 then %> <% 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=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=False fp_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=3 fp_fCustomQuery=False BOTID=3 fp_iRegion=BOTID %>

<%=FP_FieldVal(fp_rs,"owner")%>'s Blogs:  &owner=<%=FP_FieldURL(fp_rs,"owner")%>"> <%=FP_FieldVal(fp_rs,"blog_title")%>



Browse Popular

The most viewed blogs are listed here.

Most Popular:


Browse Most Commented

The most commented-on blogs are listed here.

Most Commented:

<% if 0 then %> <% 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=256 fp_iCommandType=1 fp_iPageSize=20 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_sColTypes="&db_submission_key=3&owner=202&blog_title=202&submission_date=202&CountOfcomment=3&" fp_iDisplayCols=5 fp_fCustomQuery=True BOTID=2 fp_iRegion=BOTID %>

<%=FP_FieldVal(fp_rs,"owner")%>: &owner=<%=FP_FieldURL(fp_rs,"owner")%>"> <%=FP_FieldVal(fp_rs,"blog_title")%>  Comments(<%=FP_FieldVal(fp_rs,"CountOfcomment")%>)

 

blogRoll -- Josh Lockhart 13E