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

SPONSORED LISTINGS
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
 
GENERAL LISTINGS
Acupuncture & Massage College
Miami, FL
Acupuncture & Massage College
10506 N Kendall Drive,
Miami, FL
Phone305-595-9500
 
Atlantic Institute of Oriental Medicine
Fort Lauderdale, FL
Atlantic Institute of Oriental Medicine
100 E. Broward Boulevard,
Fort Lauderdale, FL
Phone954-763-9840 213
 
Barry University
Miami, FL
Barry University
11300 NE 2nd Avenue,
Miami, FL
ContactOffice of Admissions
Phone800-695-2279
305-899-3100
 
Carlos Albizu University
Miami, FL
Carlos Albizu University
2173 NW 99th Avenue,
Miami, FL
ContactOffice of Graduate Admissions
Phone888-468-6228
305-593-1223 3137
 
Florida Memorial University
Miami Gardens, FL
Florida Memorial University
15800 NW 42nd Avenue,
Miami Gardens, FL
Phone305-626-3600
 
Florida National University
Online Learning Division
Hialeah, FL
Florida National University
Online Learning Division
4425 W. 20th Avenue,
Hialeah, FL
Phone305-821-3333 1016
 
Kaplan University
Ft. Lauderdale, FL
Kaplan University
6301 Kaplan University Avenue,
Ft. Lauderdale, FL
Phone866-527-5268
 
Keiser University
Fort Lauderdale, FL
Keiser University
1900 West Commercial Blvd.,
Fort Lauderdale, FL
ContactGraduate Admissions Office
Phone888-753-4737
 
Miami International University of Art & Design
Miami, FL
Miami International University of Art & Design
1501 Biscayne Blvd., Suite 100,
Miami, FL
ContactOffice of Admissions
Phone800-225-9023
305-428-5700
 
Nova Southeastern University
Fort Lauderdale, FL
Nova Southeastern University
3301 College Avenue,
Fort Lauderdale, FL
ContactOffice of Graduate Admissions
Phone800-541-NOVA
954-262-7300
 
St. Thomas University
Miami , FL
St. Thomas University
16401 N.W. 37th Avenue,
Miami , FL
ContactOffice of Graduate Admissions
Phone305-628-6546
800-367-9010
 
Trinity International University
Florida Regional Center
Davie, FL
Trinity International University
Florida Regional Center
8190 W. State Road 84,
Davie, FL
ContactOffice of Graduate Admissions
Phone954-382-6419
954-382-6574
 
Union Institute & University
Florida Academic Center
North Miami Beach, FL
Union Institute & University
Florida Academic Center
16853 N.E. 2nd Avenue, Suite 102,
North Miami Beach, FL
Phone800-486-7141
 
University of Miami
College of Arts and Sciences
Coral Gables, FL
University of Miami
College of Arts and Sciences
POB 248004, 1365 Memorial Drive
Coral Gables, FL
ContactOffice of Graduate Admissions
Phone305-284-3188
 
University of Miami
College of Engineering
Coral Gables, FL
University of Miami
College of Engineering
1251 Memorial Drive, Room 244, PO Box 248294
Coral Gables, FL
Phone305-284-2942
 
University of Miami
Frost School of Music
Coral Gables, FL
University of Miami
Frost School of Music
PO Box 248165 ,
Coral Gables, FL
ContactOffice of Graduate Admissions
Phone305-284-2241
 
University of Miami
Miller School of Medicine
Miami, FL
University of Miami
Miller School of Medicine
1600 NW 10th Avenue, Suite 1149, PO Box 016159
Miami, FL
ContactOffice of Admissions
Phone305-243-3234
305-243-1847
 
University of Miami
Rosenstiel School of Marine & Atmospheric Science
Miami, FL
University of Miami
Rosenstiel School of Marine & Atmospheric Science
4600 Rickenbacker Causeway,
Miami, FL
ContactOffice of Graduate Studies
Phone305-421-4155
 
University of Miami
School of Architecture
Coral Gables, FL
University of Miami
School of Architecture
1223 Dickinson Drive,
Coral Gables, FL
ContactDean
Phone305-284-3060
 
University of Miami
School of Business Administration
Coral Gables, FL
University of Miami
School of Business Administration
PO Box 248505,
Coral Gables, FL
ContactOffice of Graduate Admissions
Phone305-284-4607
800-531-7137
 
University of Miami
School of Communication
Coral Gables, FL
University of Miami
School of Communication
5100 Brunson Dr., Suite 4002
Coral Gables, FL
ContactOffice of Graduate Admissions
Phone305-284-5236
 
University of Miami
School of Education & Human Development
Coral Gables, FL
University of Miami
School of Education & Human Development
Max Orovitz Bldg., Rm. 311
Coral Gables, FL
ContactOffice of Graduate Admissions
Phone305-284-2167
305-284-2102
 
University of Miami
School of Law
Coral Gables, FL
University of Miami
School of Law
1311 Miller Drive, F203,
Coral Gables, FL
ContactOffice of Admissions & Student Recruitment
Phone305-284-6746
 
