GraduateGuide.com Welcome to GraduateGuide.com - a directory of Graduate Schools
in the United States and Canada

SEARCH PROGRAMS

Program Zip Distance Learning

Name or Keyword
Graduate Major
State or Province


SPONSORED GRADUATE SCHOOLS

Advertisement

SEARCH RESULTS

Environmental Science/Studies

Environmental Sciences Graduate ProgramsStudents who enroll in a Master of Science in Environmental Science degree program are equipped with the skills and knowledge required to study and protect the environment. These programs typically take two years to complete and can focus on conservation, as well as environmental biology, policy, education, and resource management. Students are typically required to complete environmental research and experiments, in addition to attending classes. Depending on the program, courses may cover pollution control, sustainability, and forest conservation. Graduates of these tracks can go on to work as environmental or climate control scientists, in addition to geoscientists and physicists.

There are 324 Graduate Schools that Offer Environmental Science/Studies

1-28 of 324 Results
SPONSORED LISTINGS
California Institute of Integral Studies
San Francisco, CA
California Institute of Integral Studies
1453 Mission St.,
San Francisco, CA
ContactOffice of Graduate Admissions
Phone415-575-6154
 
College of Staten Island, (CUNY)
City University of New York
Staten Island, NY
College of Staten Island, (CUNY)
City University of New York
2800 Victory Boulevard,
Staten Island, NY
ContactOffice of Recruitment and Admissions
Phone718-982-2019
 
Dowling College
Oakdale, NY
Dowling College
150 Idle Hour Blvd.,
Oakdale, NY
ContactOffice of Enrollment Services
Phone800-369-5464
631-244-3274
 
Fairleigh Dickinson University
Florham Campus
Madison, NJ
Fairleigh Dickinson University
Florham Campus
285 Madison Ave., Rothman Building, M-RI0-01
Madison, NJ
ContactOffice of Graduate Admissions
Phone973-443-8905
800-338-8803
 
Florida International University
Miami, FL
Florida International University
11200 S.W. 8th Street , PC 230, PO Box 659004
Miami, FL
ContactGraduate Admissions Office
Phone305-348-7442
 
Indiana State University
College of Graduate and Professional Studies
Terre Haute, IN
Indiana State University
College of Graduate and Professional Studies
318 North Sixth Street, 183 Tirey Hall
Terre Haute, IN
Phone800-444-GRAD
812-237-3005
 
New York Institute of Technology
Old Westbury, NY
New York Institute of Technology
Northern Boulevard,
Old Westbury, NY
ContactOffice of Graduate Admissions
Phone800-345-NYIT
 
Queens College
City University of New York
Queens, NY
Queens College
City University of New York
65-30 Kissena Boulevard, Jefferson Hall, Room 105
Queens, NY
ContactDirector of Graduate Admissions
Phone718-997-5200
 
University at Buffalo-SUNY
The Graduate School
Buffalo, NY
University at Buffalo-SUNY
The Graduate School
408 Capen Hall,
Buffalo, NY
Phone716-645-3482
 
State University of New York College at Brockport
Brockport, NY
State University of New York College at Brockport
350 New Campus Drive,
Brockport, NY
Phone585-395-2525
 
St. Cloud State University
School of Graduate Studies
Saint Cloud, MN
St. Cloud State University
School of Graduate Studies
720 Fourth Avenue South , 121 Administrative Services
Saint Cloud, MN
ContactOffice of Graduate Admissions
Phone320-308-2113
 
St. Cloud State University
School of Graduate Studies
Saint Cloud, MN
St. Cloud State University
School of Graduate Studies
720 Fourth Avenue South , 121 Administrative Services
Saint Cloud, MN
ContactOffice of Graduate Admissions
Phone320-308-2113
 
South Dakota State University
Graduate School
Brookings, SD
South Dakota State University
Graduate School
Box 2201, Room 130
Brookings, SD
ContactGraduate School Admissions
Phone605-688-4181
 
