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

Psychology & Behavioral Sciences

Psychology Graduate ProgramsA degree in psychology & behavioral sciences at the graduate level explores the social, emotional and cognitive aspects of human behavior. Master's degrees within this major include, but are not limited to, psycholinguistics, counseling, and clinical, cognitive, developmental, child and experimental psychology. Depending on the degree, individuals in these programs may work in laboratory or research settings. Individuals holding a graduate degree in psychology can go on to assume careers as psychologists, counselors or educators with additional specializations. These programs typically take between one and three years to complete, though it depends on the nature of the degree.

There are 790 Graduate Schools that Offer Psychology & Behavioral Sciences

1-28 of 790 Results
SPONSORED LISTINGS
University of South Florida
Child and Adolescent Behavioral Health (MSCABH)
Tampa, FL
University of South Florida
Child and Adolescent Behavioral Health (MSCABH)
4202 E. Fowler Avenue, MHC 2334
Tampa, FL
Phone813-974-0342
 
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
 
Campbellsville University
Campbellsville, KY
Campbellsville University
1 University Drive, UPO 805
Campbellsville, KY
ContactOffice of Graduate Admissions
Phone800-264-6014
270-789-5221
 
Centenary University
Hackettstown, NJ
Centenary University
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
 
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
 
Hofstra University
Hempstead, NY
Hofstra University
126 Hofstra University, 105 Memorial Hall
Hempstead, NY
ContactOffice of Graduate Admissions
Phone1-866-GRADHOF
516-463-4723
 
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-2027
 
Madonna University
Graduate School
Livonia, MI
Madonna University
Graduate School
36600 Schoolcraft Road,
Livonia, MI
Phone800-852-4951 5667
734-432-5667
 
Mercyhurst University
College of Graduate Studies
Erie, PA
Mercyhurst University
College of Graduate Studies
501 East 38th Street,
Erie, PA
ContactOffice of Graduate Admissions
Phone814-824-3351
814-824-2297
 
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 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
 
Niagara University
Niagara University, NY
Niagara University
One Welcome Circle, Gacioch Family Alumni and Admissions Center
Niagara University, NY
ContactGraduate Studies Office
Phone800-462-2111
716-286-8327
 
Philadelphia College of Osteopathic Medicine
Philadelphia, PA
Philadelphia College of Osteopathic Medicine
4170 City Avenue,
Philadelphia, PA
ContactOffice of Admissions
Phone215-871-6700
800-999-6998
 
Pontifical John Paul II Institute for Studies on Marriage and Family
Washington, DC
Pontifical John Paul II Institute for Studies on Marriage and Family
620 Michigan Ave. NE, McGivney hall
Washington, DC
Phone202-526-3799
 
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
 
Regent University
Virginia Beach, VA
Regent University
1000 Regent University Drive,
Virginia Beach, VA
Phone800.373.5504
757.352.4127
 
Roger Williams University
Graduate Programs
Bristol, RI
Roger Williams University
Graduate Programs
One Old Ferry Road,
Bristol, RI
ContactOffice of Graduate Admission
Phone888-674-8479 6200
401-254-6200
 
University at Buffalo-SUNY
The Graduate School
Buffalo, NY
University at Buffalo-SUNY
The Graduate School
408 Capen Hall,
Buffalo, NY
Phone716-645-3482
 
Sacred Heart University
Fairfield, CT
Sacred Heart University
5151 Park Avenue,
Fairfield, CT
ContactWilliam Sweeney
Phone203-365-7619
 
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. John's University
Queens, NY
St. John's University
8000 Utopia Parkway,
Queens, NY
ContactOffice of Graduate Admissions
Phone718-990-1601
 
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
 
Springfield College
Springfield, MA
Springfield College
263 Alden St.,
Springfield, MA
ContactOffice of Graduate Admissions
Phone413-748-3225
 

There were 790 schools found that offer Psychology & Behavioral Sciences

SPONSORED PROGRAMS


