MASSMED | Top Stories

	Name:
	Password:

Massachusetts Medical Society
860 Winter Street
Waltham MA 02451
(800) 322-2303 or (781) 893-4610
© Copyright 2004

Debugging Information

ColdFusion Server Standard	6,1,0,83762
Template	/AM/Template.cfm
Time Stamp	25-Feb-05 02:37 PM
Locale	English (US)
User Agent
Remote IP	10.1.1.35
Host Name	10.1.1.35

Execution Time

Total Time	Avg Time	Count	Template
31 ms	31 ms	1	D:\webfiles\MASSMED\WWW\AM\Template.cfm
16 ms	16 ms	1	D:\webfiles\MASSMED\WWW\AM\Application.cfm
16 ms	16 ms	1	D:\webfiles\MASSMED\WWW\AM\CM\HTMLDisplay.cfm
16 ms	16 ms	1	D:\webfiles\MASSMED\WWW\AM\Ecommerce\BasketSetupTag.cfm
16 ms	16 ms	1	D:\webfiles\MASSMED\WWW\AM\TemplateBody.cfm
15 ms	15 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateHeader\TemplateHeader.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\ApplicationCustom.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\ApplicationUDFs.cfm
0 ms	0 ms	2	D:\webfiles\MASSMED\WWW\AM\Common\CachedStoredProcTag.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\DetermineHeader.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\HierMenu\HierMenuTag.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\LoadSessionVariables.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\TemplateSection.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\FooterInclude.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\HeaderInclude.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateFooter\TemplateFooter.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateSideNav.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateSideNavWithImages.cfm
0 ms	0 ms	1	D:\webfiles\MASSMED\WWW\AM\Templates\TemplateTopNav.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
47 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

14:37:05.005 - Expression Exception - in D:\webfiles\MassMed\WWW\AM\TemplateSection.cfm : line 34

	    Cannot find key March in struct.

SQL Queries

GetSystemVariables (Datasource=CFWeb, Time=0ms, Records=90) in D:\webfiles\MassMed\WWW\AM\LoadSessionVariables.cfm @ 14:37:05.005

  SELECT a.*
    FROM System_Variable a
   WHERE VariableTypeCode = 'E'

qSavedBasket (Datasource=CFWeb, Time=16ms, Records=0) in D:\webfiles\MassMed\WWW\AM\Ecommerce\BasketSetupTag.cfm @ 14:37:05.005

    SELECT a.*, 
           b.EtailerID,
           b.SKU,
           b.TaxableFlag,
           b.UnitPrice AS NewPrice,
           b.MemberPrice AS NewMemberPrice,
           b.QuantityEditableFlag,
           c.StockStatusDesc AS StockStatus
      FROM Basket_Save a WITH (NOLOCK),
           Product b WITH (NOLOCK),
           Stock_Status_Ref c WITH (NOLOCK)
     WHERE a.ProductID = b.ProductID
       AND b.StockStatusCode = c.StockStatusCode
       AND 1=0

GetHTML (Datasource=CFWeb, Time=16ms, Records=1) in D:\webfiles\MASSMED\WWW\AM\CM\HTMLDisplay.cfm @ 14:37:05.005

    SELECT a.*, b.Keywords, b.Description, b.MembersOnlyFlag
      FROM Content_HTML a, Content b
     WHERE a.ContentID = b.ContentID
       AND a.ContentID = 6243

Stored Procedures

amsp_CMGetPublishedContentID (Datasource=CFWeb, Time=0ms) in D:\webfiles\MASSMED\WWW\AM\CM\HTMLDisplay.cfm @ 14:37:05.005

parameters

type CFSQLType value variable dbVarName

IN CF_SQL_NUMERIC 6243

OUT CF_SQL_NUMERIC l_PublishedContentID = l_PublishedContentID

IN CF_SQL_NUMERIC 1

resultsets

name resultset

Scope Variables

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:\webfiles\MASSMED\WWW\AM\Template.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=
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=staging1.massmed.org
HTTP_REFERER=
HTTP_USER_AGENT=
PATH_INFO=/AM/Template.cfm
PATH_TRANSLATED=D:\webfiles\MassMed\WWW\AM\Template.cfm
QUERY_STRING=Section=March&TEMPLATE=/CM/HTMLDisplay.cfm&CONTENTID=6243&FUSEFLAG=1
REMOTE_ADDR=10.1.1.35
REMOTE_HOST=10.1.1.35
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/AM/Template.cfm
SERVER_NAME=staging1.massmed.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=16380
cftoken=32379969
hitcount=1
lastvisit={ts '2005-02-25 14:37:05'}
timecreated={ts '2005-02-25 14:37:05'}
urltoken=CFID=16380&CFTOKEN=32379969

