The Adventure Travel Series - Evening of films, slide shows and more.

      SELECT e.EventID,
             e.EventName,
             e.StartDateTime,
             e.EndDateTime,
             et.EventType,
						 et.EventTypeID,
             e.EventShortDesc,
             e.EventDescription,
             e.Location,
             e.EventURL,
						 e.logo,
             e.EventImage,
             e.EventImage2,
             e.EventImage3,
             e.EventImage4,
             e.EventImage5,
             e.ContactName,
             e.ContactPhone,
             e.ContactEmail,
             e.AllDayFlag,
						 e.active
        FROM cal_event e, cal_event_type et
       WHERE e.EventTypeID = et.EventTypeID
         AND e.EventID = 936
				 AND e.active = 1
       ORDER BY e.StartDateTime
      

					SELECT e.EventID, 
								 e.EventName, 
								 e.StartDateTime,	 
								 e.EndDateTime, 
								 e.EventShortDesc, 
								 e.Location, 
								 e.active, 
								 e.signature_event, 
								 e.EventImage, et.EventType
						FROM cal_event e INNER JOIN cal_event_type et ON e.EventTypeID = et.EventTypeID
					 WHERE active = 1 
					 	 AND (Month(e.StartDateTime) = 12 OR Month(e.EndDateTime) = 12)
						  AND (Year(e.StartDateTime) = 2007 OR Year(e.EndDateTime) = 2007)
					 ORDER BY e.StartDateTime
					

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 1 AND activity_type <> 'Mountain'
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 1 AND activity_type = 'Mountain'
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 2
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 6
				
		ORDER BY activity_type DESC, subcat
		

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=/home/ccvbuser/public_html/calendar/event_detail2.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
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=www.coloradoheadwaters.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/home/ccvbuser/public_html/calendar/event_detail2.cfm
QUERY_STRING=EventId=936&Month=12&Year=2007
REMOTE_ADDR=38.103.63.56
REMOTE_HOST=38.103.63.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/calendar/event_detail2.cfm
SERVER_NAME=www.coloradoheadwaters.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.41 (Unix) JRun/4.0 PHP/4.4.6 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
WEB_SERVER_API=

Cookie Variables:
CFGLOBALS=urltoken=CFID#=8653542&CFTOKEN#=44927411#lastvisit={ts '2008-12-04 13:11:31'}#timecreated={ts '2008-12-04 13:11:31'}#hitcount=2#cftoken=44927411#cfid=8653542#
CFID=8653542
CFTOKEN=44927411
LANGUAGE=english

Session Variables:
adminflag=false
cfid=8653542
cftoken=44927411
emailaddress=
initialized=true
lastlogin=
loggedinflag=false
name=
sessionid=APPS_8653542_44927411
urltoken=CFID=8653542&CFTOKEN=44927411
userid=

URL Parameters:
EVENTID=936
MONTH=12
YEAR=2007