Computer-Assisted Research and Reporting

Press Room: CARR

"The liberties of a people never were, nor ever will be, secure when the transactions of their rulers may be concealed from them."
--Patrick Henry, 1787

The Heritage Foundation has teamed with the Sunlight Foundation and Center for Responsive Politics to present its Computer-Assisted Research and Reporting boot camps for journalists and bloggers seeking to enhance their reporting and research skills.

The 2008 CARR boot camps mark the ninth year for the events that have graduated more than 300 editors, reporters, producers, researchers and graphics artists. The boot camps are held throughout the year at the National Press Club's Eric Friedheim Library in Washington, D.C. Special workshops can also be arranged.

Those interested in attending a CARR boot camp are encouraged to enroll ASAP as the events tend to fill up rather quickly. For more information, contact Maggie Pitts at The Heritage Foundation at (202) 546-4400 or course instructor Mark Tapscott at (202) 459-4968 or mark.tapscott@gmail.com.

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

SELECT DISTINCT ControlID FROM ItemSecurity WHERE ((PageID = ? AND ApplyTo=0) OR ( (PageID IN (1,2,7,218549)) AND ApplyTo = 1)) AND ControlID <> 0 AND pRead=0 AND pAuthor=0 AND pEdit=0 AND pDesign=0 AND pApprove=0 AND pAdmin=0

UPDATE ElementInstance SET CacheValidUntil = ?, HasDynamicContent = ?, ParentControlID = ?, CachedInParent = ? WHERE PageID=? AND ControlID=? AND UserMode = ? AND UserID = ?

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 anonitemsecurity=Struct (8) anonrights=Struct (7) anonsubsiteperms=Struct (135) anonsubsitesecurity=Struct (135) applicationname=site2 cachedimages=Struct (94) cacheinfo=Struct (14783) 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) gettaxonomyannotlookup=Complex type imagegallerylists=Struct (0) languages=Struct (11) lastknownchange=Struct (19) lastupdate=Struct (15) lookuptaxonomyannot=Complex type masterrendersequence=73251 metadatacache=Struct (0) nextcheck=Struct (1) serverclockcheck=2008-05-16 17:27:22 servervalidationcode=1029RTN7H3C5C265DONPR3CT2 site=Struct (47) styleids=Struct (206) stylenames=Struct (206) subsitecache=Struct (135) templaterenderoptions=Struct (70) 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\Press\carr\index.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=/press/carr/index.cfm PATH_TRANSLATED=D:\websites\heritage.org\Press\carr\index.cfm QUERY_STRING= REMOTE_ADDR=10.10.41.254 REMOTE_HOST=10.10.41.254 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/press/carr/index.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=

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 (7) constants=Struct (185) controlswhereuserisowner= cp=Struct (110) ctrl_data=Struct (323) ctrlinstupfront=Query (323) customcf_data=Struct (1) customcfupfront=Query (2) customerinfo=Struct (25) debugmode=0 dhtmlmenuitemsprefetch= disablehideformenus=0 editmode=0 element=Struct (10) elementadminlist= elementapprovelist= elementauthorlist= elementcommentlist= elementdesignlist= elementeditlist= elementreadlist= elementrestrictedadminlist=0,791,793,803,827,832,834,846,936 elementrestrictedauthorlist=0,791,793,803,827,832,834,846,936 elementrestricteddesignlist=0,791,793,803,827,832,834,846,936 elementrestrictedstylelist=0,791,793,803,827,832,834,846,936 elementstylelist= fnsequence=2 formattedtimestamp=2008-05-17 02:44:11 getghost= ignoreauthuser=0 imageupfront= includedmodules= includedobjects=nwjs initialsiteid=2 initialsubsiteid=82 itemsecurity=Struct (8) jswarnmessage= knownsecurecontrols= linkdataupfront_itempos= linkdataupfront_itemtitle= lockid=0 master_cfm_used=1 masterrendersequence=73251 maxadmin=0 maxapprove=0 maxauthor=0 maxcomment=0 maxdesign=0 maxedit=0 maxhistory=0 maxperms=Struct (9) maxstyle=0 minperms=Struct (9) modeorderbyclause=VersionID Desc modewhereclause=(VersionState = 2) modewhereclause_page=(VersionState = 2) multisectionupfront= nocacheelementtypes= openelements= page=Struct (93) pagedata=Struct (8) pagedhtmlitems= pagedhtmlmenus= pageperms=Struct (9) pagerestrictedadmin=0 pagerestrictedauthor=0 pagerestricteddesign=0 pagerestrictedstyle=0 previewon=1 readmodewhereclause=(VersionState = 2) renderedelements=Struct (0) renderelementdata=Struct (0) renderfordiff=0 renderforprint=0 renderstate=Struct (2) requestedversiontimestamp= scheduleupfront= securitydetailrun=1 sequenceid=367800 sessionlockname=Session_1_7932404_20338313 sessionstring=1_7932404_20338313 sicupfront= sicupfrontparam= site=Struct (47) siteid=2 styleids=Struct (206) stylenames=Struct (206) subsite=Struct (56) subsitecache=Struct (135) subsiteid=82 subsiteperms=Struct (135) subsiterights=Struct (14) subsitesecurity=Struct (2) subsitesecuritycache=Struct (135) taiupfrontparam= tbupfront= tbupfrontparam= timestamp={ts '2008-05-17 02:44:11'} udslockname=CS_Customer_commonspot-users uipath=/ui/ updatingschemas=0 usedelementnames=sideNavElement_common user=Struct (18) usersdatasource=commonspot-users vinheritancelist=218549,7,2,1 wanterrorsrethrown=0 warnmessage=

Session Variables: authormode=0 browser=Struct (9) cfid=7932404 cftoken=20338313 currentpageid=218549 debugmode=0 debugmode_control=0 editmode=0 hasusertempfiles=0 lastupdate=Struct (6) lastuserupdate=1211006651828 lockid=0 lockobjectid=0 lockobjecttype=page locktype=temp logintime= pagedata= pendingapprovalpages= pendingapprovals= previewon=1 requestedversioncounter= requestedversiontimestamp= sessionid=SITE2_7932404_20338313 urltoken=CFID=7932404&CFTOKEN=20338313 usagelist= user=Struct (18)