Request Parameters:
defaultsectionurl=http://staging1.massmed.org/
graphicsdirectory=/AM/graphics/home_template/
l_htmlheadcontentinformation=
  
  
  
    
  
    
  
  
  
  

MASSMED | Top Stories - Vital Signs
securewebsiterooturl=http://staging1.massmed.org/
websiteindex=5
websitekey=31cadfd9-b130-44b4-af2e-6603cbcc422b
websitekeyvar=31cadfd9_b130_44b4_af2e_6603cbcc422b
websitename=MASSMED
websiterooturl=http://staging1.massmed.org/

Session Variables:
admin=False
administrator=False
adminmicrositeid=0
adminsectionlist=
alldynamic=N
ba=Struct (1)
bannercompanyid=0
bebroadcastemail=Array (0)
bebulkemailauditid=0
bememberid=
bg=Struct (3)
bgcompanyid=0
bgselectionid=0
bgtransactionmode=
browser=Unknown
browserversion=0
candidateid=0
cc=Struct (4)
cdadministratorid=0
cfid=16380
cftoken=32379969
chapter=
cm=Struct (13)
cmbordercolor=#D1CDBB
cmcurrentfolderid=
cmeditorredirecturl=
cmfolderdisplay=
cmfoldersectiondisplay=
cmnavcontentgroupind=
cmsavetemplatepath=
cmsectiondisplay=
cmsuperadminflag=False
cmsurftoeditcontentid=0
cmsurftoeditreturnurl=
cmtextonlytemplate=False
cmwebsitekey=
committee=
companyid=0
companymaster=false
companymembershipnum=
companyname=
contactid=0
coregistrant=Array (0)
cp=Struct (4)
cpemailattachmentlist=
cpinvitationkey=
cpinvitegroupmembers=Array (0)
cpinvitegroupname=
cpinvitegroupsearchcriteria=
ctchapterid=0
customerid=0
cwadministrator=False
debug=False
ec=Struct (6)
eccheckoutprocessstart=false
eccouponnum=
ecshippingmethod=
ecstoreafcheckoutlink=
ecstoreafcheckoutlinkdesc=
eg=Struct (1)
egsubscribedgrouplist=
emailaddress=
faqflag=
firstname=
fontface=verdana
fontsize=2
geformsubmitted=false
headersize=3
imismemberid=
initialized=True
interestcategorylist=
jb=Struct (8)
jbcompany=Struct (0)
jbcompanyname=
jbcoverlettertext=
jbjobid=0
jbpreview=Struct (0)
jbresumesearchflag=false
jbsearch=Struct (0)
lastname=
location=Struct (8)
loggedin=0
mc=Struct (6)
mccurrentmessage=FALSE
mcfirsttime=True
mcmessagetext=
mcprimaryrecipients=
mcsecondaryrecipients=
mcsubject=
md=Struct (1)
mdsearchcriteria=
member=Struct (18)
memberid=0
membershipflag=false
membertype=
message=
ms=Struct (2)
msinitializeprocess=false
msmicrositeadminlist=
mycommittees=
myinterests=
ol=Struct (5)
pe=Struct (2)
platform=Windows
publicresultsflag=
questiondisplaylimit=
recruiterflag=false
recruiterid=0
redirect=
redirectfrom=
registrationpage=
rowcolor1=FFFFFF
rowcolor2=D1DDEA
savedbasket=Query (0)
sb=Struct (1)
sbpresenterid=0
sc=Struct (4)
scadmincomponentcodelist=
screturnmessage=Click here to continue.
scsecuritygroup=
securitygrouplist=
sessionid=CFUSER_16380_32379969
shoppingcart=Array (0)
staff=Struct (13)
su=Struct (8)
supreviewingsurvey=False
surespondingsurveyid=
sureviewingprocess=false
surveydate=
surveyid=0
surveyreporttemplate=
surveyresponse=0
surveyresponseid=0
surveyreviewquestionlist=
surveytakenlist=
surveytype=
susurveyid=0
susurveyresponseid=0
susurveyreviewquestionlist=
susurveytakenlist=
susurveytype=
sy=Struct (21)
templatepath=/AM/Template.cfm?Section=Home
title=
urltoken=CFID=16380&CFTOKEN=32379969
username=
voucheramount=
voucheramountremain=
voucheramountused=
vouchernumber=

URL Parameters:
CONTENTID=6243
FUSEFLAG=1
SECTION=March
TEMPLATE=/CM/HTMLDisplay.cfm

Debug Rendering Time: 47 ms