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

Education

Education Graduate ProgramsEducation graduate programs are designed for instructors who wish to broaden their teaching knowledge and gain skills that can help them advance their careers. Most education graduate programs prepare students for positions as elementary, middle and high school teachers, as well as roles instructing the physically, mentally or emotionally disabled. This area of study also provides preparation for leadership positions such as supervisors and administrators. Though it depends on the degree, Master's of Education programs typically take between two and five years to complete. Earning this degree can also prepare individuals to pursue their Doctor of Education.

There are 1159 Graduate Schools that Offer Education

1-28 of 1159 Results
SPONSORED LISTINGS
Adelphi University
Garden City, NY
Adelphi University
One South Avenue, PO Box 701
Garden City, NY
ContactOffice of Graduate Admissions
Phone800-ADELPHI
516-877-3050
 
Alabama Agricultural and Mechanical University
School of Graduate Studies
Normal, AL
Alabama Agricultural and Mechanical University
School of Graduate Studies
4900 Meridian Street North, PO Box 998
Normal, AL
ContactOffice of Graduate Admissions
Phone256-372-5266
866-497-1689
 
Antioch University Midwest
Antioch University
Yellow Springs, OH
Antioch University Midwest
Antioch University
900 Dayton Street,
Yellow Springs, OH
ContactOffice of Graduate Admissions
Phone937-769-1818
 
Austin Peay State University
College of Graduate Studies
Clarksville, TN
Austin Peay State University
College of Graduate Studies
PO Box 4458,
Clarksville, TN
ContactOffice of Graduate Admissions
Phone931-221-7414
800-859-4723
 
Campbellsville University
Campbellsville, KY
Campbellsville University
1 University Drive, UPO 805
Campbellsville, KY
ContactOffice of Graduate Admissions
Phone800-264-6014
270-789-5221
 
Castleton University
Castleton, VT
Castleton University
86 Seminary Street,
Castleton, VT
Phone800-639-8521
802-468-1213
 
Centenary College
Hackettstown, NJ
Centenary College
400 Jefferson Street,
Hackettstown, NJ
ContactOffice of Graduate Admissions
Phone877-236-4723
908-852-1400
 
Central Michigan University
Mount Pleasant, Michigan Campus
Mt. Pleasant, MI
Central Michigan University
Mount Pleasant, Michigan Campus
100 Foust Hall ,
Mt. Pleasant, MI
ContactGraduate Student Services
Phone989-774-4723
 
Champlain College
Burlington, VT
Champlain College
163 South Willard Street, PO Box 670
Burlington, VT
ContactOffice of Graduate Admissions
Phone866-282-7259
 
College of Saint Rose
Albany, NY
College of Saint Rose
432 Western Avenue,
Albany, NY
ContactOffice of Graduate Admissions
Phone518-454-5143
 
The College of St. Scholastica
Duluth, MN
The College of St. Scholastica
1200 Kenwood Avenue,
Duluth, MN
ContactOffice of Graduate Admissions
Phone(888) 298-4723
 
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
 
College of William & Mary
School of Education
Williamsburg, VA
College of William & Mary
School of Education
301 Monticello Avenue,
Williamsburg, VA
Phone757-221-2317
 
Dakota State University
Madison, SD
Dakota State University
820 North Washington, Heston Hall
Madison, SD
ContactOffice of Graduate Studies & Research
Phone605-256-5799
888-DSU-9988
 
Drew University
Caspersen School of Graduate Studies
Madison, NJ
Drew University
Caspersen School of Graduate Studies
36 Madison Avenue, 12 Campus Drive
Madison, NJ
ContactOffice of Graduate Admissions
Phone973-408-3111
 
Fairleigh Dickinson University
Teaneck, NJ
Fairleigh Dickinson University
1000 River Road, (T-KB1-01)
Teaneck, NJ
ContactOffice of Graduate Admissions
Phone800-338-8803
 
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
 
Hofstra University
Hempstead, NY
Hofstra University
126 Hofstra University, 105 Memorial Hall
Hempstead, NY
ContactOffice of Graduate Admissions
Phone1-866-GRADHOF
516-463-4723
 
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
 
Liberty University
The Graduate School
Lynchburg, VA
Liberty University
The Graduate School
1971 University Blvd.,
Lynchburg, VA
ContactOffice of Resident Graduate Admissions
Phone877-298-9617
 
Lock Haven University
Lock Haven, PA
Lock Haven University
401 N. Fairview Street,
Lock Haven, PA
ContactOffice of Graduate Admissions
Phone570-484-2109
570-484-2027
 