Debugging Information
ColdFusion Server Standard 10,0,13,287689
Template /results.cfm
Time Stamp 29-May-17 11:40 PM
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
2391 ms 2391 ms 1 D:/Websites/graduateguide_PROD/results.cfm
1063 ms 1063 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
890 ms 890 ms 1 D:/Websites/graduateguide_PROD/header.cfm
718 ms 718 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
640 ms 80 ms 8 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
422 ms 422 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
328 ms 82 ms 4 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(major = 7043, pos = 6) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
328 ms 328 ms 1 D:/Websites/graduateguide_PROD/includes/pod3.cfm
328 ms 328 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
94 ms 94 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
94 ms 94 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
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
31 ms 31 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/AdRotationCFC.cfc | getCurrAdID(POS = 2) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
15 ms 15 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | referTracking_save_UA_reference(10, 10751879) ] 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 8 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 4) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 4 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrMajorAdID(MAJ = 7043) ] 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, ((%3+T=?&T,H , ) ] 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, ((%3+T=?&T,H ) ] 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, 10751879) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = , session_UUID = ((%3+T=?&T,H , pagename = /results.cfm?, PageItemID = ) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
0 ms 0 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 D:/Websites/security/application.cfm
31 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2453 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=7, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 23:40:54.054
	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=1, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 23:40:54.054
	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=1, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 23:40:54.054
	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=8, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 23:40:54.054
	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 @ 23:40:54.054
	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 @ 23:40:54.054
		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 @ 23:40:54.054
		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=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 23:40:54.054
    UPDATE referTracking_sessionID
    SET agent_ID = ?
    WHERE session_UUID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10
Parameter #2(cf_sql_integer) = 10751879

saveStart (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 23:40:54.054
            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) = 10751879

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

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:54.054
	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) = 137

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:54.054
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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) = 137

getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=4) in D:\Websites\graduateguide_PROD\navigation.cfm @ 23:40:54.054
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=0ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 23:40:54.054
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 @ 23:40:54.054
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=15ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 23:40:54.054
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 @ 23:40:54.054
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 @ 23:40:54.054
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=0ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 23:40:54.054
  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=31ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 23:40:54.054
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=15ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 23:40:54.054
           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=16ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 23:40:54.054
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=16ms, Records=8) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 23:40:54.054
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 @ 23:40:54.054
	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 @ 23:40:55.055
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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 @ 23:40:55.055
	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=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:55.055
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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 @ 23:40:55.055
	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) = 218

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:55.055
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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) = 218

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:55.055
	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 @ 23:40:55.055
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:55.055
	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 @ 23:40:55.055
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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 @ 23:40:55.055
	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 @ 23:40:55.055
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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 @ 23:40:55.055
	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=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:55.055
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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 @ 23:40:55.055
	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 @ 23:40:55.055
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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

