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

Social Work

Social Work Graduate ProgramsEarning a Master of Science in Social Work (MSW) can provide individuals with the knowledge that is required to make positive changes in other people's lives. Programs of this nature provide students with an understanding of the various factors that contribute to social dysfunction. In addition, they acquire the knowledge of the developmental and life skills that their future clients can use to better their lives. MSW degree holders assist people who struggle with poverty, homelessness, substance abuse and mental health problems. Graduates of this degree program can go on to assume roles as social workers, directors of nonprofit organizations and other professions related to helping people from vulnerable populations.

There are 292 Graduate Schools that Offer Social Work

1-28 of 292 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
 
University of Tennessee
College of Social Work
Knoxville, TN
University of Tennessee
College of Social Work
1618 Cumberland Avenue , 109 Henson Hall
Knoxville, TN
Phone865-974-3996
865-974-3351
 
Adelphi University
Garden City, NY
Adelphi University
One South Avenue, PO Box 701
Garden City, NY
ContactOffice of Graduate Admissions
Phone800-ADELPHI
516-877-3050
 
Alabama Agricultural and Mechanical University
School of Graduate Studies
Normal, AL
Alabama Agricultural and Mechanical University
School of Graduate Studies
4900 Meridian Street North, PO Box 998
Normal, AL
ContactOffice of Graduate Admissions
Phone256-372-5266
866-497-1689
 
Austin Peay State University
College of Graduate Studies
Clarksville, TN
Austin Peay State University
College of Graduate Studies
PO Box 4458,
Clarksville, TN
ContactOffice of Graduate Admissions
Phone931-221-7414
800-859-4723
 
Florida International University
Miami, FL
Florida International University
11200 S.W. 8th Street , PC 230, PO Box 659004
Miami, FL
ContactGraduate Admissions Office
Phone305-348-7442
 
Madonna University
Graduate School
Livonia, MI
Madonna University
Graduate School
36600 Schoolcraft Road,
Livonia, MI
Phone800-852-4951 5667
734-432-5667
 
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
 
Quinnipiac University
Hamden, CT
Quinnipiac University
275 Mount Carmel Avenue,
Hamden, CT
ContactGraduate Admissions NH-GRD
Phone800-462-1944
203-582-8672
 
University at Buffalo-SUNY
The Graduate School
Buffalo, NY
University at Buffalo-SUNY
The Graduate School
408 Capen Hall,
Buffalo, NY
Phone716-645-3482
 
State University of New York College at Brockport
Brockport, NY
State University of New York College at Brockport
350 New Campus Drive,
Brockport, NY
Phone585-395-2525
 
St. Cloud State University
School of Graduate Studies
Saint Cloud, MN
St. Cloud State University
School of Graduate Studies
720 Fourth Avenue South , 121 Administrative Services
Saint Cloud, MN
ContactOffice of Graduate Admissions
Phone320-308-2113
 
St. Cloud State University
School of Graduate Studies
Saint Cloud, MN
St. Cloud State University
School of Graduate Studies
720 Fourth Avenue South , 121 Administrative Services
Saint Cloud, MN
ContactOffice of Graduate Admissions
Phone320-308-2113
 
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
 
Stockton University
Graduate Studies
Galloway, NJ
Stockton University
Graduate Studies
101 Vera King Farris Drive,
Galloway, NJ
Phone609-626-3640
 
University of New England
Portland, ME
University of New England
716 Stevens Avenue,
Portland, ME
ContactOffice of Graduate and Professional Admissions
Phone207-221-4225
 
University of Pennsylvania
School of Social Policy & Practice
Philadelphia, PA
University of Pennsylvania
School of Social Policy & Practice
3701 Locust Walk,
Philadelphia, PA
ContactOffice of Graduate Admissions
Phone215-746-1934
 
The University of South Dakota
Vermillion, SD
The University of South Dakota
414 East Clark Street, McKusick Room 211
Vermillion, SD
Phone800-233-7937
605-677-6240
 
West Texas A&M University
Canyon, TX
West Texas A&M University
2501 4th Ave., Unit 60215, WT Box 60215
Canyon, TX
ContactOffice of Graduate Admissions
Phone806-651-2730
 
Westfield State University
Division of Graduate and Continuing Education
Westfield, MA
Westfield State University
Division of Graduate and Continuing Education
333 Western Avenue, PO Box 1630
Westfield, MA
ContactOffice of Graduate Admissions
Phone413-572-8020
 