University of Miami
School of Nursing and Health Studies
Coral Gables, FL
University of Miami
School of Nursing and Health Studies
PO Box 248153, 5030 Brunson Drive
Coral Gables, FL
Phone305-284-3666
 
University of Miami
The Graduate School
Coral Gables, FL
University of Miami
The Graduate School
,
Coral Gables, FL
ContactOffice of Graduate Admissions
Phone305-284-4154
 


SPONSORED GRADUATE SCHOOLS

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
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


Debugging Information
ColdFusion Server Standard 10,0,13,287689
Template /results.cfm
Time Stamp 20-Feb-17 10:25 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
4141 ms 4141 ms 1 D:/Websites/graduateguide_PROD/results.cfm
2141 ms 2141 ms 1 D:/Websites/graduateguide_PROD/header.cfm
1641 ms 1641 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
1609 ms 1609 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
1469 ms 163 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
375 ms 375 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
359 ms 359 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
234 ms 234 ms 1 D:/Websites/graduateguide_PROD/includes/pod2.cfm
234 ms 234 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
219 ms 110 ms 2 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(3) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
172 ms 172 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | INIT_tracking() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
157 ms 157 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
93 ms 93 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
62 ms 62 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = , session_UUID = ((%3,T=[)T� , 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, 10058747) ] 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,T=[)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,T=[)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, 10058747) ] 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
172 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
4375 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

saveStart (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 10:25:22.022
            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) = 10058747

qryGetAd (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:22.022
	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) = 201

trackAd_viewing (Datasource=graduateguide_prod, Time=343ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:23.023
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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) = 201

getSubnav (Datasource=graduateguide_prod, Time=31ms, Records=4) in D:\Websites\graduateguide_PROD\navigation.cfm @ 10:25:23.023
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 @ 10:25:23.023
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 @ 10:25:23.023
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 @ 10:25:23.023
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 @ 10:25:23.023
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 @ 10:25:23.023
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=46ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 10:25:23.023
  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 @ 10:25:23.023
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=31ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 10:25:23.023
           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 @ 10:25:23.023
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=0ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 10:25:23.023
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 @ 10:25:23.023
	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=297ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:23.023
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:23.023
	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=219ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	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=109ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	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=110ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/2017';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 167

qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	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=94ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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 @ 10:25:24.024
	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=109ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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 @ 10:25:24.024
	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 @ 10:25:24.024
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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 @ 10:25:24.024
	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=93ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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=32ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	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=156ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:24.024
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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

getColleges (Datasource=graduateguide_prod, Time=94ms, Records=26) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
		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) = 528
Parameter #2(CF_SQL_VARCHAR) = 528

toRemove (Datasource=, Time=0ms, Records=26) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (217,2676,2677,211,212,2684,2960,2543,2571,1218,225,229,232,2383,236,237,246,245,239,240,241,242,243,244,247,235) 
getParents (Datasource=, Time=0ms, Records=26) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
    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=78ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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=234ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 2676

getContact (Datasource=graduateguide_prod, Time=110ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 2677

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 211

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 212

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 2684

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 2960

getContact (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 2543

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

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 1218

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 225

getContact (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 229

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

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 2383

getContact (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 236

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:25.025
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) = 237

getContact (Datasource=graduateguide_prod, Time=109ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 246

getContact (Datasource=graduateguide_prod, Time=94ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 245

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 239

getContact (Datasource=graduateguide_prod, Time=94ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 240

getContact (Datasource=graduateguide_prod, Time=125ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 241

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 242

getContact (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 243

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 244

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 10:25:26.026
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) = 247

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

getAdIDs (Datasource=graduateguide_prod, Time=15ms, Records=2) in D:\Websites\graduateguide_PROD\includes\pod2.cfm @ 10:25:26.026
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 @ 10:25:26.026
	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=109ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:26.026
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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

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

qryGetFooterLinks (Datasource=graduateguide_prod, Time=16ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 10:25:26.026
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:26.026
	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=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 10:25:26.026
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '02/20/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) = 194

updTracking (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 10:25:26.026
	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) = 10058747


Stored Procedures

sp_referTracking_USER_AGENT_insert (Datasource=graduateguide_prod, Time=15ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 10:25:22.022

    
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 @ 10:25:23.023
    
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=101
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=7394040
CFTOKEN=19270551b542f7f4-9946565A-A96C-BA1D-4454BF076C9373F9
SESSION_UUID=%28%28%253%2CT%3D%5B%29T%5C0%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=Miami_Fort_Lauderdale_graduate_schools
DMA=528
FIELDNAMES=NAME,MAJOR,STATE,DMA,PAGENUM,DISPLAYNAME
MAJOR=0
NAME=
PAGENUM=1
STATE=none
Session Variables:
cfid=7394040
cftoken=19270551b542f7f4-9946565A-A96C-BA1D-4454BF076C9373F9
entryid=10105928
session_uuid=10058747
sessionid=GARDUATEGUIDE_7394040_19270551b542f7f4-9946565A-A96C-BA1D-4454BF076C9373F9
urltoken=CFID=7394040&CFTOKEN=19270551b542f7f4-9946565A-A96C-BA1D-4454BF076C9373F9
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 31 ms