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

Gerontology The field of gerontology is the study of the various aspects of aging. Those who wish to assume leadership roles in this field can earn a Master’s of Science in Gerontology. Courses may focus on the psychological and sociological aspects of aging, as well as topics such as public policy and nutrition. After completion of a program in gerontology, graduates can create, implement and deliver initiatives and services to older populations or assume research roles.

There are 109 Graduate Schools that Offer Gerontology

1-28 of 109 Results
SPONSORED LISTINGS
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
 
Hofstra University
Hempstead, NY
Hofstra University
126 Hofstra University, 105 Memorial Hall
Hempstead, NY
ContactOffice of Graduate Admissions
Phone1-866-GRADHOF
516-463-4723
 
University at Buffalo-SUNY
The Graduate School
Buffalo, NY
University at Buffalo-SUNY
The Graduate School
408 Capen Hall,
Buffalo, NY
Phone716-645-3482
 
St. Cloud State University
School of Graduate Studies
Saint Cloud, MN
St. Cloud State University
School of Graduate Studies
720 Fourth Avenue South , 121 Administrative Services
Saint Cloud, MN
ContactOffice of Graduate Admissions
Phone320-308-2113
 
St. Cloud State University
School of Graduate Studies
Saint Cloud, MN
St. Cloud State University
School of Graduate Studies
720 Fourth Avenue South , 121 Administrative Services
Saint Cloud, MN
ContactOffice of Graduate Admissions
Phone320-308-2113
 
GENERAL LISTINGS
Abilene Christian University
Abilene, TX
Abilene Christian University
Box 29140,
Abilene, TX
ContactOffice of Graduate Admissions
Phone800-460-6228
325-674-2354
 
Arkansas Tech University
Graduate College
Russellville, AR
Arkansas Tech University
Graduate College
1507 North Boulder Ave, Tomlinson 113
Russellville, AR
Phone479-968-0398
 
Ball State University
Muncie, IN
Ball State University
2000 W University,
Muncie, IN
ContactOffice of Graduate Admissions
Phone866-285-4723
317-285-1297
 
Bethel University
Graduate School
Saint Paul, MN
Bethel University
Graduate School
3900 Bethel Drive,
Saint Paul, MN
ContactDean of the Graduate School
Phone800-255-8706 8000
651-635-8000
 
Boston College
Chestnut Hill, MA
Boston College
140 Commonwealth Avenue,
Chestnut Hill, MA
ContactOffice of Graduate Admissions
Phone617-552-8000
 
Bowling Green State University
Bowling Green, OH
Bowling Green State University
120 McFall Center,
Bowling Green, OH
ContactOffice of Graduate Admissions
Phone419-372-2791
 
Brandeis University
The Heller School for Social Policy and Management
Waltham, MA
Brandeis University
The Heller School for Social Policy and Management
415 South Street, MS 035
Waltham, MA
ContactAdmissions Office
Phone781-736-3820
 
Brenau University
Sidney O. Smith Graduate School
Gainesville, GA
Brenau University
Sidney O. Smith Graduate School
500 Washington Street SE,
Gainesville, GA
ContactOffice of Graduate Admissions
Phone800-252-5119 5337
770-718-5337
 
Brooklyn College
The City University of New York
Brooklyn, NY
Brooklyn College
The City University of New York
2900 Bedford Avenue,
Brooklyn, NY
ContactOffice of Graduate Admissions
Phone718-951-4536
 
California State University, Dominguez Hills
Graduate Studies
Carson, CA
California State University, Dominguez Hills
Graduate Studies
1000 E. Victoria Street, Welch Hall, Room D-440
Carson, CA
ContactOffice of Graduate Admissions
Phone310-243-3693
 
California State University, Fullerton
Fullerton, CA
California State University, Fullerton
800 N State College Blvd., McCarthy Hall 112
Fullerton, CA
ContactGraduate Studies Office
Phone657-278-2618
 
California State University, Long Beach
Long Beach, CA
California State University, Long Beach
1250 Bellflower Blvd.,
Long Beach, CA
ContactOffice of Graduate Admissions
Phone562-985-8225
 
Capella University
Minneapolis, MN
Capella University
225 South 6th Street, 9th floor,
Minneapolis, MN
Phone855-634-2620
612-339-8650
 
Clemson University
Graduate School
Clemson, SC
Clemson University
Graduate School
E-209 Martin Hall,
Clemson, SC
ContactOffice of Graduate Admissions
Phone864-656-3195
 
