Memphis: We remember Video: AFSCME and Dr. Martin Luther King Jr. /about/17418.cfm QuerySetCell(manualQuery,"headline",headline); QuerySetCell(manualQuery,"shortDescription",shortDescription); QuerySetCell(manualQuery,"photo",photo); QuerySetCell(manualQuery,"pubDate",pubDate); QuerySetCell(manualQuery,"pubYear",pubYear); QuerySetCell(manualQuery,"sourceDate",sourceDate); QuerySetCell(manualQuery,"editionDate",editionDate); QuerySetCell(manualQuery,"list","manual"); QuerySetCell(manualQuery,"manualIdx",manualIndex); QuerySetCell(manualQuery,"random",random); QuerySetCell(manualQuery,"pageURL",pageURL); QuerySetCell(manualQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(manualQuery,"externalURL",externalDoc); } else { QuerySetCell(manualQuery,"externalURL",externalURL); } QuerySetCell(manualQuery,"isExternal",isExternal); 1968 AFSCME Memphis Sanitation Workers' Strike Chronology /about/1548.cfm QuerySetCell(manualQuery,"headline",headline); QuerySetCell(manualQuery,"shortDescription",shortDescription); QuerySetCell(manualQuery,"photo",photo); QuerySetCell(manualQuery,"pubDate",pubDate); QuerySetCell(manualQuery,"pubYear",pubYear); QuerySetCell(manualQuery,"sourceDate",sourceDate); QuerySetCell(manualQuery,"editionDate",editionDate); QuerySetCell(manualQuery,"list","manual"); QuerySetCell(manualQuery,"manualIdx",manualIndex); QuerySetCell(manualQuery,"random",random); QuerySetCell(manualQuery,"pageURL",pageURL); QuerySetCell(manualQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(manualQuery,"externalURL",externalDoc); } else { QuerySetCell(manualQuery,"externalURL",externalURL); } QuerySetCell(manualQuery,"isExternal",isExternal); "I've Been to the Mountaintop" by Dr. Martin Luther King, Jr. /about/1549.cfm QuerySetCell(manualQuery,"headline",headline); QuerySetCell(manualQuery,"shortDescription",shortDescription); QuerySetCell(manualQuery,"photo",photo); QuerySetCell(manualQuery,"pubDate",pubDate); QuerySetCell(manualQuery,"pubYear",pubYear); QuerySetCell(manualQuery,"sourceDate",sourceDate); QuerySetCell(manualQuery,"editionDate",editionDate); QuerySetCell(manualQuery,"list","manual"); QuerySetCell(manualQuery,"manualIdx",manualIndex); QuerySetCell(manualQuery,"random",random); QuerySetCell(manualQuery,"pageURL",pageURL); QuerySetCell(manualQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(manualQuery,"externalURL",externalDoc); } else { QuerySetCell(manualQuery,"externalURL",externalURL); } QuerySetCell(manualQuery,"isExternal",isExternal); Dr. Martin Luther King, Jr. on Labor /about/1550.cfm QuerySetCell(manualQuery,"headline",headline); QuerySetCell(manualQuery,"shortDescription",shortDescription); QuerySetCell(manualQuery,"photo",photo); QuerySetCell(manualQuery,"pubDate",pubDate); QuerySetCell(manualQuery,"pubYear",pubYear); QuerySetCell(manualQuery,"sourceDate",sourceDate); QuerySetCell(manualQuery,"editionDate",editionDate); QuerySetCell(manualQuery,"list","manual"); QuerySetCell(manualQuery,"manualIdx",manualIndex); QuerySetCell(manualQuery,"random",random); QuerySetCell(manualQuery,"pageURL",pageURL); QuerySetCell(manualQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(manualQuery,"externalURL",externalDoc); } else { QuerySetCell(manualQuery,"externalURL",externalURL); } QuerySetCell(manualQuery,"isExternal",isExternal); SELECT * from autoQuery #PreserveSingleQuotes(whereClause)# #orderByClause# SELECT #querycols# FROM manualQuery UNION SELECT #querycols# FROM autoQuery #orderByClause# SELECT distinct(pubYear) as dPubYear FROM unitedQuery SELECT * FROM unitedQuery WHERE pubYear = #URL.listYear#

#listOptions.listHeadline#

#listOptions.listSubhead#

#dispOneItem(i, unitedQuery, listOptions)#

currentNonPaginatedURL = stripPageFromURL("/press/1547.htm"); showPagination(totalRecords, listOptions.itemsPerPage, URL.page, currentNonPaginatedURL); currentNonPaginatedURL = stripYearFromURL("/press/1547.htm"); showYearlyPagination(yearList, URL.listYear, currentNonPaginatedURL);