Madonna University
Graduate School
Livonia, MI
Madonna University
Graduate School
36600 Schoolcraft Road,
Livonia, MI
Phone800-852-4951 5667
734-432-5667
 
Molloy College
Rockville Centre, NY
Molloy College
Office of Graduate Admissions, 1000 Hempstead Ave
Rockville Centre, NY
Phone516-323-4000
 
Monmouth University
West Long Branch, NJ
Monmouth University
400 Cedar Avenue, Office of Graduate Admission
West Long Branch, NJ
Phone800-320-7754
732-571-3452
 
Morehead State University
Morehead, KY
Morehead State University
701 Ginger Hall,
Morehead, KY
ContactGraduate School
Phone606-783-2039
 
Mount St. Joseph University
Cincinnati, OH
Mount St. Joseph University
5701 Delhi Road,
Cincinnati, OH
ContactOffice of Graduate Admission
Phone800-654-9314
513-244-4723
 
Mount Saint Mary's University, Los Angeles
Los Angeles, CA
Mount Saint Mary's University, Los Angeles
10 Chester Place,
Los Angeles, CA
ContactGraduate Admission Office
Phone213-477-2800
 

There were 1159 schools found that offer Education

SPONSORED PROGRAMS


Debugging Information
ColdFusion Server Standard 10,0,13,287689
Template /results.cfm
Time Stamp 27-Aug-16 02:15 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
2656 ms 2656 ms 1 D:/Websites/graduateguide_PROD/results.cfm
1329 ms 1329 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
953 ms 953 ms 1 D:/Websites/graduateguide_PROD/header.cfm
765 ms 765 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
687 ms 76 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
359 ms 359 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
250 ms 250 ms 1 D:/Websites/graduateguide_PROD/includes/pod3.cfm
250 ms 250 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
235 ms 78 ms 3 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(major = 7014, pos = 6) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
110 ms 110 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
78 ms 78 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
78 ms 78 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
47 ms 47 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
31 ms 31 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | INIT_tracking() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = , session_UUID = '*5W,UM?'UP , 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 | referTracking_save_UA_reference(10, 8902190) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
15 ms 15 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 3 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrMajorAdID(MAJ = 7014) ] 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, '*5W,UM?'UP , ) ] 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, '*5W,UM?'UP ) ] 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, 8902190) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 D:/Websites/security/application.cfm
31 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2734 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 @ 02:15:57.057
	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=2, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 02:15:57.057
	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=4, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 02:15:57.057
	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 @ 02:15:57.057
	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=6, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 02:15:57.057
	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=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 02:15:57.057
		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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 02:15:57.057
		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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 02:15:57.057
    UPDATE referTracking_sessionID
    SET agent_ID = ?
    WHERE session_UUID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10
Parameter #2(cf_sql_integer) = 8902190

saveStart (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 02:15:57.057
            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) = 8902190

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

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	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) = 188

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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) = 188

getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 02:15:57.057
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 @ 02:15:57.057
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 @ 02:15:57.057
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=16ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 02:15:57.057
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=15ms, Records=2) in D:\Websites\graduateguide_PROD\navigation.cfm @ 02:15:57.057
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=16ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 02:15:57.057
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=15ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 02:15:57.057
  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=16ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 02:15:57.057
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=16ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 02:15:57.057
           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=15ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 02:15:57.057
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=16ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 02:15:57.057
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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	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=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:57.057
	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 @ 02:15:58.058
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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 @ 02:15:58.058
	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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:58.058
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:58.058
	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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:58.058
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:58.058
	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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:58.058
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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

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

getColleges (Datasource=graduateguide_prod, Time=406ms, Records=1159) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:58.058
		select *, 'sponsor' as rank, 1 as show
		from parentChild_collegeMajor
		where web_ad = 'Y'
		and major = 7014
		union ALL
		select *, 'general' as rank, 1 as show
		from parentChild_collegeMajor
		where  web_ad <> 'Y'
		and major = 7014 
		order by rank desc, sort_uni, college_name asc, school_name
	
