http://www.starrymag.com Online magazine featuring Celebrity Interviews, Music reviews, CD reviews, Movie and DVD reviews, television reviews, TV episode guides, and much more. en-us <% Dim strSQL strSQL = "SELECT PK_CONTENT, TYPE, SUBJECT, HEADER2, DATE_WRITTEN, RSSD FROM CONTENT ORDER BY DATE_WRITTEN DESC;" Dim artRec Set artRec = Server.CreateObject("ADODB.Recordset") artRec.Open strSQL, Conn, 1, 1 x=0 while not artRec.eof if x<8 then response.write "" response.write "" response.write "http://starrymag.com/content.asp?ID="& artRec("PK_CONTENT") &"&CATEGORY="& artRec("TYPE") &"" response.write ""& artRec("RSSD") &"" ' response.write ""& (formatDateTime(artRec("DATE_WRITTEN"),1)) &"" response.write "http://starrymag.com/content.asp?ID="& artRec("PK_CONTENT") &"&CATEGORY="& artRec("TYPE") &"" response.write "" end if x=x+1 artRec.movenext wend set artRec = nothing set objConn = nothing Conn.Close %>