GENERAL LISTINGS
Abilene Christian University
Abilene, TX
Abilene Christian University
1600 Campus Court, Box 29140
Abilene, TX
ContactOffice of Graduate Admissions
Phone855-822-3267
325-674-2354
 
Albany State University
Graduate Studies
Albany, GA
Albany State University
Graduate Studies
504 College Drive,
Albany, GA
Phone229-430-1354
 
Andrews University
Berrien Springs, MI
Andrews University
4150 Administration Dr,
Berrien Springs, MI
Phone269-471-6321
 
Appalachian State University
Cratis D. Williams School of Graduate Studies
Boone, NC
Appalachian State University
Cratis D. Williams School of Graduate Studies
287 Rivers Street, PO Box 32068
Boone, NC
ContactOffice of Graduate Admissions
Phone828-262-2130
 
Arizona State University
Graduate College
Tempe, AZ
Arizona State University
Graduate College
1151 S. Forest Ave. #SSV112, PO Box 871003
Tempe, AZ
ContactGraduate Admissions Services
Phone480-965-6113
 
Arkansas State University-Jonesboro
State University, AR
Arkansas State University-Jonesboro
PO Box 1570,
State University, AR
ContactGraduate Admissions
Phone870-972-2031
 
Asbury University
School of Graduate & Professional Studies
Wilmore, KY
Asbury University
School of Graduate & Professional Studies
One Macklem Drive,
Wilmore, KY
ContactOffice of Graduate Admissions
Phone859-858-2804
 

There were 292 schools found that offer Social Work


Debugging Information
ColdFusion Server Standard 10,0,13,287689
Template /results.cfm
Time Stamp 30-Mar-17 12:53 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
2594 ms 2594 ms 1 D:/Websites/graduateguide_PROD/results.cfm
1047 ms 1047 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
984 ms 984 ms 1 D:/Websites/graduateguide_PROD/header.cfm
812 ms 812 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
734 ms 82 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
547 ms 547 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
407 ms 407 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
62 ms 62 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = , session_UUID = ((%3/U]7/T<< , pagename = /results.cfm?, PageItemID = ) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
47 ms 47 ms 1 D:/Websites/graduateguide_PROD/includes/pod3.cfm
47 ms 47 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
46 ms 46 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
16 ms 2 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 4) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
16 ms 16 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 | referTracking_save_UA_reference(10, 10333164) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
15 ms 15 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_USER_AGENT_insert() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestEnd(/results.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestStart(/results.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 1) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 2) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | cfcookie(session_UUID, ((%3/U]7/T<< , ) ] 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/U]7/T<< ) ] 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, 10333164) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 D:/Websites/security/application.cfm
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2656 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 @ 00:53:31.031
	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 @ 00:53:31.031
	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=2, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 00:53:31.031
	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=10, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 00:53:31.031
	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 @ 00:53:31.031
	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 @ 00:53:31.031
		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 @ 00:53:31.031
		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 @ 00:53:31.031
    UPDATE referTracking_sessionID
    SET agent_ID = ?
    WHERE session_UUID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10
Parameter #2(cf_sql_integer) = 10333164

saveStart (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 00:53:31.031
            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) = 10333164

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

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:31.031
	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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:31.031
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '03/30/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) = 174

getSubnav (Datasource=graduateguide_prod, Time=15ms, Records=4) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:31.031
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=16ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:31.031
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 @ 00:53:31.031
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=0ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:31.031
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 @ 00:53:31.031
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=0ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:31.031
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=16ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 00:53:31.031
  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 @ 00:53:31.031
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=0ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 00:53:31.031
           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 @ 00:53:31.031
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=0ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 00:53:31.031
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 @ 00:53:31.031
	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 @ 00:53:32.032
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '03/30/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) = 200

qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:32.032
	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=47ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:32.032
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '03/30/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=32ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:32.032
	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=46ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:32.032
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '03/30/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

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

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

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