toRemove (Datasource=, Time=16ms, Records=1159) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:58.058
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=16ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:58.058
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (679,1,859,1027,2279,1075,655,577,2439,700,1601,701,2994,2249,658,659,2518,217,729,381,1099,948,586,746,663,424,873,96,754,756,761,544,766,164,1108,2559,167,1619,1619,439,674,2260,169,551,3003,1238,2412,785,1058,2450,233,1478,562,443,975,1633,2261,991,2140,2145,566,537,1951,2855,1355,2,255,157,2441,627,684,47,2325,1128,2687,256,477,143,197,2775,2806,2739,572,1954,479,32,641,2531,2180,819,573,2974,911,3042,274,330,2286,2463,310,2460,2951,2454,2285,27,2939,2461,31,249,219,626,1088,1333,1334,1296,1303,257,860,2362,2584,861,2457,481,3,4,1593,2949,2246,314,1089,1644,35,1480,863,372,445,686,687,211,2883,688,2321,1958,1236,417,1029,1597,1481,316,1074,259,2893,374,1034,1599,37,1158,2247,913,2736,3002,2268,3079,1475,2329,486,500,488,498,446,864,317,503,2807,260,418,506,2147,1159,689,999,2746,1000,915,1426,375,916,1275,654,40,2574,46,48,39,49,2452,50,51,54,52,53,55,56,57,58,59,60,61,62,917,2359,575,507,1851,820,691,1203,1129,212,918,1130,1035,1131,821,1220,2344,1258,1529,158,1645,2308,2182,1779,1412,64,1009,920,921,922,319,2897,1036,1090,1010,692,693,2183,67,923,261,508,1427,2698,1011,872,1279,2972,696,1474,698,656,699,657,2598,1076,1091,1357,1358,1377,1365,2957,1410,1652,1012,1013,807,262,2894,2616,3060,1898,72,1781,1161,1232,321,1602,1967,1132,1014,449,2638,2431,715,2963,263,1782,1038,510,718,719,2831,1969,2653,874,193,1268,628,322,926,1786,720,323,74,1434,1435,928,2898,1656,929,1288,830,1852,930,1039,2978,160,325,420,1092,580,511,1813,2642,931,2188,1133,932,1254,2333,1223,723,1228,831,512,513,2332,264,1484,514,2290,1660,2208,161,2533,832,660,581,75,515,725,214,215,1217,216,2684,220,221,1663,726,1490,3025,271,516,1015,875,1237,1041,77,1491,450,1016,199,933,833,934,1901,1094,2405,421,272,275,276,277,661,1077,2190,517,2815,451,327,378,1790,1441,2658,1530,1341,583,2873,2899,935,2379,2300,936,1605,1095,2820,1971,1308,2532,527,1792,311,529,878,1313,2191,834,1096,937,82,452,83,1977,2657,202,3067,84,730,379,1476,2997,329,332,938,384,382,2871,392,393,939,395,396,397,394,398,731,1445,732,629,7,222,1098,733,1316,879,2481,1001,1078,1042,2393,1492,2543,662,647,2571,335,1234,279,880,422,2384,2273,940,941,943,89,280,881,338,2438,1162,1134,1979,1271,1017,1853,2426,585,736,945,1043,946,737,835,530,1985,1903,339,339,2692,1044,947,1670,1672,423,1045,738,1100,1452,2603,1536,1554,1555,2368,93,340,460,1556,1986,1101,1079,224,1453,437,882,739,741,742,949,2710,1135,883,744,1080,1136,2933,1119,2879,1102,587,461,1905,1104,1674,950,532,533,476,1164,2436,1165,1563,2996,1244,2537,1047,285,745,952,836,2738,2847,2534,685,2865,886,590,593,603,1501,1049,95,2881,2697,2501,1987,953,1050,94,1616,1617,1765,924,631,632,633,634,1678,2668,1699,2664,1748,1747,1756,664,954,462,1456,2251,1139,2874,747,463,887,2640,425,2796,1378,2252,344,97,749,1795,955,648,665,1818,1824,2609,2849,760,1502,1564,1105,838,839,841,345,2742,346,2341,347,1854,1344,349,426,604,2255,1907,1679,1477,2633,3050,1859,1567,350,890,71,448,225,2400,403,606,2588,288,2364,893,2825,2826,894,2764,1862,1869,2635,1106,351,1166,1870,1911,1503,895,1569,1990,762,2194,105,107,1923,1680,2272,957,109,1796,289,1505,650,111,961,1926,2673,1993,1346,1003,404,405,1167,843,352,1107,669,2754,545,1382,2702,2969,1004,1005,1998,670,651,962,768,769,353,1684,2595,2930,2322,227,354,963,671,2428,771,608,772,1600,2020,964,773,774,775,965,776,228,1688,2197,2720,1622,2022,113,1083,673,777,229,2397,356,844,1121,546,466,956,2001,8,3070,115,118,120,121,778,357,547,779,2003,2198,2203,966,1256,2759,1109,2765,967,609,2627,1142,2797,2622,124,2258,1084,968,549,2954,125,1020,2743,1692,1570,1874,1285,1319,358,359,2005,652,1935,1575,2157,1021,1695,1623,2018,2019,1507,1879,429,360,610,9,1458,130,2023,1704,231,205,2024,1267,781,782,784,783,787,788,789,790,791,2398,792,793,794,795,2753,806,2025,2713,2956,969,1055,1056,2975,2026,2027,3065,2029,2030,2031,2836,2032,2034,2040,2010,2045,2051,2053,440,1239,430,1221,896,3030,808,2276,2626,467,206,3027,361,1264,2101,10,11,12,1706,554,1059,431,897,2382,1060,18,2790,1103,898,19,20,1291,1293,1294,1349,1320,1321,1322,1323,972,171,133,134,136,137,138,141,142,1325,1646,1884,2281,362,899,1385,1392,1399,172,419,2102,900,195,1405,614,901,234,299,176,2613,1415,2103,2114,2515,2118,363,364,365,2139,411,1462,2885,1509,432,144,1579,1580,433,441,2848,1767,2122,472,470,473,474,560,561,564,1061,243,619,621,622,1625,1627,636,1709,1722,1733,22,1758,23,2824,1803,1797,1802,1850,1849,653,177,1834,1581,24,847,848,849,850,851,1771,248,287,2126,2991,1408,1466,2536,1886,1936,1170,145,979,1289,427,988,1937,2211,146,1008,1111,902,811,1219,413,168,2579,2134,147,148,990,2264,25,1023,1024,1025,250,1178,414,444,639,366,251,1064,1063,1065,2056,2065,2077,2084,2085,2086,2096,2073,207,1811,903,1172,1893,2161,1085,1112,2212,26,252,294,1174,1175,1143,1144,1145,1146,1147,1148,1150,1151,1152,1153,1154,1155,2232,1473,1266,904,2169,2590,812,308,2630,415,1072,367,151,2837,1113,1115,1114,1156,813,852,1637,2224,905,1942,2289,1519,2225,2270,2464,2465,1736,1809,624,992,2172,1742,1213,309,993,2942,1125,1126,3074,856,179,368,434,625,565,1846,1943,2959,2229,2175,994,369,1127,567,154,2230,1522,996,1176,997,640,2772,3075,3058,678,1746,196,2752,857,1639,1257,1026,2943,2317,571,907,908,1588,818,2967,998,1177,909) 
getParents (Datasource=, Time=15ms, Records=1159) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:58.058
    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=16ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:58.058
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 @ 02:15:58.058
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 679

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

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

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

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

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

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

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

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

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

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

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:59.059
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:59.059
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2994

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

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

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

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:59.059
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=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:59.059
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:59.059
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 729

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:59.059
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 02:15:59.059
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1099

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

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

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

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

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

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

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

