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-829-5900
 
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, MSC 2371
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
Phone888-365-9550
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 01-Oct-16 03:06 AM
Locale English (US)
User Agent ColdFusion
Remote IP 108.54.112.66
Host Name 108.54.112.66


Execution Time

Total Time Avg Time Count Template
2875 ms 2875 ms 1 D:/Websites/graduateguide_PROD/results.cfm
1828 ms 1828 ms 1 D:/Websites/graduateguide_PROD/header.cfm
1359 ms 1359 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
1218 ms 135 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
891 ms 891 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
313 ms 313 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
156 ms 156 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
125 ms 125 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
93 ms 93 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
63 ms 63 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
31 ms 31 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | INIT_tracking() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = , session_UUID = '*%7)U][&TP , pagename = /results.cfm?, PageItemID = ) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | referTracking_save_UA_reference(10, 9153884) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_USER_AGENT_insert() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
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, '*%7)U][&TP , ) ] 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, '*%7)U][&TP ) ] 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, 9153884) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 D:/Websites/security/application.cfm
46 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2984 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=2, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:06:18.018
	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=3, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:06:18.018
	SELECT adID FROM active_data_ad_list_vw
	WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=9, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 03:06:18.018
	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 @ 03:06:18.018
	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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 03:06:18.018
		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=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 03:06:18.018
		INSERT INTO referTracking_SessionID(ipaddress, site_ID)
		VALUES(
			?,
			?
			);
		
		SELECT SCOPE_IDENTITY() AS session_UUID;
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 108.54.112.66
Parameter #2(CF_SQL_INTEGER) = 2

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

saveStart (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 03:06:18.018
            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) = 9153884

qryH_Major (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results.cfm @ 03:06:18.018
    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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:18.018
	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) = 193

trackAd_viewing (Datasource=graduateguide_prod, Time=282ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:19.019
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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) = 193

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

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

getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 03:06:19.019
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 @ 03:06:19.019
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 @ 03:06:19.019
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=47ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:06:19.019
  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 @ 03:06:19.019
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=16ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:06:19.019
           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=0ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:06:19.019
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=32ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 03:06:19.019
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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:19.019
	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=140ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:19.019
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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 @ 03:06:19.019
	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=329ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:19.019
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/2016';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 16

qryGetAd (Datasource=graduateguide_prod, Time=171ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	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=94ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 200

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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 @ 03:06:20.020
	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=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	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 @ 03:06:20.020
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	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 @ 03:06:20.020
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:20.020
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 139

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

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

getColleges (Datasource=graduateguide_prod, Time=94ms, Records=109) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
		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 @ 03:06:20.020
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
		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 @ 03:06:20.020
    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=15ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
SELECT StateName as state
FROM StateList
WHERE StateCode = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = none

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

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
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=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
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=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
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=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:20.020
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 03:06:21.021
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 @ 03:06:21.021
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 @ 03:06:21.021
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:21.021
	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) = 194

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 03:06:21.021
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '10/01/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) = 194

updTracking (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 03:06:21.021
	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) = 9153884


Stored Procedures

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

    
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 @ 03:06:19.019
    
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=6480753
CFTOKEN=e8fc66c8e30ae21c-F69EF6E0-9914-35BE-45604ADC5417D249
SESSION_UUID=%27%2A%257%29U%5D%5B%26TP%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=6480753
cftoken=e8fc66c8e30ae21c-F69EF6E0-9914-35BE-45604ADC5417D249
entryid=9194480
session_uuid=9153884
sessionid=GARDUATEGUIDE_6480753_e8fc66c8e30ae21c-F69EF6E0-9914-35BE-45604ADC5417D249
urltoken=CFID=6480753&CFTOKEN=e8fc66c8e30ae21c-F69EF6E0-9914-35BE-45604ADC5417D249
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 31 ms