|
Debugging Information
Execution Time
SQL Queries qGetLangsDef (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm @ 07:25:56.056SELECT language_key, language_default, language_abbr FROM language WHERE language_default = ? Query Parameter Value(s) -qGetLangs (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm @ 07:25:56.056SELECT language_key, language_abbr FROM language WHERE language_key = ?; Query Parameter Value(s) -qGetLangs (Datasource=WaterWays, Time=0ms, Records=8) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 07:25:56.056SELECT DISTINCT L.language_key, L.language_name, L.language_abbr FROM language L qGetcontacts (Datasource=WaterWays, Time=16ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 07:25:56.056SELECT DISTINCT C.contact_key, C.contact_name, C.contact_business_name, C.contact_address_1, C.contact_address_2, C.contact_address_3, C.contact_telephone, C.contact_email_address, C.contact_additional_details, C.contact_image, C.contact_alt, C.contact_descriptimg, P.place_name, P.place_key, C.contact_postcode, C.contact_mobile, C.contact_fax FROM CONTACT C INNER JOIN CONTACTVSDEPLOYMENT CD ON C.contact_key = CD.contact_key LEFT OUTER JOIN PLACE P ON C.place_key = P.place_key LEFT OUTER JOIN CONTACTVSCONTACTTYPE CCT ON C.contact_key = CCT.contact_key WHERE CD.deployment_key = ? AND left(contact_business_name, 1) = ? AND P.place_key = ? Query Parameter Value(s) -qGetbanners (Datasource=WaterWays, Time=0ms, Records=9) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm @ 07:25:56.056SELECT banner_image FROM banner WHERE banner_show = ? Query Parameter Value(s) -Scope Variables Application Variables: applicationname=WaterWays_FrontEnd_LIVE lang=Struct (8) language_list=EN,IR,FR,ES,NO,SC,IT,DE 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:\waterwaysireland\1.waterways.biznetservers.com\www_root\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= HTTP_ACCEPT_ENCODING=deflate, gzip, x-gzip, compress, x-compress HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION=close, TE HTTP_COOKIE= HTTP_HOST=www.waterwaysireland.org HTTP_REFERER= HTTP_USER_AGENT=ColdFusion PATH_INFO=/section/contacts/letter/Z/type/0/place/39/page/none/printfriendly/true/lang/1/content/none PATH_TRANSLATED=D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm QUERY_STRING= REMOTE_ADDR=84.23.9.163 REMOTE_HOST=84.23.9.163 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/index.cfm SERVER_NAME=www.waterwaysireland.org SERVER_PORT=80 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/5.0 WEB_SERVER_API= Cookie Variables: CFID=14280659 CFTOKEN=de8ec76b9d81fe15-B522171A-F3DE-44B5-3A82901FED26F8CA Request Parameters: adminpriv=1 application=Struct (1) banner_default=banner1 banner_url=/images bar_color=#537595 basehref=http://www.waterwaysireland.org/ breadcrumb=true color_list=#E84D4D,#E8BB4D,#4D77D6,#B1D64D,#9F68B1,#BC549D,#65ABAA,#3FD15B,#E8E34C compname=Waterways Ireland component_path=components contactaddress=info@waterwaysireland.org contacts_url=/index.cfm/section/contacts customer_feedback=/index.cfm?section=customer customerfrom=info@waterwaysireland.org deployment_key=1 dsn=WaterWays encrypt_key=124789547 event_url=/index.cfm/section/events expire_days=7 faq_submit_url=/index.cfm?section=faqsubmit faq_url=/index.cfm/section/faq faqfrom=info@waterwaysireland.org formformat=flash formskin=haloBlue icon_path=/icon image_path=/uploads/images/ language_abbr=EN language_key=1 mailport=25 mailserver=jim.biztechnet.com map_events_no=5 map_url=/map mappath=wiroot masterdsn=WaterWaysMaster mastersite=1 mastersiteurl=http://www.waterwaysireland.org notsafeurllist=postcard,faqsubmit,customer onrequest_path= pagetitle=Waterways Ireland ePortal parentkeylist= printformat=PDF printsize=A4 pub_path=/uploads/docs/pubs publications_url=/index.cfm/section/publications replaceand=/ replaceequal=/ replacequestion=/ resource_path=\resource_bundles\ session=Struct (10) site_path=D:\waterwaysireland\1.waterways.biznetservers.com\www_root site_url=http://www.waterwaysireland.org siteemail=info@waterwaysireland.org survey_menu_url=/index.cfm/section/surveys survey_url=/index.cfm thispage=/index.cfm/section/contacts/letter/Z/type/0/place/39/page/none/printfriendly/true/lang/1/content/none title=Waterways Ireland ePortal type_check=1 type_drop=4 type_radio=2 type_text=3 ultraseek=http://search.biznetservers.com ultraseek_menu=/common ultraseek_path=\verity userlang=request.application.lang.EN. videoclip_url=/video_clips website_key=1 Server Variables: COLDFUSION=Struct (8) OS=Struct (5) Session Variables: banner=banner8.jpg cfid=14280659 cftoken=de8ec76b9d81fe15-B522171A-F3DE-44B5-3A82901FED26F8CA content=none language_abbr=EN language_key=1 sessionid=WATERWAYS_FRONTEND_LIVE_14280659_de8ec76b9d81fe15-B522171A-F3DE-44B5-3A82901FED26F8CA suffix= surveys=Struct (0) urltoken=CFID=14280659&CFTOKEN=de8ec76b9d81fe15-B522171A-F3DE-44B5-3A82901FED26F8CA user=Struct (0) user_id=0 user_ip=84.23.9.163 user_loggedin=0 URL Parameters: ARTICLE=0 CONTENT=none LANG=1 LETTER=Z PAGE=none PLACE=39 PRINTFRIENDLY=true REGION=0 SECTION=contacts STARTROW=1 TYPE=0Debug Rendering Time: 141 ms |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm