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

1-28 of 62 Results
SPONSORED LISTINGS
Northwestern University School of Professional Studies
Sports Administration
Chicago, IL
Northwestern University School of Professional Studies
Sports Administration
339 East Chicago Avenue, Wieboldt Hall, Sixth Floor
Chicago, IL
Phone312-503-2579
 
National University of Health Sciences
Lombard, IL
National University of Health Sciences
200 East Roosevelt Road,
Lombard, IL
ContactVictoria Sweeney, Director of Communications and Enrollment Services
Phone800-826-6285
 
Robert Morris University - Illinois
Morris Graduate School of Management
Chicago, IL
Robert Morris University - Illinois
Morris Graduate School of Management
401 South State Street,
Chicago, IL
Phone877-461-5104
 
GENERAL LISTINGS
Adler University
Chicago Campus
Chicago, IL
Adler University
Chicago Campus
17 N. Dearborn Street,
Chicago, IL
ContactMichelle Brice, Director of Admissions
Phone312-662-4100
 
Argosy University - Chicago
Chicago, IL
Argosy University - Chicago
225 North Michigan Avenue, Suite 1300
Chicago, IL
Phone800-626-4123
312-777-7600
 
Argosy University - Schaumburg
Schaumburg, IL
Argosy University - Schaumburg
1000 North Plaza Drive, Suite 324
Schaumburg, IL
Phone847-969-4900
866-290-2777
 
Aurora University
Aurora, IL
Aurora University
347 South Gladstone Avenue,
Aurora, IL
ContactCenter for Adult and Graduate Studies
Phone800-742-5281
630-844-5294
 
Benedictine University
Lisle, IL
Benedictine University
5700 College Road,
Lisle, IL
ContactEnrollment Center
Phone630-829-6300
630-829-6311
 
Calumet College of Saint Joseph
Whiting, IN
Calumet College of Saint Joseph
2400 New York Avenue,
Whiting, IN
Phone877-700-9100 215
219-473-4215
 
Chamberlain College of Nursing
Downers Grove, IL
Chamberlain College of Nursing
3005 Highland Parkway,
Downers Grove, IL
Phone877-751-5783
 
The Chicago School of Professional Psychology
Chicago, IL
The Chicago School of Professional Psychology
350 N Orleans, Suite 1050
Chicago, IL
ContactAdmission Operations
Phone800-721-8072
 
Chicago State University
School of Graduate and Professional Studies
Chicago, IL
Chicago State University
School of Graduate and Professional Studies
9501 South King Drive, Cook Administration, Room 200
Chicago, IL
ContactOffice of Graduate Admissions
Phone773-995-2404
 
Chicago Theological Seminary
Chicago, IL
Chicago Theological Seminary
1407 E. 60th St.,
Chicago, IL
Phone773-896-2410
 
Columbia College Chicago
Chicago, IL
Columbia College Chicago
600 South Michigan Avenue, Suite 200
Chicago, IL
ContactSchool of Graduate Studies
Phone312-369-7670
 
Concordia University Chicago
River Forest, IL
Concordia University Chicago
7400 Augusta Street,
River Forest, IL
ContactOffice of Graduate Admission
Phone708-209-4093
 
DePaul University
Chicago, IL
DePaul University
1 East Jackson Blvd.,
Chicago, IL
ContactOffice of Graduate Admissions
Phone800-4DEPAUL
312-362-8648
 
Dominican University
River Forest, IL
Dominican University
7900 West Division St.,
River Forest, IL
ContactEnrollment Management - Graduate Recruitment
Phone708-524-6829
 
Ellis University
Oakbrook Terrace, IL
Ellis University
2 Mid America Plaza, #824AB
Oakbrook Terrace, IL
ContactGraduate Programs
Phone877-366-0321
 
Elmhurst College
School for Professional Studies
Elmhurst, IL
Elmhurst College
School for Professional Studies
190 Prospect Avenue,
Elmhurst, IL
ContactOffice of Graduate Admissions
Phone630-617-3300
800-581-4723
 