qryGetAd (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:32.032
	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=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:32.032
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '03/30/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=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:32.032
	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=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:32.032
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '03/30/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

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

getColleges (Datasource=graduateguide_prod, Time=156ms, Records=292) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:32.032
		select *, 'sponsor' as rank, 1 as show
		from parentChild_collegeMajor
		where web_ad = 'Y'
		and major = 7047
		union ALL
		select *, 'general' as rank, 1 as show
		from parentChild_collegeMajor
		where  web_ad <> 'Y'
		and major = 7047 
		order by rank desc, sort_uni, college_name asc, school_name
	
toRemove (Datasource=, Time=0ms, Records=292) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:32.032
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=16ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:32.032
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (3080,3008,679,1,1027,217,586,663,164,1619,1619,169,551,1238,2412,785,443,985,2261,2145,566,1951,255,572,819,1333,1296,2362,1593,314,35,211,1958,1778,1475,486,488,494,497,864,506,2147,914,44,2452,50,54,52,53,55,56,58,59,60,61,62,917,507,1203,1160,1131,868,1220,319,693,261,1427,872,701,1365,703,713,2894,719,193,323,830,1039,580,2188,932,2290,832,581,215,1217,221,726,199,1094,277,327,1530,583,311,529,202,84,730,332,382,2871,393,395,394,333,629,733,456,3033,662,279,941,1162,1163,737,339,92,1536,340,950,1164,1165,2537,2865,886,600,953,1616,634,1699,462,749,648,1818,1824,760,1502,1105,838,839,841,347,426,1477,2400,893,2825,894,1990,1680,1926,1107,669,1004,768,2428,608,1600,228,1688,546,466,115,118,120,778,291,674,967,2797,549,1285,358,359,1576,429,1458,2023,781,782,784,783,806,2025,969,1055,2029,2034,2010,808,10,1577,1060,2790,898,19,1291,1320,1321,171,133,134,137,233,362,899,172,1405,304,1415,2103,364,365,1462,1509,432,433,441,471,564,1061,619,1625,1627,1709,1722,1733,1758,1802,1850,1849,653,847,848,849,850,851,1771,1466,1886,1170,979,988,168,1633,1023,250,1178,414,444,639,366,1064,2056,2065,1172,2161,1085,2212,1173,252,1174,1175,1143,1144,1146,1147,1148,2232,308,1113,2224,1519,2225,1736,624,993,1125,856,434,625,1846,567,1522,996,1176,1026,907,815,1177,909) 
getParents (Datasource=, Time=0ms, Records=292) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:32.032
    select *
 	from getColleges
	where subcollege_id = 0
	and rank <> 'sponsor'
	union all
    select *
 	from getColleges
	where rank = 'sponsor'
	order by rank desc, sort_uni, college_name asc, school_name
getStateName (Datasource=graduateguide_prod, Time=16ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:32.032
SELECT StateName as state
FROM StateList
WHERE StateCode = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = none

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:33.033
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:33.033
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) = 255

getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:33.033
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) = 572

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:33.033
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) = 819

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

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

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:33.033
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) = 2362

getAdIDs (Datasource=graduateguide_prod, Time=47ms, Records=0) in D:\Websites\graduateguide_PROD\includes\pod3.cfm @ 00:53:33.033
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) = 7047

qryGetFooterLinks (Datasource=graduateguide_prod, Time=31ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 00:53:33.033
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:33.033
	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=344ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:34.034
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '03/30/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=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 00:53:34.034
	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) = 10333164


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_VARCHAR  ColdFusion    
    
resultsets
nameresultset
 result  1
dbo.main_navigation (Datasource=graduateguide_prod, Time=16ms) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:31.031
    
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=63
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=7671133
CFTOKEN=22a53b3b7c19eef4-278DDF54-FACA-2A86-E0DE78B4FEC4BBBE
SESSION_UUID=%28%28%253%2FU%5D7%2FT%3C%3C%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=Social_Work
FIELDNAMES=NAME,MAJOR,STATE,PAGENUM,DISPLAYNAME
MAJOR=7047
NAME=
PAGENUM=1
STATE=none
Session Variables:
cfid=7671133
cftoken=22a53b3b7c19eef4-278DDF54-FACA-2A86-E0DE78B4FEC4BBBE
entryid=10382512
session_uuid=10333164
sessionid=GARDUATEGUIDE_7671133_22a53b3b7c19eef4-278DDF54-FACA-2A86-E0DE78B4FEC4BBBE
urltoken=CFID=7671133&CFTOKEN=22a53b3b7c19eef4-278DDF54-FACA-2A86-E0DE78B4FEC4BBBE
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 31 ms