%@LANGUAGE="VBSCRIPT"%> <% Set objConnC = Server.CreateObject("ADODB.Connection") objConnC.Open(cConnection) Set rsEditorial = objConnC.Execute("SELECT * FROM submissions WHERE Status <> 'hold' AND PigeonHole = 'editorial' AND LastName = 'Lloyd' ORDER BY submissionID DESC") %> <% Dim rsViewBlue Dim rsViewBlue_numRows Set rsViewBlue = Server.CreateObject("ADODB.Recordset") rsViewBlue.ActiveConnection = MM_ConnToffeeWeb_STRING rsViewBlue.Source = "SELECT * FROM efcnews WHERE articletype = 'lloyd' ORDER BY datestamp DESC" rsViewBlue.CursorType = 0 rsViewBlue.CursorLocation = 2 rsViewBlue.LockType = 1 rsViewBlue.Open() rsViewBlue_numRows = 0 %>
By Lyndon Lloyd
<%=rsEditorial("deck")%>
<%=rsEditorial("DayDate")%>