Southern Connecticut State University
School of Graduate Studies
New Haven, CT
Southern Connecticut State University
School of Graduate Studies
501 Crescent Street, B110,
New Haven, CT
ContactDirector of Graduate Admissions
Phone203-392-5240
 
Stevens Institute of Technology
Hoboken, NJ
Stevens Institute of Technology
One Castle Point on Hudson,
Hoboken, NJ
ContactOffice of Graduate Admissions
Phone1-888-STEVENS
 
Stockton University
Graduate Studies
Galloway, NJ
Stockton University
Graduate Studies
101 Vera King Farris Drive,
Galloway, NJ
Phone609-626-3640
 
University of Central Florida
College of Graduate Studies
Orlando, FL
University of Central Florida
College of Graduate Studies
4000 Central Florida Blvd., PO Box 160112
Orlando, FL
Phone407-823-2766
 
University of Idaho
Graduate Studies
Moscow, ID
University of Idaho
Graduate Studies
875 Perimeter Drive, MS 3019,
Moscow, ID
ContactGraduate Admissions
Phone208-885-4001
208-885-4723
 
West Texas A&M University
Canyon, TX
West Texas A&M University
2403 Russell C. Long Blvd., WT Box 60215
Canyon, TX
ContactOffice of Graduate Admissions
Phone806-651-2730
 
GENERAL LISTINGS
Air Force Institute of Technology
Graduate School of Engineering and Management
Wright-Patterson AFB, OH
Air Force Institute of Technology
Graduate School of Engineering and Management
2950 Hobson Way,
Wright-Patterson AFB, OH
ContactOffice of Admissions
Phone937-255-3636 3137
 
Alaska Pacific University
Anchorage, AK
Alaska Pacific University
4101 University Drive,
Anchorage, AK
ContactDirector of Admissions
Phone800-252-7528
907-564-8248
 
American University
Washington, DC
American University
4400 Massachusetts Avenue, N.W.,
Washington, DC
ContactOffice of Graduate Admissions
Phone202-885-6000
 
Antioch University Los Angeles
Culver City, CA
Antioch University Los Angeles
400 Corporate Pointe,
Culver City, CA
ContactOffice of Graduate Admissions
Phone310-578-1080 100
 
Antioch University New England
Keene, NH
Antioch University New England
40 Avon Street,
Keene, NH
ContactOffice of Graduate Admissions
Phone800-553-8380
 
Antioch University Seattle
Seattle, WA
Antioch University Seattle
2326 Sixth Ave.,
Seattle, WA
Phone888-268-4477
206-268-4202
 
Arizona State University
Graduate College
Tempe, AZ
Arizona State University
Graduate College
1151 S. Forest Ave. #SSV112, PO Box 871003
Tempe, AZ
ContactGraduate Admissions Services
Phone480-965-6113
 
Arizona State University
Polytechnic Campus
Mesa, AZ
Arizona State University
Polytechnic Campus
7001 E. Williams Field Road,
Mesa, AZ
Phone480-727-1585
 
Arkansas State University-Jonesboro
State University, AR
Arkansas State University-Jonesboro
PO Box 1570,
State University, AR
ContactGraduate Admissions
Phone870-972-2031
 

There were 324 schools found that offer Environmental Science/Studies

SPONSORED PROGRAMS


Debugging Information
ColdFusion Server Standard 10,0,13,287689
Template /results.cfm
Time Stamp 02-Jul-16 03:21 AM
Locale English (US)
User Agent ColdFusion
Remote IP 108.54.112.66
Host Name 108.54.112.66


Execution Time