getAdIDs (Datasource=graduateguide_prod, Time=15ms, Records=3) in D:\Websites\graduateguide_PROD\includes\pod3.cfm @ 02:15:59.059
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) = 7014

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=3, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 02:15:59.059
	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) = 7014

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:59.059
	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) = 209

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:59.059
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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) = 209

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:59.059
	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) = 204

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:59.059
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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) = 204

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:59.059
	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) = 95

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:59.059
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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) = 95

qryGetFooterLinks (Datasource=graduateguide_prod, Time=15ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 02:15:59.059
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:59.059
	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) = 140

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 02:15:59.059
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '08/27/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) = 140

updTracking (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 02:15:59.059
	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) = 8902190


Stored Procedures

sp_referTracking_USER_AGENT_insert (Datasource=graduateguide_prod, Time=15ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 02:15:57.057

    
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 @ 02:15:57.057
    
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=59
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=6226221
CFTOKEN=f4bc3364960660b9-EA677719-E8A4-3A49-A0256B9E4FDDC458
SESSION_UUID=%27%2A5W%2CUM%3F%27UP%20%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=Education
FIELDNAMES=NAME,MAJOR,STATE,PAGENUM,DISPLAYNAME
MAJOR=7014
NAME=
PAGENUM=1
STATE=none
Session Variables:
cfid=6226221
cftoken=f4bc3364960660b9-EA677719-E8A4-3A49-A0256B9E4FDDC458
entryid=8941285
session_uuid=8902190
sessionid=GARDUATEGUIDE_6226221_f4bc3364960660b9-EA677719-E8A4-3A49-A0256B9E4FDDC458
urltoken=CFID=6226221&CFTOKEN=f4bc3364960660b9-EA677719-E8A4-3A49-A0256B9E4FDDC458
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 47 ms