Erikson Institute
Graduate School
Chicago, IL
Erikson Institute
Graduate School
451 North LaSalle Street,
Chicago, IL
ContactOffice of Admission
Phone312-755-2250
 
Garrett-Evangelical Theological Seminary
Evanston, IL
Garrett-Evangelical Theological Seminary
2121 Sheridan Road,
Evanston, IL
Phone800-736-4627
847-866-3945
 
Illinois College of Optometry
Chicago, IL
Illinois College of Optometry
3241 South Michigan Avenue,
Chicago, IL
ContactOffice of Graduate Admissions
Phone800-397-2424
312-949-7400
 
Illinois Institute of Technology
Chicago, IL
Illinois Institute of Technology
10 W. 33rd Street, Perlstein Hall, Room 203
Chicago, IL
ContactOffice of Graduate Admission
Phone866-472-3448
312-567-3020
 
Indiana University Northwest
Gary, IN
Indiana University Northwest
3400 Broadway, Hawthorn Hall, Room 100
Gary, IN
ContactOffice of Graduate Admissions
Phone888-968-7486
219-980-6991
 
Institute for Clinical Social Work
Chicago, IL
Institute for Clinical Social Work
401 South State Street, Suite 822
Chicago, IL
ContactOffice of Graduate Admissions
Phone312-935-4232
 
The John Marshall Law School
Chicago, IL
The John Marshall Law School
315 South Plymouth Court,
Chicago, IL
ContactOffice of Graduate Admissions
Phone800-276-0003
312-427-2737
 
Judson University
Elgin, IL
Judson University
1151 N. State Street,
Elgin, IL
ContactOffice of Graduate Admissions
Phone847-628-2500
 
Keller Graduate School of Management of DeVry University
Naperville, IL
Keller Graduate School of Management of DeVry University
1200 E. Diehl Rd.,
Naperville, IL
ContactOffice of Graduate Admissions
Phone888-653-5537
 


SPONSORED GRADUATE SCHOOLS

Lock Haven University
Nationally ranked PA Program at four campus locations plus 100% online, Master's programs in Mental Health Counseling, Sport Administration, and Education.
www.lhup.edu/graduate
Queens College
Queens College offers more than 100 master's degrees and advanced certificates in the liberal arts, sciences, social sciences, and teacher education.
www.qc.cuny.edu


