Waterways Ireland ePortal
Waterways Ireland ePortal
    Fri 05 December 2008
 


Surveys

Order By: Closing Date | Title


There are currently no surveys to complete..
 
 


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /index.cfm
Time Stamp 05-Dec-08 12:13 PM
Locale English (UK)
User Agent ColdFusion
Remote IP 84.23.9.163
Host Name 84.23.9.163


Execution Time

Total Time Avg Time Count Template
32 ms 32 ms 1 top level D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm
16 ms 16 ms 1 CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\surveys_ft.cfc | surveys_all(dsn = WaterWays, orderby = close) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\surveys_ft.cfc
16 ms 16 ms 1 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm
16 ms 16 ms 1 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\options\surveys\inc_index.cfm
0 ms 0 ms 1 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm
0 ms 0 ms 1 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\OnRequestEnd.cfm
0 ms 0 ms 1 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm
0 ms 0 ms 1 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm
0 ms 0 ms 1 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\options\surveys\inc_surveys_listings.cfm
0 ms 0 ms 1 D:\waterwaysireland\1.waterways.biznetservers.com\www_root\sesConverter.cfm
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
47 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qGetLangsDef (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm @ 12:13:05.005
		SELECT language_key, language_default, language_abbr
		FROM language
		WHERE language_default = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_BIT) = YES

qGetLangs (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm @ 12:13:05.005
			SELECT language_key, language_abbr
			FROM language
			WHERE language_key = ?;
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

qGetLangs (Datasource=WaterWays, Time=0ms, Records=8) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 12:13:05.005
	SELECT DISTINCT L.language_key, L.language_name, L.language_abbr
	FROM  language L
qGetbanners (Datasource=WaterWays, Time=0ms, Records=9) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm @ 12:13:05.005
		SELECT banner_image
		FROM banner
		WHERE banner_show = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_BIT) = YES

qget_surveys (Datasource=WaterWays, Time=16ms, Records=0) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\surveys_ft.cfc @ 12:13:05.005
			SELECT     U.UserFirstName, U.UserEmail, U.UserLastName, S.surveys_title, S.surveys_synopsis, S.surveys_set_live, S.surveys_created_date, S.surveys_completion_date, S.surveys_start_date, S.surveys_id, S.surveys_members_only
			FROM       surveys S 
				       INNER JOIN Users U ON S.user_key = U.User_key
			WHERE      S.surveys_start_date < getDate() 
				       AND S.surveys_completion_date > getDate () 
				       AND S.surveys_set_live = ?
						
						
							ORDER BY S.surveys_completion_date
						
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1


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/surveys/orderby/close/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=13694042
CFTOKEN=de9ee823eb1ad715-0710C1BF-FA18-3685-59F005105DF38A12
Form Fields:
ID=0
START_ROW=1
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/surveys/orderby/close/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=banner10.jpg
cfid=13694042
cftoken=de9ee823eb1ad715-0710C1BF-FA18-3685-59F005105DF38A12
content=none
language_abbr=EN
language_key=1
sessionid=WATERWAYS_FRONTEND_LIVE_13694042_de9ee823eb1ad715-0710C1BF-FA18-3685-59F005105DF38A12
suffix=
surveys=Struct (0)
urltoken=CFID=13694042&CFTOKEN=de9ee823eb1ad715-0710C1BF-FA18-3685-59F005105DF38A12
user=Struct (0)
user_id=0
user_ip=84.23.9.163
user_loggedin=0
URL Parameters:
ACTION=none
AREA=none
ARTICLE=0
CONTENT=none
ERROR=false
FORMAT=flash
ID=0
LANG=1
ORDERBY=close
PAGE=none
PRINTFRIENDLY=true
QUEST_ID=0
REGION=0
SECTION=surveys
STARTROW=1
Debug Rendering Time: 93 ms