Total Time Avg Time Count Template
2672 ms 2672 ms 1 D:/Websites/graduateguide_PROD/results.cfm
1343 ms 1343 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
1078 ms 1078 ms 1 D:/Websites/graduateguide_PROD/header.cfm
860 ms 860 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
750 ms 83 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
235 ms 235 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
125 ms 125 ms 1 D:/Websites/graduateguide_PROD/includes/pod3.cfm
125 ms 125 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
125 ms 125 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
109 ms 109 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(major = 7017, pos = 6) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
93 ms 93 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
78 ms 78 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
63 ms 63 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
46 ms 46 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | INIT_tracking() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
31 ms 31 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | referTracking_save_UA_reference(10, 8368979) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrMajorAdID(MAJ = 7017) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = , session_UUID = '*5?*W-_)W@ , pagename = /results.cfm?, PageItemID = ) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_USER_AGENT_insert() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestEnd(/results.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestStart(/results.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 1) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 2) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 4) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | cfcookie(session_UUID, '*5?*W-_)W@ , ) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | cfcookie(show_debug, Yes) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 2 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | de_crypt(stretchtite, '*5?*W-_)W@ ) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | en_crypt(stretchtite, 8368979) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 D:/Websites/security/application.cfm
61 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2796 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=10, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:21:13.013
	SELECT adID FROM active_data_ad_list_vw
	WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=3, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:21:13.013
	SELECT adID FROM active_data_ad_list_vw
	WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=5, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:21:13.013
	SELECT adID FROM active_data_ad_list_vw
	WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=9, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:21:13.013
	SELECT adID FROM active_data_ad_list_vw
	WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=2, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:21:13.013
	SELECT adID FROM active_data_ad_list_vw
	WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5

checkDOMAIN (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 03:21:13.013
		SELECT     site_ID, p_site_ID
		FROM         frontend_site
		WHERE site_URL = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = www.graduateguide.com

INITsessionlog (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 03:21:13.013
		INSERT INTO referTracking_SessionID(ipaddress, site_ID)
		VALUES(
			?,
			?
			);
		
		SELECT SCOPE_IDENTITY() AS session_UUID;
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 108.54.112.66
Parameter #2(CF_SQL_INTEGER) = 2

save_UA_reference (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 03:21:13.013
    UPDATE referTracking_sessionID
    SET agent_ID = ?
    WHERE session_UUID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10
Parameter #2(cf_sql_integer) = 8368979

saveStart (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 03:21:13.013
            INSERT INTO user_session ( dateStart, ip_address, host_name, agent_ID, session_UUID )
            VALUES
            (
            getDate(),
            ?,
            ?,
            ?,
            ?
            )
            SELECT scope_identity() as new_entryID
            
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 108.54.112.66
Parameter #2(cf_sql_varchar) = graduateguide.com
Parameter #3(cf_sql_integer) = 10
Parameter #4(cf_sql_integer) = 8368979

qryH_Major (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results.cfm @ 03:21:13.013
    SELECT major as majorName, descr FROM majors WHERE major_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7017

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 18

trackAd_viewing (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 18

getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 03:21:13.013
SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
ORDER BY sortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1

getSubnav (Datasource=graduateguide_prod, Time=15ms, Records=11) in D:\Websites\graduateguide_PROD\navigation.cfm @ 03:21:13.013
SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
ORDER BY sortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2

getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=6) in D:\Websites\graduateguide_PROD\navigation.cfm @ 03:21:13.013
SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
ORDER BY sortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4

getSubnav (Datasource=graduateguide_prod, Time=31ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 03:21:13.013
SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
ORDER BY sortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5

getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=2) in D:\Websites\graduateguide_PROD\navigation.cfm @ 03:21:13.013
SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
ORDER BY sortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6

getSubnav (Datasource=graduateguide_prod, Time=15ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 03:21:13.013
SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
ORDER BY sortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7

major_links (Datasource=graduateguide_prod, Time=32ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:21:13.013
  SELECT m.major_id, m.major, ml.display_name, ss.displayname, count(cm.major_id) as total
  FROM major_links ml
    LEFT JOIN majors m ON ml.major_id = m.major_id
    RIGHT JOIN college_majors cm ON cm.major_id = m.major_id
    inner join saved_search ss ON ss.major = m.major_id
  WHERE ml.status = 'true' AND
  ss.state = 'none'
    AND ss.status = 'A'
  group by m.major_id, m.major, ml.display_name, ss.displayname
  ORDER BY TOTAL DESC
getMajors (Datasource=graduateguide_prod, Time=15ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:21:13.013
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=16ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:21:13.013
           SELECT DISTINCT majors.major_id, majors.major as major_name 
           FROM college_majors INNER JOIN majors ON college_majors.major_id =majors.major_id 
           WHERE (college_majors.online = 1) ORDER BY majors.major
           
getMajors2 (Datasource=graduateguide_prod, Time=31ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:21:13.013
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=16ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:21:13.013
SELECT TOP 9 adID FROM active_data_ad_list_vw
WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 200

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 200

qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 206

trackAd_viewing (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 206

qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 16

trackAd_viewing (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 16

qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 175

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 175

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:13.013
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 139

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:14.014
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 139

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:14.014
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 169

trackAd_viewing (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:14.014
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 169

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:14.014
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 167

trackAd_viewing (Datasource=graduateguide_prod, Time=79ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:14.014
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 167

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:14.014
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:14.014
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9

getmajor (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
		select *
		from majors
		where major_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7017

getColleges (Datasource=graduateguide_prod, Time=125ms, Records=324) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
		select *, 'sponsor' as rank, 1 as show
		from parentChild_collegeMajor
		where web_ad = 'Y'
		and major = 7017
		union ALL
		select *, 'general' as rank, 1 as show
		from parentChild_collegeMajor
		where  web_ad <> 'Y'
		and major = 7017 
		order by rank desc, sort_uni, college_name asc, school_name
	
toRemove (Datasource=, Time=16ms, Records=324) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (44,701,721,2518,217,381,756,766,1619,1619,2260,169,675,1238,2412,785,233,1478,2145,858,1290,197,32,641,2180,1333,1329,1296,3,372,687,1958,1597,2678,913,1475,488,503,689,999,1000,45,39,50,53,56,60,917,919,868,158,2182,920,1090,1010,692,693,508,695,1011,872,1091,1360,1365,707,703,262,1132,509,715,928,822,825,929,325,932,264,2208,724,215,1217,216,221,1491,450,2838,933,1094,2402,2815,451,327,2471,1971,520,452,84,1476,329,332,391,382,394,1445,629,1098,453,2946,454,1492,1162,1979,946,530,1045,92,738,1536,93,739,1119,535,1164,1165,1563,1018,2537,886,597,603,95,953,1616,634,1730,1748,664,837,462,1378,1229,97,666,1818,1823,1824,758,760,2979,764,1564,838,1766,347,1344,225,606,893,894,1869,1106,1910,1911,762,1505,650,961,1926,1346,668,404,1167,767,1998,769,2428,2020,965,8,120,3063,2259,1692,359,2005,1575,130,2023,781,784,783,801,794,806,2025,969,1056,2027,2030,2031,2034,2040,2010,2045,467,1168,10,11,2486,1577,16,3077,2790,20,1291,1293,1349,1320,133,134,136,137,2811,138,141,1646,2281,899,1385,1392,1399,172,195,1405,613,901,234,296,302,303,1169,2613,1415,2103,2114,363,364,365,1462,1509,433,441,471,472,470,473,474,560,561,564,239,235,619,621,1625,1627,1709,1722,1758,1803,1850,1849,653,177,847,851,1771,2126,1886,1936,1170,977,973,1008,989,1023,250,1178,1064,1063,2056,2065,2084,2085,1172,1085,1112,2212,1173,252,1174,1175,1144,1146,1152,1153,2232,1086,1113,1114,2225,2464,2465,1213,1125,368,434,2229,1522,907,180,184,1177,909) 
getParents (Datasource=, Time=0ms, Records=324) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
    select *
 	from getColleges
	where subcollege_id = 0
	and rank <> 'sponsor'
	union all
    select *
 	from getColleges
	where rank = 'sponsor'
	order by rank desc, sort_uni, college_name asc, school_name
getStateName (Datasource=graduateguide_prod, Time=31ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
SELECT StateName as state
FROM StateList
WHERE StateCode = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = none

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 44

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 701

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 721

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2518

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 217

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 381

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 756

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 766

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2412

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 785

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1619

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:14.014
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1619

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2260

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 169

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 675

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1238

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 233

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1478

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2145

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 858

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1290

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 197

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 32

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 641

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2180

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1333

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1329

getContact (Datasource=graduateguide_prod, Time=46ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:21:15.015
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1296

getAdIDs (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\includes\pod3.cfm @ 03:21:15.015
SELECT adID FROM active_data_ad_list_vw
WHERE positionID = ?
AND major = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6
Parameter #2(cf_sql_integer) = 7017

getAdIDs (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:21:15.015
	SELECT adID FROM active_data_ad_list_vw
	WHERE positionID = ? 
	AND major = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6
Parameter #2(cf_sql_varchar) = 7017

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:15.015
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124

trackAd_viewing (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:15.015
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 124

qryGetFooterLinks (Datasource=graduateguide_prod, Time=16ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 03:21:15.015
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:15.015
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 141

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:21:15.015
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '07/02/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 141

updTracking (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 03:21:15.015
	INSERT INTO referTracking_pages(url,session_UUID,pageTypeID,PageItemID)
	VALUES(
		?,
		?,
		NULL,
		NULL
	)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = /results.cfm?
Parameter #2(CF_SQL_INTEGER) = 8368979


Stored Procedures

sp_referTracking_USER_AGENT_insert (Datasource=graduateguide_prod, Time=16ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 03:21:13.013

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_VARCHAR  ColdFusion    
    
resultsets
nameresultset
 result  1
dbo.main_navigation (Datasource=graduateguide_prod, Time=16ms) in D:\Websites\graduateguide_PROD\navigation.cfm @ 03:21:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
    
resultsets
nameresultset
 getMain  1


Scope Variables

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:\Websites\graduateguide_PROD\results.cfm
CONTENT_LENGTH=83
CONTENT_TYPE=application/x-www-form-urlencoded
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.graduateguide.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=
PATH_TRANSLATED=D:\Websites\graduateguide_PROD\results.cfm
QUERY_STRING=
REMOTE_ADDR=108.54.112.66
REMOTE_HOST=108.54.112.66
REMOTE_USER=
REQUEST_METHOD=POST
SCRIPT_NAME=/results.cfm
SERVER_NAME=www.graduateguide.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Cookie Variables:
CFID=5689890
CFTOKEN=aebe9cc3752b9722-A8D3BC3A-D6CB-A1FB-FA5A2ACA7AF56036
SESSION_UUID=%27%2A5%3F%2AW%2D%5F%29W%40%20%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=Environmental_Science_Studies
FIELDNAMES=NAME,MAJOR,STATE,PAGENUM,DISPLAYNAME
MAJOR=7017
NAME=
PAGENUM=1
STATE=none
Session Variables:
cfid=5689890
cftoken=aebe9cc3752b9722-A8D3BC3A-D6CB-A1FB-FA5A2ACA7AF56036
entryid=8405060
session_uuid=8368979
sessionid=GARDUATEGUIDE_5689890_aebe9cc3752b9722-A8D3BC3A-D6CB-A1FB-FA5A2ACA7AF56036
urltoken=CFID=5689890&CFTOKEN=aebe9cc3752b9722-A8D3BC3A-D6CB-A1FB-FA5A2ACA7AF56036
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 16 ms