Debugging Information
ColdFusion Server Standard 10,0,13,287689
Template /results.cfm
Time Stamp 27-Feb-17 07:54 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
3359 ms 3359 ms 1 D:/Websites/graduateguide_PROD/results.cfm
2172 ms 2172 ms 1 D:/Websites/graduateguide_PROD/header.cfm
1922 ms 1922 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
1813 ms 201 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
906 ms 906 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
281 ms 281 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
172 ms 172 ms 1 D:/Websites/graduateguide_PROD/includes/pod2.cfm
172 ms 172 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
157 ms 79 ms 2 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(3) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
125 ms 125 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
109 ms 109 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
78 ms 78 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
47 ms 47 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
31 ms 31 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | INIT_tracking() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = , session_UUID = ((%3-U=7-U<( , 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, 10113321) ] 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 2 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 3) ] 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, ((%3-U=7-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, ((%3-U=7-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, 10113321) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 D:/Websites/graduateguide_PROD/includes/pod1.cfm
0 ms 0 ms 1 D:/Websites/security/application.cfm
31 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
3437 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 @ 19:54:27.027
	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 @ 19:54:27.027
	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 @ 19:54:27.027
	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 @ 19:54:27.027
	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 @ 19:54:27.027
	SELECT adID FROM active_data_ad_list_vw
	WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 5

checkDOMAIN (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 19:54:27.027
		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 @ 19:54:27.027
		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 @ 19:54:27.027
    UPDATE referTracking_sessionID
    SET agent_ID = ?
    WHERE session_UUID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10
Parameter #2(cf_sql_integer) = 10113321

saveStart (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 19:54:27.027
            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) = 10113321

qryGetAd (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:27.027
	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=94ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:27.027
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/27/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) = 193

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

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

major_links (Datasource=graduateguide_prod, Time=15ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 19:54:27.027
  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=32ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 19:54:27.027
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=15ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 19:54:27.027
           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 @ 19:54:27.027
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=16ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 19:54:27.027
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:27.027
	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=157ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:28.028
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/27/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=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:28.028
	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=172ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:28.028
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/27/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 @ 19:54:28.028
	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=187ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:28.028
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/27/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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:28.028
	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=265ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:28.028
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/27/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=32ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:28.028
	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=343ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:29.029
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/27/2017';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 9

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:29.029
	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=203ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:29.029
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/27/2017';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 218

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

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

getColleges (Datasource=graduateguide_prod, Time=46ms, Records=62) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
		select *, 'sponsor' as rank, 1 as show
		from parentChild_college
		where web_ad = 'Y'
		
		  and zip in (SELECT ZIP FROM DMAZip WHERE DMA = ?)
		
		union ALL
		select *, 'general' as rank, 1 as show
		from parentChild_college
		where  web_ad <> 'Y'
		
		  and zip in (SELECT ZIP FROM DMAZip WHERE DMA = ?)
		
		order by rank desc, sort_uni, college_name asc, school_name
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 602
Parameter #2(CF_SQL_VARCHAR) = 602

toRemove (Datasource=, Time=0ms, Records=62) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (3019,343,2559,312,330,331,314,316,2359,2880,318,319,2689,320,321,322,323,2333,1223,2290,2691,328,329,393,333,334,2393,335,336,338,337,339,340,2693,2700,341,342,344,345,346,347,349,350,351,2712,405,2870,354,326,355,356,357,360,2707,361,362,363,366,416,415,367,369) 
getParents (Datasource=, Time=0ms, Records=62) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
    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
getContact (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3019

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

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

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
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) = 312

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
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) = 330

getContact (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
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) = 331

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

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
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) = 316

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
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) = 2359

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:29.029
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) = 2880

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

getContact (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 319

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 2689

getContact (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 320

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 322

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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=32ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 2333

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 1223

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 2290

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 2691

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

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 329

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 393

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 333

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 334

getContact (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 2393

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 19:54:30.030
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) = 335

getAdIDs (Datasource=graduateguide_prod, Time=15ms, Records=2) in D:\Websites\graduateguide_PROD\includes\pod2.cfm @ 19:54:30.030
SELECT adID FROM active_data_ad_list_vw
WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:30.030
	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) = 5

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

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:30.030
	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) = 2

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

qryGetFooterLinks (Datasource=graduateguide_prod, Time=15ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 19:54:30.030
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 19:54:30.030
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 140

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


Stored Procedures

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

    
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 @ 19:54:27.027
    
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=83
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=7449226
CFTOKEN=91f207868d9ffdb9-1619E3BB-98A9-68A2-C063F75B27683016
SESSION_UUID=%28%28%253%2DU%3D7%2DU%3C%28%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=Chicago_graduate_schools
DMA=602
FIELDNAMES=NAME,MAJOR,STATE,DMA,PAGENUM,DISPLAYNAME
MAJOR=0
NAME=
PAGENUM=1
STATE=none
Session Variables:
cfid=7449226
cftoken=91f207868d9ffdb9-1619E3BB-98A9-68A2-C063F75B27683016
entryid=10160996
session_uuid=10113321
sessionid=GARDUATEGUIDE_7449226_91f207868d9ffdb9-1619E3BB-98A9-68A2-C063F75B27683016
urltoken=CFID=7449226&CFTOKEN=91f207868d9ffdb9-1619E3BB-98A9-68A2-C063F75B27683016
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 16 ms