The College of New Rochelle
Graduate School
New Rochelle, NY
The College of New Rochelle
Graduate School
29 Castle Place, 4 Hemlock
New Rochelle, NY
ContactGraduate Admissions
Phone800-933-5923
914-654-5309
 
Columbia University
Graduate School of Arts & Sciences
New York, NY
Columbia University
Graduate School of Arts & Sciences
535 W. 116th St., MC 4304, 107 Low Library
New York, NY
ContactOffice of Graduate Admissions
Phone212-854-6729
212-854-8903
 
Concordia University
Graduate School
Lincoln, NE
Concordia University
Graduate School
570 Fallbrook Boulevard, Suite 203
Lincoln, NE
Phone888-505-2863
402-327-6501
 
Concordia University Chicago
River Forest, IL
Concordia University Chicago
7400 Augusta Street,
River Forest, IL
ContactOffice of Graduate Admission
Phone708-209-4093
 
Concordia University Wisconsin
Graduate School
Mequon, WI
Concordia University Wisconsin
Graduate School
12800 North Lake Shore Drive,
Mequon, WI
ContactOffice of Graduate Admission
Phone800-330-9866
262-243-4248
 
Dominican University
River Forest, IL
Dominican University
7900 West Division St.,
River Forest, IL
ContactEnrollment Management - Graduate Admissions
Phone708-524-6829
 
East Carolina University
Graduate School
Greenville, NC
East Carolina University
Graduate School
131 Ragsdale Hall,
Greenville, NC
ContactOffice of Graduate Admissions
Phone252-328-6012
 
East Tennessee State University
School of Graduate Studies
Johnson City, TN
East Tennessee State University
School of Graduate Studies
309 Burgin E. Dossett Hall, PO Box 70720
Johnson City, TN
Phone423-439-4221
 
Eastern Illinois University
Graduate School
Charleston, IL
Eastern Illinois University
Graduate School
600 Lincoln Ave,
Charleston, IL
Phone217-581-2220
 

There were 109 schools found that offer Gerontology


Debugging Information
ColdFusion Server Standard 10,0,13,287689
Template /results.cfm
Time Stamp 25-Jun-16 06:58 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
8047 ms 8047 ms 1 D:/Websites/graduateguide_PROD/results.cfm
5218 ms 5218 ms 1 D:/Websites/graduateguide_PROD/header.cfm
4609 ms 4609 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
4422 ms 491 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
2391 ms 2391 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
422 ms 422 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
421 ms 421 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
360 ms 360 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
360 ms 360 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | INIT_tracking() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
188 ms 188 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
109 ms 109 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
46 ms 46 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_USER_AGENT_insert() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
32 ms 32 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | referTracking_save_UA_reference(10, 8286671) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
31 ms 31 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = , session_UUID = '*5;$TM#)U@ , pagename = /results.cfm?, PageItemID = ) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
16 ms 16 ms 1 D:/Websites/graduateguide_PROD/includes/pod3.cfm
16 ms 16 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestEnd(/results.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestStart(/results.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 1) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 2) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 4) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | cfcookie(session_UUID, '*5;$TM#)U@ , ) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | cfcookie(show_debug, Yes) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 2 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | de_crypt(stretchtite, '*5;$TM#)U@ ) ] 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, 8286671) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 D:/Websites/security/application.cfm
360 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
8516 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=5, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 18:58:34.034
	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 @ 18:58:34.034
	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=3, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 18:58:34.034
	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=328ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 18:58:34.034
		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=32ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 18:58:34.034
		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=32ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 18:58:34.034
    UPDATE referTracking_sessionID
    SET agent_ID = ?
    WHERE session_UUID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10
Parameter #2(cf_sql_integer) = 8286671

saveStart (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 18:58:34.034
            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) = 8286671

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

qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:34.034
	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) = 174

trackAd_viewing (Datasource=graduateguide_prod, Time=390ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:34.034
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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) = 174

getSubnav (Datasource=graduateguide_prod, Time=31ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 18:58:35.035
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=31ms, Records=11) in D:\Websites\graduateguide_PROD\navigation.cfm @ 18:58:35.035
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 @ 18:58:35.035
SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
ORDER BY sortOrder
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4

