John Derrig Website


Skip Navigation Links.

St. Gall Online Directory

Testing online directory using MS Access database.

begin loop
SQL Query String = SELECT DISTINCT tblEntry.AlphaLetter FROM tblEntry ORDER BY tblEntry.AlphaLetter

A
B
D
H
M

end loop
 

Request Details
Session Id:eqskrg5v2rc3dmp5qbswqppiRequest Type:GET
Time of Request:5/20/2012 7:44:39 AMStatus Code:200
Request Encoding:Unicode (UTF-8)Response Encoding:Unicode (UTF-8)

Trace Information
CategoryMessageFrom First(s)From Last(s)
aspx.pageBegin PreInit
aspx.pageEnd PreInit9.03047733720347E-050.000090
aspx.pageBegin Init0.0001100698552469660.000020
aspx.pageEnd Init0.0001315809690896470.000022
aspx.pageBegin InitComplete0.0001437333515851880.000012
aspx.pageEnd InitComplete0.0001556063689658880.000012
aspx.pageBegin PreLoad0.0001669206561169090.000011
aspx.pageEnd PreLoad0.0001806793880227790.000014
aspx.pageBegin Load0.000192273040288640.000012
AccessFielname =E:\web\saintgallch\htdocs\App_Data\OnlineDirectory_test2.mdb0.0003046476577330360.000112
SQL Query String =SELECT DISTINCT tblEntry.AlphaLetter FROM tblEntry ORDER BY tblEntry.AlphaLetter0.0003192444849834270.000015
aspx.pageEnd Load0.09222058948832880.091901
aspx.pageBegin LoadComplete0.09228924346530080.000069
aspx.pageEnd LoadComplete0.09230384029255110.000015
aspx.pageBegin PreRender0.0923159228337680.000012
aspx.pageEnd PreRender0.09259347207536150.000278
aspx.pageBegin PreRenderComplete0.09261477366536810.000021
aspx.pageEnd PreRenderComplete0.09262713557169980.000012
aspx.pageBegin SaveState0.09327603089219440.000649
aspx.pageEnd SaveState0.0935928309324230.000317
aspx.pageBegin SaveStateComplete0.09360791664862430.000015
aspx.pageEnd SaveStateComplete0.09361985950728370.000012
aspx.pageBegin Render0.09363117379443480.000011
aspx.pageEnd Render0.09530317400675230.001672

Control Tree
Control UniqueIDTypeRender Size Bytes (including children)ViewState Size Bytes (excluding children)ControlState Size Bytes (excluding children)
__PageASP.onlinedirectory_test3_aspx2945000
    ctl00ASP.navigation_master2945000
        ctl00$ctl03System.Web.UI.LiteralControl12900
        ctl00$ctl04System.Web.UI.LiteralControl5000
        ctl00$ctl00System.Web.UI.HtmlControls.HtmlHead11600
            ctl00$ctl01System.Web.UI.HtmlControls.HtmlTitle3300
            ctl00$ctl02System.Web.UI.HtmlControls.HtmlLink7000
        ctl00$ctl05System.Web.UI.LiteralControl1400
        aspnetFormSystem.Web.UI.HtmlControls.HtmlForm2912100
            ctl00$ctl06System.Web.UI.LiteralControl2100
            ctl00$SiteMapDataSource1System.Web.UI.WebControls.SiteMapDataSource000
            ctl00$ctl07System.Web.UI.ResourceBasedLiteralControl63100
            ctl00$SiteMapDataSource2System.Web.UI.WebControls.SiteMapDataSource000
            ctl00$ctl08System.Web.UI.LiteralControl2200
            ctl00$TreeView1System.Web.UI.WebControls.TreeView2092661640
            ctl00$ctl09System.Web.UI.LiteralControl10800
            ctl00$ContentPlaceHolder1System.Web.UI.WebControls.ContentPlaceHolder40400
                ctl00$ContentPlaceHolder1$ctl00System.Web.UI.LiteralControl14100
                ctl00$ContentPlaceHolder1$lblMSAccessDatatestSystem.Web.UI.WebControls.Label2592440
                ctl00$ContentPlaceHolder1$ctl01System.Web.UI.LiteralControl400
            ctl00$ctl10System.Web.UI.LiteralControl9400
        ctl00$ctl11System.Web.UI.LiteralControl2000

