SELECT AreaID
			FROM Project
			WHERE ID = 2
		

			
				SELECT *
				FROM Project
				WHERE AreaId = 12
			
		

		
			SELECT AreaID, imgTitleEN AS imgTitle
			FROM Project
			WHERE id = 2
			
		
	

			SELECT imgBackgroundSmall, imgTitleEN AS imgTitle
			
				FROM AreaOfWork
				WHERE id = 12
			
		

			SELECT imgBackgroundSmall, imgTitleEN AS imgTitle
			
				FROM AreaOfWork
				WHERE id = 12
			
			
		

	SELECT id, nameEN
	FROM AboutUsLvl2

	SELECT id, nameEN
	FROM AreaOfWork
	ORDER BY nameEN ASC

			Select NameEN as Name from AreaOfWork Where id = 12
		

	SELECT *, LongDescriptionEN as LongDescription
	FROM Project
	WHERE id = 2

	SELECT *
	FROM Activity
	WHERE ProjectID = 2

		SELECT LeftColImageEN AS LeftColImage
		FROM Project
		WHERE ID = 2
		AND LeftColImageEN IS NOT NULL
	

		Select * from Project
		Where id = 2
	

		Select *, LinkTitle_EN as LinkTitle, Link_EN as Link from ProjectEssentialOther
		Where ProjectId = 2
	

	
		SELECT * FROM Activity
		WHERE ProjectId = 2 and MotherActivityId = 0
	

	
		SELECT * FROM Activity
		WHERE Id = 0 and MotherActivityId <> 0
	

	SELECT Top 1 dbo.Event.id, dbo.Event.dtStart, dbo.Event.TitleEN as Title
	FROM dbo.v_EventProjects INNER JOIN dbo.Event ON dbo.v_EventProjects.id = dbo.Event.id
	Where dbo.v_EventProjects.EventProjectId = '2' and dbo.Event.dtStart > getDate() and dbo.Event.EventStatusId = 2
	Order by dbo.Event.dtStart desc

	SELECT Top 3 dbo.Publication.id, dbo.Publication.dtIn, dbo.Publication.TitleEN as title
	FROM dbo.v_PublicationProjects INNER JOIN dbo.Publication ON dbo.v_PublicationProjects.id = dbo.Publication.id
	Where dbo.v_PublicationProjects.ProjectId = '2' and dbo.Publication.PublicationStatusId = 1

	SELECT Top 3 dbo.NewsRelease.id, dbo.NewsRelease.dtIn, dbo.NewsRelease.TitleEN as Title
	FROM dbo.v_NewsProjects INNER JOIN dbo.NewsRelease ON dbo.v_NewsProjects.id = dbo.NewsRelease.id
	Where dbo.v_NewsProjects.NewsProjectId = '2' and dbo.NewsRelease.NewsStatusId = 4
	Order by dbo.NewsRelease.dtIn desc

Application Variables:
applicationname=cec2
appstarted={ts '2007-07-31 10:40:17'}
dsn=cec2db
root=/newweb/dev/
rootpath=D:\CFusionMX7\wwwroot\newweb\dev\

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:\CFusionMX7\wwwroot\newweb\dev\area\project\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=gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=PREFVARLAN=english; CFGLOBALS=urltoken%3DCFID%23%3D3825%26CFTOKEN%23%3D48872516%26jsessionid%23%3Dac303b8666db7c587b11%23lastvisit%3D%7Bts%20%272007%2D07%2D24%2016%3A20%3A34%27%7D%23timecreated%3D%7Bts%20%272006%2D06%2D07%2010%3A28%3A12%27%7D%23hitcount%3D237%23cftoken%3D63665612%23cfid%3D3096%23; CFCLIENT_CEC=contactid%3D%23loggedin%3D0%23email%3D%23password%3D%23; USER.EMAIL=jsgoulet%40cec%2Eorg; CFADMIN_LASTPAGE=%2Fcfide%2Fadministrator%2Fdatasources%2Findex%2Ecfm; IsoLanguage=en; CFID=5506; CFTOKEN=23396723; JSESSIONID=ac30b4940c895334174b
HTTP_HOST=intranet
HTTP_REFERER=
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)
PATH_INFO=/newweb/dev/Area/project/index.cfm
PATH_TRANSLATED=D:\CFusionMX7\wwwroot\newweb\dev\area\project\index.cfm
QUERY_STRING=id=12&projectId=2
REMOTE_ADDR=205.151.216.117
REMOTE_HOST=205.151.216.117
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/newweb/dev/Area/project/index.cfm
SERVER_NAME=intranet
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Cookie Variables:
CFADMIN_LASTPAGE=/cfide/administrator/datasources/index.cfm
CFCLIENT_CEC=contactid=#loggedin=0#email=#password=#
CFGLOBALS=urltoken=CFID#=3825&CFTOKEN#=48872516&jsessionid#=ac303b8666db7c587b11#lastvisit={ts '2007-07-24 16:20:34'}#timecreated={ts '2006-06-07 10:28:12'}#hitcount=237#cftoken=63665612#cfid=3096#
CFID=5506
CFTOKEN=23396723
IsoLanguage=en
JSESSIONID=ac30b4940c895334174b
PREFVARLAN=english
USER.EMAIL=jsgoulet@cec.org

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)

Session Variables:
sessionid=ac30b4940c895334174b
urltoken=CFID=5506&CFTOKEN=23396723&jsessionid=ac30b4940c895334174b
varlan=ENGLISH
varlanext=EN

URL Parameters:
ID=12
PROJECTID=2