getSubnav (Datasource=graduateguide_prod, Time=31ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 18:58:35.035
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=31ms, Records=2) in D:\Websites\graduateguide_PROD\navigation.cfm @ 18:58:35.035
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 @ 18:58:35.035
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=78ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 18:58:35.035
  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=47ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 18:58:35.035
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=16ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 18:58:35.035
           SELECT DISTINCT majors.major_id, majors.major as major_name 
           FROM college_majors INNER JOIN majors ON college_majors.major_id =majors.major_id 
           WHERE (college_majors.online = 1) ORDER BY majors.major
           
getMajors2 (Datasource=graduateguide_prod, Time=31ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 18:58:35.035
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=15ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 18:58:35.035
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 @ 18:58:35.035
	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=375ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:35.035
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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 @ 18:58:35.035
	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=343ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:36.036
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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 @ 18:58:36.036
	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=406ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:36.036
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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 @ 18:58:36.036
	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=422ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:37.037
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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 @ 18:58:37.037
	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=484ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:37.037
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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 @ 18:58:37.037
	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=515ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:38.038
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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 @ 18:58:38.038
	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=391ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:38.038
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 169

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:38.038
	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=484ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:38.038
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10

qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:39.039
	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=781ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:39.039
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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

getmajor (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:39.039
		select *
		from majors
		where major_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7021

getColleges (Datasource=graduateguide_prod, Time=296ms, Records=109) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
		select *, 'sponsor' as rank, 1 as show
		from parentChild_collegeMajor
		where web_ad = 'Y'
		and major = 7021
		union ALL
		select *, 'general' as rank, 1 as show
		from parentChild_collegeMajor
		where  web_ad <> 'Y'
		and major = 7021 
		order by rank desc, sort_uni, college_name asc, school_name
	
toRemove (Datasource=, Time=0ms, Records=109) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (701,729,1619,1619,2412,1951,1303,372,1599,486,864,505,260,689,51,53,55,1203,1011,699,703,1781,321,1132,323,830,1039,325,580,1094,277,936,452,332,1445,1492,1162,2426,1672,92,738,1905,476,886,1616,97,758,760,1766,347,71,225,893,1869,1910,1911,404,545,771,965,115,118,782,2045,1577,898,20,1349,1321,1646,1884,362,234,1415,411,1509,432,144,1580,433,471,472,561,564,1733,1803,1802,1581,848,849,851,2126,1408,168,147,25,250,1178,639,1172,1173,415,1113,624,1742,993,1125,1522,997) 
getParents (Datasource=, Time=0ms, Records=109) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
    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=32ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
SELECT StateName as state
FROM StateList
WHERE StateCode = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = none

getContact (Datasource=graduateguide_prod, Time=156ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
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=109ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
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=63ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
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=94ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
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=78ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
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=78ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 18:58:40.040
select email, phone, ext, phone2, ext2, address, add2, contact, search_popup_text
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1951

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

getAdIDs (Datasource=graduateguide_prod, Time=16ms, Records=0) in D:\Websites\graduateguide_PROD\includes\pod3.cfm @ 18:58:42.042
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) = 7021

qryGetFooterLinks (Datasource=graduateguide_prod, Time=0ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 18:58:42.042
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:42.042
	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) = 187

trackAd_viewing (Datasource=graduateguide_prod, Time=329ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 18:58:42.042
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '06/25/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) = 187

updTracking (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 18:58:42.042
	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) = 8286671


Stored Procedures

sp_referTracking_USER_AGENT_insert (Datasource=graduateguide_prod, Time=46ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 18:58:34.034

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_VARCHAR  ColdFusion    
    
resultsets
nameresultset
 result  1
dbo.main_navigation (Datasource=graduateguide_prod, Time=32ms) in D:\Websites\graduateguide_PROD\navigation.cfm @ 18:58:35.035
    
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=61
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=5607241
CFTOKEN=6d1529a4127f1f33-61D30312-F9D2-C8CE-100FEA262592F08B
SESSION_UUID=%27%2A5%3B%24TM%23%29U%40%20%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=Gerontology
FIELDNAMES=NAME,MAJOR,STATE,PAGENUM,DISPLAYNAME
MAJOR=7021
NAME=
PAGENUM=1
STATE=none
Session Variables:
cfid=5607241
cftoken=6d1529a4127f1f33-61D30312-F9D2-C8CE-100FEA262592F08B
entryid=8322477
session_uuid=8286671
sessionid=GARDUATEGUIDE_5607241_6d1529a4127f1f33-61D30312-F9D2-C8CE-100FEA262592F08B
urltoken=CFID=5607241&CFTOKEN=6d1529a4127f1f33-61D30312-F9D2-C8CE-100FEA262592F08B
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 31 ms