Session State
Session KeyTypeValue

Application State
Application KeyTypeValue

Request Cookies Collection
NameValueSize

Response Cookies Collection
NameValueSize
ASP.NET_SessionIdeqskrg5v2rc3dmp5qbswqppi42

Headers Collection
NameValue
Cache-Controlno-cache
Connectionclose
Pragmano-cache
Accepttext/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-CharsetISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Encodinggzip
Accept-Languageen-us,en;q=0.5
Hostwww.saintgallchat.org
User-AgentCCBot/1.0 (+http://www.commoncrawl.org/bot.html)
x-cc-idccc02-02

Response Headers Collection
NameValue
X-AspNet-Version4.0.30319
Set-CookieASP.NET_SessionId=eqskrg5v2rc3dmp5qbswqppi; path=/; HttpOnly
Cache-Controlprivate
Content-Typetext/html

Form Collection
NameValue

Querystring Collection
NameValue

Server Variables
NameValue
ALL_HTTPHTTP_CACHE_CONTROL:no-cache HTTP_CONNECTION:close HTTP_PRAGMA:no-cache HTTP_ACCEPT:text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_ACCEPT_ENCODING:gzip HTTP_ACCEPT_LANGUAGE:en-us,en;q=0.5 HTTP_HOST:www.saintgallchat.org HTTP_USER_AGENT:CCBot/1.0 (+http://www.commoncrawl.org/bot.html) HTTP_X_CC_ID:ccc02-02
ALL_RAWCache-Control: no-cache Connection: close Pragma: no-cache Accept: text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Accept-Encoding: gzip Accept-Language: en-us,en;q=0.5 Host: www.saintgallchat.org User-Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html) x-cc-id: ccc02-02
APPL_MD_PATH/LM/W3SVC/131649/ROOT
APPL_PHYSICAL_PATHE:\web\saintgallch\htdocs\
AUTH_TYPE 
AUTH_USER 
AUTH_PASSWORD 
LOGON_USER 
REMOTE_USER 
CERT_COOKIE 
CERT_FLAGS 
CERT_ISSUER 
CERT_KEYSIZE 
CERT_SECRETKEYSIZE 
CERT_SERIALNUMBER 
CERT_SERVER_ISSUER 
CERT_SERVER_SUBJECT 
CERT_SUBJECT 
CONTENT_LENGTH0
CONTENT_TYPE 
GATEWAY_INTERFACECGI/1.1
HTTPSoff
HTTPS_KEYSIZE 
HTTPS_SECRETKEYSIZE 
HTTPS_SERVER_ISSUER 
HTTPS_SERVER_SUBJECT 
INSTANCE_ID131649
INSTANCE_META_PATH/LM/W3SVC/131649
LOCAL_ADDR64.22.138.6
PATH_INFO/OnlineDirectory_Test3.aspx
PATH_TRANSLATEDE:\web\saintgallch\htdocs\OnlineDirectory_Test3.aspx
QUERY_STRING 
REMOTE_ADDR38.107.179.220
REMOTE_HOST38.107.179.220
REMOTE_PORT39658
REQUEST_METHODGET
SCRIPT_NAME/OnlineDirectory_Test3.aspx
SERVER_NAMEwww.saintgallchat.org
SERVER_PORT80
SERVER_PORT_SECURE0
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/7.0
URL/OnlineDirectory_Test3.aspx
HTTP_CACHE_CONTROLno-cache
HTTP_CONNECTIONclose
HTTP_PRAGMAno-cache
HTTP_ACCEPTtext/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSETISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODINGgzip
HTTP_ACCEPT_LANGUAGEen-us,en;q=0.5
HTTP_HOSTwww.saintgallchat.org
HTTP_USER_AGENTCCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_IDccc02-02
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272