<% set rs=server.CreateObject("ADODB.RecordSet") ' The following SQL edited by David Levine to only retrieve for display records which are marked as live ' SQL="select * from tbFREditorial order by " & order Dim TotalRecord, HalfRecord SQL="select * from tbFREditorial where intStatus=2 order by dtTimeStamp" rs.open SQL, "DSN=dotcom", 1,3 TotalRecord=rs.RecordCount HalfRecord=round(TotalRecord/2) 'response.write HalfRecord %> Inkheart: Speak Your Mind | Scholastic.com <% doMenu %>
Inkheart by Cornelia Funke
Explore
Explore
Speak Your Mind
The Italian Coast Gazette
Spotlight Editorials Lead Reporter
Spotlight Editorials Lead Reporter
<% i=1 do until rs.EOF if not rs.EOF and not rs.BOF then %> <% if i = HalfRecord then response.write ("
"><%=rs("YourEditorial")%>  by  <%=rs("FirstName")%> <%=rs("LastInitial")%>
") i=i+1 end if rs.moveNext loop set rs=nothing %>
<% doFooter %>