Other Heritage Sites | Blog | Bookstore | About Us | Contact Us 

Advanced Search
Heritage home Issues Where We Stand Experts Press and Media Support Heritage




 
 

PUBLICATIONS BY Ambassador Harvey Feldman

Research

Commentary


2008 Research

March 14, 2008
Hong Kong in a Box
By Harvey Feldman
(WebMemo #1854)
To revive the energy and optimism that made Hong Kong unique, China must grant it more political freedoms.

 


2007 Research

December 11, 2007
The Election of Anson Chan: A Step Forward for Democracy in Hong Kong
By Ambassador Harvey Feldman
(WebMemo #1734)
The United States should contine to support the democratic forces within Hong Kong society.

 

October 02, 2007
President Reagan's Six Assurances to Taiwan and Their Meaning Today
By Ambassador Harvey Feldman
(WebMemo #1653)
The past, present, and future of America's diplomatic role in the cross-Strait conflict.

 

May 22, 2007
The Taiwan Status Quo "As We Define It"
By Ambassador Harvey Feldman
(WebMemo #1465)
For most purposes, American law treats Taiwan as a state separate from China. Why do federal officials keep forgetting that?

 


2001 Research

April 12, 2001
A Primer on U.S. Policy Toward the "One-China" Issue
By Ambassador Harvey Feldman
(Backgrounder #1429)
The issue of Taiwan is certain to play a major role in U.S.-China relations for some time to come. If all of those who try to explain American policy on this thorny subject can stick to the basic texts, U.S. policy will appear less confusing and less contradictory.

 


2000 Research

June 22, 2000
The Master Stroke of Taiwan's New President
By Ambassador Harvey Feldman
(Executive Memorandum #685)
Newly inaugurated President Chen Shu-bian has displayed the leadership necessary to control the domestic political forces that threaten Taiwan's nascent democracy as well as the international pressures intrinsic to Taiwan.

 


1999 Research

August 19, 1999
How to Defuse Escalating Tensions in the Taiwan Strait
By Ambassador Harvey Feldman
(Executive Memorandum #620)
Media in Hong Kong report Chinese troops gathering in provinces across the Taiwan Strait and hint at a possible campaign to seize an ROC island.

 


1998 Research

October 28, 1998
America's Response to China-Taiwan
By Ambassador Harvey Feldman
(Backgrounder #1230)
It is critical that the United States urge a peaceful settlement of differences between Taipei and Beijing, but not a solution that endangers Taiwan's political and economic freedoms.

 

October 28, 1998
BG1230es:  America's Reponse to China-Taiwan Talks
By Ambassador Harvey Feldman
(Executive Summary #1230)
BG1230es:  America's Reponse to China-Taiwan Talks:  Encourage But Don't Intefere

 


1995 Research

November 21, 1995
HL551:  The United States and China
By James Przystup, Chas Freeman, Ambassador Harvey Feldman, Harry Harding, and Dick Solomon
(Heritage Lecture #551)
HL551:  The United States and China Into the 21st Century

 


2004 Commentary

December 02, 2004
Stealing Elections in Ukraine
By Harvey Feldman
There are many ways to steal an election. On Nov. 21, the government of Ukraine tried them all.

 

September 09, 2004
Hong Kong Needs U.S. Support
By Harvey Feldman
Will democracy survive in Hong Kong?

 

March 24, 2004
Taiwan Vote Demands a Softer Stance by Beijing
By Harvey Feldman
Four years ago, when Chen Shui-bian was elected Taiwan's president, he promised he would not declare Taiwan independent of China and would not change the country's name (formally, the Republic of China), its flag or its constitution. And he said he would go anywhere, any time, for talks with the Chinese government as long as there were no preconditions.

 

 
 
 
Contact An Expert
MEDIA INFORMATION LINE:
Phone: 202.675.1761
Fax: 202.544.6979
 


Debugging Information
ColdFusion Server Enterprise 7,0,2,142559
Template /about/staff/HarveyFeldmanpapers.cfm
Time Stamp 04-Jul-08 06:25 PM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 10.10.41.254
Host Name 10.10.41.254


Execution Time

Total Time Avg Time Count Template
1188 ms 149 ms 8 D:\websites\commonspot\cache\cached-render.cfm
720 ms 65 ms 11 D:\websites\commonspot\utilities\ct-render-element.cfm
546 ms 546 ms 1 D:\websites\commonspot\master-render.cfm
546 ms 546 ms 1 D:\websites\commonspot\master.cfm
546 ms 546 ms 1 D:\websites\heritage.org\About\Staff\HarveyFeldmanpapers.cfm
500 ms 500 ms 1 D:\websites\commonspot\render-page-meat.cfm
500 ms 500 ms 1 D:\websites\commonspot\render-page.cfm
500 ms 100 ms 5 D:\websites\commonspot\utilities\ct-render-named-element.cfm
454 ms 454 ms 1 D:\websites\heritage.org\templates\template-basepage.cfm
297 ms 74 ms 4 D:\websites\commonspot\controls\layout\cpe-layout.cfm
281 ms 94 ms 3 D:\websites\commonspot\controls\customcf\cpe-customcf.cfm
250 ms 250 ms 1 D:\websites\commonspot\controls\layout\render-cell.cfm
188 ms 188 ms 1 D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm
62 ms 62 ms 1 D:\websites\heritage.org\templates\RHBoxesRD06-new.cfm
47 ms 16 ms 3 D:\websites\commonspot\utilities\cp-cffile-charset.cfm
47 ms 8 ms 6 D:\websites\commonspot\utilities\cp-cffile.cfm
30 ms 15 ms 2 D:\websites\commonspot\controls\upfront-generic.cfm
16 ms 2 ms 7 D:\websites\commonspot\controls\control-setup.cfm
16 ms 16 ms 1 D:\websites\heritage.org\About\Staff\customcf\displayMediaAppearances.cfm
16 ms 16 ms 1 D:\websites\heritage.org\templates\RHBoxesRD06.cfm
15 ms 4 ms 4 D:\websites\commonspot\controls\ct-include-once.cfm
15 ms 15 ms 1 D:\websites\commonspot\controls\dhtmlmenu\cpe-menu.cfm
15 ms 15 ms 1 D:\websites\commonspot\controls\dhtmlmenu\menu-get-data.cfm
15 ms 15 ms 1 D:\websites\commonspot\render-head.cfm
15 ms 15 ms 1 D:\websites\commonspot\utilities\newwindow-js-meat.cfm
15 ms 15 ms 1 D:\websites\heritage.org\cache\s38-n7-p11181-c0-t0-mr-blame.cache
0 ms 0 ms 1 D:\websites\commonspot\approve\ct-render-approval-icon-subitems.cfm
0 ms 0 ms 2 D:\websites\commonspot\controls\default-mode.cfm
0 ms 0 ms 4 D:\websites\commonspot\controls\layout\layout-rowcol-actions.cfm
0 ms 0 ms 1 D:\websites\commonspot\controls\layout\layout-setcellvars.cfm
0 ms 0 ms 1 D:\websites\commonspot\controls\layout\layout-settablevars.cfm
0 ms 0 ms 29 D:\websites\commonspot\controls\set-caller-vars.cfm
0 ms 0 ms 1 D:\websites\commonspot\generate-usage-stats.cfm
0 ms 0 ms 1 D:\websites\commonspot\menu\core-js.cfm
0 ms 0 ms 1 D:\websites\commonspot\menu_ie_style.cfm
0 ms 0 ms 1 D:\websites\commonspot\metadata\build-struct.cfm
0 ms 0 ms 1 D:\websites\commonspot\metadata\init-cache.cfm
0 ms 0 ms 1 D:\websites\commonspot\pagemode\newpagemodeui.cfm
0 ms 0 ms 1 D:\websites\commonspot\pagemode\pagemodeui.cfm
0 ms 0 ms 1 D:\websites\commonspot\render-body-tag.cfm
0 ms 0 ms 1 D:\websites\commonspot\render-metatags.cfm
0 ms 0 ms 7 D:\websites\commonspot\security\security-control.cfm
0 ms 0 ms 1 D:\websites\commonspot\security\security-detail-queries.cfm
0 ms 0 ms 1 D:\websites\commonspot\security\security-page.cfm
0 ms 0 ms 1 D:\websites\commonspot\security\session-user-approvals.cfm
0 ms 0 ms 1 D:\websites\commonspot\set-page-vars.cfm
0 ms 0 ms 1 D:\websites\commonspot\site-application.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\core-application-meat.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\handle-head-request.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\handle-request-timeout.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\session-first-global.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\session-first-site.cfm
0 ms 0 ms 1 D:\websites\commonspot\startup\site-application-meat.cfm
0 ms 0 ms 1 D:\websites\commonspot\static\do-replacements.cfm
0 ms 0 ms 3 D:\websites\commonspot\static\get-feature-enabled.cfm
0 ms 0 ms 1 D:\websites\commonspot\static\replacement-wrapper.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\build-pagedata.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\build-user-struct.cfm
0 ms 0 ms 4 D:\websites\commonspot\utilities\cp-cfwddx.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\cp-setencoding.cfm
0 ms 0 ms 4 D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\ct-limit-inheritance.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\ct-render-edit-icon-subitem.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\define-upfront-vars.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\edit-mode-get-valid.cfm
0 ms 0 ms 8 D:\websites\commonspot\utilities\handle-cache-flags.cfm
0 ms 0 ms 5 D:\websites\commonspot\utilities\handle-in-list.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\load-template-stub.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\newwindow-js.cfm
0 ms 0 ms 8 D:\websites\commonspot\utilities\validate-date-string.cfm
0 ms 0 ms 1 D:\websites\commonspot\utilities\validation\render-info.cfm
0 ms 0 ms 2 D:\websites\commonspot\utilities\verify-stub-data.cfm
0 ms 0 ms 1 D:\websites\heritage.org\About\Staff\Application.cfm
0 ms 0 ms 1 D:\websites\heritage.org\cache\s38-n7-p11181-c131131-t1-mr-blame.cache
0 ms 0 ms 1 D:\websites\heritage.org\cache\temp625192-s38-n7-p11181-c130947-t26-mr-blame.cache
0 ms 0 ms 1 D:\websites\heritage.org\custom-application.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\Header_AutodiscoveryLinks.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-additional-resources.cfm
0 ms 0 ms 2 D:\websites\heritage.org\customcf\RD06\box-standard-media-contacts.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-products-displayad.cfm
0 ms 0 ms 2 D:\websites\heritage.org\customcf\RD06\box-standard-rtcol-videos.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\box-standard-xml.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\RD06\left-nav-display-ads.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\StaffDB\TitleCase.cfm
0 ms 0 ms 1 D:\websites\heritage.org\customcf\searchform-header-greyblue.cfm
0 ms 0 ms 1 D:\websites\heritage.org\template-1x1-Base.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\LHNavRD06.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\basepagefooter980.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\basepageheader980.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\pagetitles-RD06.cfm
0 ms 0 ms 1 D:\websites\heritage.org\templates\template-basepage.head
0 ms 0 ms 1 D:\websites\heritage.org\ui\redesign\nav\AboutNav.cfm
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
562 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

Request.PageData.PageParams (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\render-page-meat.cfm @ 18:25:34.034
				SELECT *
				  FROM Param_Page
				 WHERE (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				   AND VersionState=2
	 		 ORDER BY PageID DESC
			
FormData (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\metadata\build-struct.cfm @ 18:25:34.034
	SELECT Data_FieldValue.FieldValue,FormInputControl.FieldName,FormInputControl.type,FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE Data_FieldValue.PageID = ?
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
		AND (
				((FormControlMap.ClassConstant = 4)
			
				AND (FormControlMap.ClassID IN (1,5,38)) 
			)
	
			OR ((FormControlMap.ClassConstant = 1) AND ( (FormControlMap.ClassID IN (1,2,7)) ))
	
			OR ((FormControlMap.ClassConstant = 2) AND (FormControlMap.ClassID = ?))
	
			 )
 ORDER BY FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11181
Parameter #2(CF_SQL_INTEGER) = 1

rsAuthor (Datasource=Authors, Time=0ms, Records=0) in D:\websites\heritage.org\templates\template-basepage.head @ 18:25:34.034
			select Title, FirstName, MI, LastName, Suffix, BioPageLink from tblStaff INNER JOIN 
			tblPaperAuthors ON tblStaff.StaffID = tblPaperAuthors.StaffID
			WHERE SitePagesID = 11181
			ORDER BY SortOrder
		
CheckInheritance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance.cfm @ 18:25:34.034
   SELECT PageID,VersionState,AuthorID
     FROM Data_Menu_Items
    WHERE ControlID=?
		AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

request.pageDHTMLMenus (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\dhtmlmenu\menu-get-data.cfm @ 18:25:34.034
		SELECT *
		FROM Param_WDDX
		WHERE (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
			AND ElementTypeID = ?
			AND ControlID > 0
		ORDER BY ControlID, PageID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 47

request.pageDHTMLItems (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\upfront-generic.cfm @ 18:25:34.034
	SELECT *
	  FROM Data_Menu_Items
	 WHERE (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, ItemPos,VersionID DESC 
FindMaxVersions (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\upfront-generic.cfm @ 18:25:34.034
		SELECT PageID,ControlID,ItemID,Max(VersionID) AS MaxVersion
		  FROM Data_Menu_Items
		 WHERE (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2) 
	 GROUP BY PageID,ControlID,ItemID
	
Request.CtrlInstUpFront (Datasource=commonspot-heritage.org, Time=16ms, Records=330) in D:\websites\commonspot\controls\control-setup.cfm @ 18:25:34.034
			SELECT ControlID,ControlName
			  FROM ControlInstance
			 WHERE (PageID IN (1,2,7,11181)) 
		 ORDER BY PageID DESC
		
ReadRestrictions (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-render-element.cfm @ 18:25:34.034
			SELECT DISTINCT ControlID
			  FROM ItemSecurity
			 WHERE ((PageID = ? AND ApplyTo=0)
						OR ( (PageID IN (1,2,7,11181)) 
							AND ApplyTo = 1))
			   AND ControlID <> 0
			   AND pRead=0
				AND pAuthor=0
				AND pEdit=0
				AND pDesign=0
				AND pApprove=0
				AND pAdmin=0
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11181

Request.PageData.Restrictions (Datasource=commonspot-heritage.org, Time=0ms, Records=8) in D:\websites\commonspot\security\security-detail-queries.cfm @ 18:25:34.034
			SELECT *
			  FROM RestrictedSecurity
			 WHERE PageID IN (7,2,1) 
SecureElements (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\security\security-detail-queries.cfm @ 18:25:34.034
		SELECT DISTINCT ControlID
		  FROM ItemSecurity
		 WHERE
			(
				((ApplyTo=?)
					AND (PageID=?))
				OR
				((ApplyTo=?)
					AND (PageID IN (7,2,1)))
			)
			AND ControlID<>0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 11181
Parameter #3(CF_SQL_INTEGER) = 1

Request.PageData.ExplicitSecurity (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\security\security-detail-queries.cfm @ 18:25:34.034
			SELECT ControlID,
					 Max(pRead) AS maxRead,
					 Max(pAuthor) AS maxAuthor,
					 Max(pEdit) AS maxEdit,
					 Max(pDesign) AS maxDesign,
					 Max(pStyle) AS maxStyle,
					 Max(pAdmin) AS maxAdmin,
					 Max(pApprove) AS maxApprove
			  FROM ItemSecurity
			 WHERE ( (UserGroupID = ?) )
		      AND
				(
					((ApplyTo=?)
						AND (PageID=?))
					OR
					((ApplyTo=?)
						AND (PageID IN (7,2,1)))
				)
				AND ControlID<>0
		 GROUP BY ControlID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 11181
Parameter #4(CF_SQL_INTEGER) = 1

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 18:25:34.034
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

GetCells (Datasource=commonspot-heritage.org, Time=15ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=11181 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 83726

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:25:34.034
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 11181
Parameter #6(CF_SQL_INTEGER) = 83726
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 18:25:34.034
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetCells (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=7 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

GetCellData (Datasource=commonspot-heritage.org, Time=0ms, Records=2) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
			SELECT *
			  FROM Data_LayoutCell
			 WHERE ControlID = ?
				AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
				AND (VersionState = 2)
		 ORDER BY ItemID, PageID DESC, VersionID DESC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

Request.customCFUpfront (Datasource=commonspot-heritage.org, Time=15ms, Records=4) in D:\websites\commonspot\controls\upfront-generic.cfm @ 18:25:34.034
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 
rsAuthor (Datasource=Authors, Time=16ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
	SELECT *
	FROM tblStaff 
	WHERE BioPageLink = 'HarveyFeldman.cfm' AND Active = 1
rsResearchYears (Datasource=commonspot-heritage.org, Time=15ms, Records=7) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
		select distinct(year(fieldvalue)) As PaperYear from data_fieldvalue where formid = 6855 and fieldid = 6858 
			AND PageID IN 
				(SELECT PageID FROM data_fieldvalue where (formid = 6855 and fieldid = 6857) and 
				(Data_FieldValue.fieldValue like '%Harvey Feldman%' OR Data_FieldValue.fieldValue like '%Ambassador Harvey Feldman%' 
					OR Data_FieldValue.fieldValue like '%Harvey Feldman%' 
					OR Data_FieldValue.fieldValue like '%Harvey . Feldman%'))
			ORDER BY PaperYear DESC
	
rsResearch (Datasource=commonspot-heritage.org, Time=16ms, Records=10) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
		SELECT PageID, FieldValue FROM Data_FieldValue
			WHERE PageID IN
				(
				SELECT pageID FROM Data_FieldValue
				WHERE 
					(
					FormID = 6855 AND
					FieldID = 6857
					AND (Data_FieldValue.fieldValue like '%Harvey Feldman%' OR Data_FieldValue.fieldValue like '%Ambassador Harvey Feldman%' 
					OR Data_FieldValue.fieldValue like '%Harvey Feldman%')
					)
					OR
					(
					FieldID in (101471,101539,101540,101541,101543)
					and FieldValue = 20
					)
				)
					AND PageID NOT IN (SELECT ID FROM SitePages WHERE ExpType = 1)
					AND FieldID = 6858 
					AND FormID = 6855
			ORDER BY FieldValue DESC
	
rsCommentaryYears (Datasource=commonspot-heritage.org, Time=16ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
		select distinct(year(fieldvalue)) As PaperYear from data_fieldvalue where formid = 4500 and fieldid = 4505 
			AND PageID IN 
				(SELECT PageID FROM data_fieldvalue where (formid = 4500 and fieldid = 4503) and 
				(Data_FieldValue.fieldValue like '%Harvey Feldman%' OR Data_FieldValue.fieldValue like '%Ambassador Harvey Feldman%' 
					OR Data_FieldValue.fieldValue like '%Harvey Feldman%'))
			ORDER BY PaperYear DESC
	
rsCommentary (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
		SELECT PageID, FieldValue FROM Data_FieldValue
			WHERE PageID IN
				(
				SELECT pageID FROM Data_FieldValue
				WHERE
					(
					FormID = 4500 AND
					FieldID = 4503
					AND (Data_FieldValue.fieldValue like '%Harvey Feldman%' OR Data_FieldValue.fieldValue like '%Ambassador Harvey Feldman%' 
					OR Data_FieldValue.fieldValue like '%Harvey Feldman%')
					)
					OR
					(
					FieldID IN (101545,101547,101548,101550,101551)
					and FieldValue = 20
					)
				)
                	AND PageID NOT IN (SELECT ID FROM SitePages WHERE ExpType = 1)
					AND FieldID = 4505
					AND FormID = 4500
			ORDER BY FieldValue DESC
	
getAppearances (Datasource=mediaAppearances, Time=15ms, Records=0) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
		SELECT distinct(year(appearancedate)) As MediaYear 
		FROM mediaEvents
		WHERE StaffAuthorID = 20
		order by MediaYear desc
	
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 228618
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 228618 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 214349
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 214349 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 203758
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=16ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 203758 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 163649
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 163649 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 9500
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 9500 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 10826
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 10826 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 18595
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 18595 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 20048
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 20048 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 20059
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 20059 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL, SubSites.DisableSearchIndexing FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 23386
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperType (Datasource=commonspot-heritage.org, Time=0ms, Records=3) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 23386 AND (FieldID = 6864 OR FieldID = 6865 OR FieldID = 6857) ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 72306
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperAuthor (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 72306 AND FieldID = 4503 ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 68556
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperAuthor (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 68556 AND FieldID = 4503 ORDER BY FieldID
				
rsDetails (Datasource=commonspot-heritage.org, Time=16ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FileName, SubsiteID, Title, Description, SubSites.SubSiteURL FROM SitePages
					INNER JOIN SubSites ON SubSites.ID = SitePages.SubSiteID
					WHERE IsPublic > 0 AND SitePages.ID = 59819
						 AND (SitePages.PublicReleaseDate < '2008-07-04 18:07:34') AND (SitePages.ID <> 96544) AND 
						(SitePages.ExpDate >= '2008-07-04 18:07:34' OR SitePages.ExpDate IS NULL) 
				
rsPaperAuthor (Datasource=commonspot-heritage.org, Time=0ms, Records=1) in D:\websites\heritage.org\customcf\StaffDB\MetaData_ProfilePapersOutput.cfm @ 18:25:34.034
					SELECT FieldID, FieldValue FROM Data_FieldValue WHERE PageID = 59819 AND FieldID = 4503 ORDER BY FieldID
				
UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:25:34.034
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 3
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 11181
Parameter #6(CF_SQL_INTEGER) = 132856
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

rsAuthor (Datasource=Authors, Time=0ms, Records=1) in D:\websites\heritage.org\About\Staff\customcf\displayMediaAppearances.cfm @ 18:25:34.034
	SELECT StaffID, BioPageLink, LastName, FirstName
	FROM tblStaff 
	WHERE BioPageLink = 'HarveyFeldman.cfm'
getAppearances (Datasource=mediaAppearances, Time=16ms, Records=0) in D:\websites\heritage.org\About\Staff\customcf\displayMediaAppearances.cfm @ 18:25:34.034
	SELECT * 
	FROM mediaEvents
	WHERE StaffAuthorID = 20
	order by appearancedate desc
	
UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:25:34.034
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 3
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 11181
Parameter #6(CF_SQL_INTEGER) = 132853
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:25:34.034
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 11181
Parameter #6(CF_SQL_INTEGER) = 2
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 18:25:34.034
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

GetCells (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=11181 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88325

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:25:34.034
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 11181
Parameter #6(CF_SQL_INTEGER) = 88325
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

CheckInheritanceForCurrentRecs (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\utilities\ct-limit-inheritance-modebased.cfm @ 18:25:34.034
	   SELECT PageID
	     FROM Data_LayoutRowCol
	    WHERE ControlID=?
			AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
			AND (VersionState = 2)
	 	ORDER BY PageID Desc
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 131131

GetTableValues (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
	SELECT *
	  FROM Param_ControlTable
	 WHERE ControlID=?
	   AND (PageID=11181 OR (PageID IN (7,2,1) AND (VersionState = 2)))
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID Desc 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 131131

GetCells (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\controls\layout\cpe-layout.cfm @ 18:25:34.034
	SELECT *
	  FROM Data_LayoutRowCol
	 WHERE ControlID=?
	   AND
	   (
			(
				PageID=11181 AND (VersionState = 2)
				AND (VersionState = 2)
			)
		)
 ORDER BY VersionState DESC, Action
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 131131

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:25:34.034
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 11181
Parameter #6(CF_SQL_INTEGER) = 131131
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:25:35.035
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 3
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 11181
Parameter #6(CF_SQL_INTEGER) = 130947
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0

UpdateElementInstance (Datasource=commonspot-heritage.org, Time=0ms, Records=0) in D:\websites\commonspot\cache\cached-render.cfm @ 18:25:35.035
				UPDATE ElementInstance
					SET CacheValidUntil = ?,
						 HasDynamicContent = ?,
						 ParentControlID = ?,
						 CachedInParent = ?
				 WHERE PageID=?
					AND ControlID=?
					AND UserMode = ?
					AND UserID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2276-07-04 21:00:00
Parameter #2(CF_SQL_INTEGER) = 4
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 11181
Parameter #6(CF_SQL_INTEGER) = 0
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 0


Scope Variables

Application Variables:
activesubsites=1,3,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,61,62,63,64,66,68,69,70,72,73,74,75,76,77,78,79,80,81,82,83,84,85,87,88,89,90,91,92,93,94,95,96,97,98,99,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145
anonitemsecurity=Struct (8)
anonrights=Struct (7)
anonsubsiteperms=Struct (136)
anonsubsitesecurity=Struct (136)
applicationname=site2
cachedimages=Struct (327)
cacheinfo=Struct (15089)
cachevalid=1
confidentiality=Array (5)
controlinstance_toplevel=Struct (2)
cs=Struct (11)
cs_element_cache=Struct (0)
defaultconfidentiality=5
defaultstructs=Struct (6)
docsdump=Complex type
dodump=Complex type
dolog=Complex type
getid=Struct (4)
getidparams=Struct (2)
gettaxonomyannotlookup=Complex type
imagegallerylists=Struct (0)
languages=Struct (11)
lastknownchange=Struct (19)
lastupdate=Struct (15)
lookuptaxonomyannot=Complex type
masterrendersequence=78759
metadatacache=Struct (0)
nextcheck=Struct (1)
serverclockcheck=2008-07-04 11:38:52
servervalidationcode=1029RTN7H3C5C265DONPR3CT2
site=Struct (47)
styleids=Struct (206)
stylenames=Struct (206)
subsitecache=Struct (136)
templaterenderoptions=Struct (66)
transactionlog=Struct (112)
translations=Struct (4)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\websites\heritage.org\About\Staff\HarveyFeldmanpapers.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=author.heritage.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/about/staff/HarveyFeldmanpapers.cfm
PATH_TRANSLATED=D:\websites\heritage.org\About\Staff\HarveyFeldmanpapers.cfm
QUERY_STRING=
REMOTE_ADDR=10.10.41.254
REMOTE_HOST=10.10.41.254
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/about/staff/HarveyFeldmanpapers.cfm
SERVER_NAME=author.heritage.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Cookie Variables:
CFID=9989391
CFTOKEN=39999127
Request Parameters:
applockname=CS_App_Site2_1
approvalneededlist=
approvedlist=
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
basehref=/
blupfront=
browser=Struct (9)
buildingcache=0
cacheinfo=Struct (12)
constants=Struct (185)
controlswhereuserisowner=
cp=Struct (110)
ctrl_data=Struct (330)
ctrlinstupfront=Query (330)
customcf_data=Struct (1)
customcfupfront=Query (4)
customerinfo=Struct (25)
customhead=1
debugmode=0
dhtmlmenuitemsprefetch=
dhtmlmenus_current=Struct (0)
dhtmlmenus_wip=Struct (0)
disablehideformenus=0
editiconcontrols=
editiconitems=
editiconnames=action-big-change,action-big-del,action-big-move,action-big-move-add,action-big-move-change,action-both,action-del