getmajor (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:55.055
		select *
		from majors
		where major_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7043

getColleges (Datasource=graduateguide_prod, Time=313ms, Records=790) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:55.055
		select *, 'sponsor' as rank, 1 as show
		from parentChild_collegeMajor
		where web_ad = 'Y'
		and major = 7043
		union ALL
		select *, 'general' as rank, 1 as show
		from parentChild_collegeMajor
		where  web_ad <> 'Y'
		and major = 7043 
		order by rank desc, sort_uni, college_name asc, school_name
	
toRemove (Datasource=, Time=0ms, Records=790) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:55.055
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=31ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:55.055
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (3080,679,2279,655,577,2439,659,2518,729,1099,948,586,952,663,424,96,761,959,2985,766,1108,2322,167,1619,774,169,551,2412,562,975,2261,991,566,537,1951,1355,1591,312,1290,627,684,47,1128,1953,477,197,2291,572,1954,479,32,641,2531,2180,819,911,274,330,2286,2463,310,2460,2951,2454,2285,27,2939,2461,31,249,331,219,626,1088,1333,1296,1303,2457,481,2434,3,4,2949,1027,1644,35,574,372,211,688,1958,1778,316,374,1599,37,486,1227,488,2540,446,864,317,503,260,506,2147,1159,689,999,915,1275,48,39,654,40,2574,44,46,2861,49,50,51,52,53,55,56,58,59,60,61,62,917,2359,507,1851,1203,1129,1160,212,918,919,1035,868,1220,2344,158,1645,2182,1412,64,920,921,318,319,1010,692,693,2183,67,508,2698,1011,872,656,699,657,700,1076,701,1091,1357,1365,1013,703,807,1898,1161,321,1132,159,1014,449,2638,715,1969,642,1268,628,322,1786,74,928,822,830,1852,1039,2978,325,420,1092,580,511,931,1093,2188,1133,932,1223,264,1484,2290,1660,161,832,660,75,1040,515,214,215,216,217,221,726,1490,271,516,1015,875,1041,77,1491,450,78,199,833,934,1901,1094,2402,2405,201,273,275,277,661,1077,79,2190,327,378,1790,936,1095,1971,1308,520,526,311,2617,878,1313,2301,937,82,452,83,1977,202,84,730,379,436,1476,329,332,938,381,382,393,939,394,398,2756,2828,731,1445,7,1098,1316,88,734,456,453,1001,1078,1042,2393,1492,662,2571,880,941,943,89,280,1162,1134,1979,1271,1853,1043,946,835,530,1985,1903,339,2692,1672,423,1045,92,738,1452,1536,1554,1555,2502,93,340,460,1556,1986,1101,224,1453,739,1135,883,744,1136,1119,402,3069,1104,950,476,1164,2436,1165,1563,1244,285,745,2738,2847,1611,886,576,600,2629,1501,1049,1987,341,1342,953,1616,1617,1765,631,632,1699,2965,2664,746,1748,1747,664,664,837,2331,1139,2874,2640,425,1378,344,97,955,648,2740,665,1818,1824,2609,2849,758,760,764,1564,1105,838,839,841,1766,346,2341,1854,544,1344,349,426,604,1907,1679,1477,2633,1859,1567,350,71,225,2400,606,893,894,2936,1862,1869,1106,351,2645,1911,1503,1990,762,2194,105,1923,1210,226,104,957,1037,109,842,110,1505,961,1926,2673,1993,1346,668,404,405,1167,1107,545,1382,1004,1998,2277,651,768,769,227,354,326,963,671,2428,771,608,772,2020,2822,965,776,1688,2197,2022,1083,229,356,546,1007,115,118,120,121,122,2198,2203,674,966,1109,967,609,2797,124,2258,2254,86,125,1020,2260,2274,1692,1570,1874,1285,358,359,2005,1878,1935,1575,2018,2019,1832,1879,429,610,130,2023,1704,231,552,1267,781,782,784,785,783,797,791,2398,792,793,794,806,2025,969,1055,1056,2026,2027,3065,2029,2030,2031,2032,2034,2040,2010,2045,2053,1221,808,3073,467,1168,1058,206,3027,232,361,10,12,1706,554,1577,468,431,897,2382,2790,898,19,20,21,1291,1293,1349,1320,1321,1324,469,133,134,136,136,137,2811,138,139,141,142,1325,233,1646,1884,362,899,1385,1392,1399,172,419,2102,900,195,1405,614,234,299,297,1764,1169,176,2613,1415,1569,2103,2114,2118,1478,363,364,365,411,1462,2885,1509,432,144,1579,1580,433,441,1767,2122,472,470,560,561,564,1061,236,621,1627,636,1709,1722,1733,22,1758,1803,1797,1802,1850,1849,653,177,1834,1581,847,848,849,850,851,1771,248,287,2126,1408,1466,412,1886,1936,1170,145,977,973,979,1289,988,1008,811,413,168,2579,1633,147,148,989,990,25,1023,1024,250,1178,639,1064,1063,2056,2065,2077,2084,2085,2086,2096,2073,207,2582,1811,2429,903,1172,1893,1085,1112,1173,252,294,1174,1175,1143,1145,1146,1147,1148,1151,1153,1154,1155,2232,904,308,415,1072,151,1113,1115,1114,1156,852,1637,2224,905,1519,2310,2225,1736,624,992,993,2145,1125,856,179,368,434,625,565,1846,2521,2650,2229,369,1522,996,1176,640,678,196,1026,1157,156,907,908,1588,180,816,1177,909) 
getParents (Datasource=, Time=0ms, Records=790) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:55.055
    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=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:55.055
SELECT StateName as state
FROM StateList
WHERE StateCode = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = none

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

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

getContact (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:56.056
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=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:56.056
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=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:40:56.056
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

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

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

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

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

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

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

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

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

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=4) in D:\Websites\graduateguide_PROD\includes\pod3.cfm @ 23:40:56.056
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) = 7043

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=4, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 23:40:56.056
	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) = 7043

qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	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) = 48

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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) = 48

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	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) = 220

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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) = 220

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	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) = 125

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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) = 125

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	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) = 217

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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) = 217

qryGetFooterLinks (Datasource=graduateguide_prod, Time=0ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 23:40:56.056
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:56.056
	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=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:40:57.057
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	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 @ 23:40:57.057
	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) = 10751879


Stored Procedures

sp_referTracking_USER_AGENT_insert (Datasource=graduateguide_prod, Time=0ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 23:40:54.054

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_VARCHAR  ColdFusion    
    
resultsets
nameresultset
 result  1
dbo.main_navigation (Datasource=graduateguide_prod, Time=15ms) in D:\Websites\graduateguide_PROD\navigation.cfm @ 23:40:54.054
    
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=84
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=8093702
CFTOKEN=18583f324f0488f1-6A65DC0F-E8D1-AE2E-ADE393F5F4BFC0E7
SESSION_UUID=%28%28%253%2BT%3D%3F%26T%2CH%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=Psychology_Behavioral_Sciences
FIELDNAMES=NAME,MAJOR,STATE,PAGENUM,DISPLAYNAME
MAJOR=7043
NAME=
PAGENUM=1
STATE=none
Session Variables:
cfid=8093702
cftoken=18583f324f0488f1-6A65DC0F-E8D1-AE2E-ADE393F5F4BFC0E7
entryid=10803911
session_uuid=10751879
sessionid=GARDUATEGUIDE_8093702_18583f324f0488f1-6A65DC0F-E8D1-AE2E-ADE393F5F4BFC0E7
urltoken=CFID=8093702&CFTOKEN=18583f324f0488f1-6A65DC0F-E8D1-AE2E-ADE393F5F4BFC0E7
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 16 ms