Resolutions & Amendments 37th International Convention Amendments and Resolutions /members/11276.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 36th International Convention Amendments and Resolutions /members/1086.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 35th International Convention Amendments and Resolutions /members/1038.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 34th International Convention Resolutions /members/955.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 33rd International Convention - Honolulu (1998) /members/1089.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 32nd International Convention - Chicago (1996) /members/957.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 31st International Convention - San Diego (1994) /members/958.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 30th International Convention - Las Vegas (1992) /members/10249.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 29th International Convention - Miami (1990) /members/960.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 28th International Convention - Los Angeles (1988) /members/961.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 27th International Convention - Chicago (1986) /members/962.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); 26th International Convention - San Francisco (1984) /members/963.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"isExternal",isExternal); Other International Executive Board Resolutions /members/999.cfm QuerySetCell(autoQuery,"headline",headline); QuerySetCell(autoQuery,"shortDescription",shortDescription); QuerySetCell(autoQuery,"photo",photo); QuerySetCell(autoQuery,"pubDate",pubDate); QuerySetCell(autoQuery,"pubYear",pubYear); QuerySetCell(autoQuery,"sourceDate",sourceDate); QuerySetCell(autoQuery,"editionDate",editionDate); QuerySetCell(autoQuery,"list","auto"); QuerySetCell(autoQuery,"manualIdx",manualIndex); QuerySetCell(autoQuery,"random",random); QuerySetCell(autoQuery,"pageURL",pageURL); QuerySetCell(autoQuery,"pageGUID",pageGUID); if (externalDoc NEQ "" AND (externalURL EQ "" OR Find(emptyLinkGUID, externalURL) GT 0)) { QuerySetCell(autoQuery,"externalURL",externalDoc); } else { QuerySetCell(autoQuery,"externalURL",externalURL); } QuerySetCell(autoQuery,"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("/publications/904.htm"); showPagination(totalRecords, listOptions.itemsPerPage, URL.page, currentNonPaginatedURL); currentNonPaginatedURL = stripYearFromURL("/publications/904.htm"); showYearlyPagination(yearList, URL.listYear, currentNonPaginatedURL);