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

Architecture & Related Programs

Architecture Graduate ProgramsA Master of Architecture (M.Arch) degree program provides students with an opportunity to expand on the architectural knowledge that they acquired at the undergraduate level. Graduate programs in this subject tend to be interdisciplinary and focus on the theories and methods that are used to design, create and alter internal and external spaces. The Architectural Registration Exam is required for licensure. Students who complete either an undergraduate degree in architecture or a M.Arch are qualified to take this exam. The M.Arch degree typically takes between one and three and a half years to complete and can lead to a career as a professional architect or a teacher at the postsecondary level.

There are 135 Graduate Schools that Offer Architecture & Related Programs

1-28 of 135 Results
SPONSORED LISTINGS
Cooper Union for the Advancement of Science and Art
Irwin S. Chanin School of Architecture and The Albert Nerken School of Engineering
New York, NY
Cooper Union for the Advancement of Science and Art
Irwin S. Chanin School of Architecture and The Albert Nerken School of Engineering
30 Cooper Square, 3rd Floor
New York, NY
Phone212-353-4120
 
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
 
New Jersey Institute of Technology
Newark, NJ
New Jersey Institute of Technology
University Heights, Fenster Hall, Room 100
Newark, NJ
ContactOffice of Graduate Admissions
Phone800-925-NJIT
973-596-3462
 
New York Institute of Technology
Old Westbury, NY
New York Institute of Technology
Northern Boulevard,
Old Westbury, NY
ContactOffice of Graduate Admissions
Phone800-345-NYIT
 
Northeastern University
Boston, MA
Northeastern University
360 Huntington Avenue,
Boston, MA
Phone617-373-2000
 
Philadelphia University
Philadelphia, PA
Philadelphia University
4201 Henry Avenue,
Philadelphia, PA
ContactOffice of Graduate Admissions
Phone800-951-7287
215-951-2943
 
Pratt Institute
Brooklyn, NY
Pratt Institute
200 Willoughby Ave., Myrtle Hall, 2nd Floor
Brooklyn, NY
ContactOffice of Graduate Admissions
Phone800-331-0834
718-636-3514
 
Roger Williams University
Graduate Programs
Bristol, RI
Roger Williams University
Graduate Programs
One Old Ferry Road,
Bristol, RI
ContactOffice of Graduate Admission
Phone888-674-8479 6200
401-254-6200
 
University at Buffalo-SUNY
The Graduate School
Buffalo, NY
University at Buffalo-SUNY
The Graduate School
408 Capen Hall,
Buffalo, NY
Phone716-645-3482
 
South Dakota State University
Graduate School
Brookings, SD
South Dakota State University
Graduate School
Box 2201, Morrill Hall 130
Brookings, SD
ContactGraduate School Admissions
Phone605-688-4181
 
University of Idaho
Graduate Studies
Moscow, ID
University of Idaho
Graduate Studies
875 Perimeter Drive, MS 3019,
Moscow, ID
ContactGraduate Admissions
Phone208-885-4001
208-885-4723
 
GENERAL LISTINGS
Academy of Art University
San Francisco, CA
Academy of Art University
79 New Montgomery St., 4th Floor
San Francisco, CA
ContactOffice of Graduate Admissions
Phone800-544-2787
415-274-2200
 
Andrews University
Berrien Springs, MI
Andrews University
4150 Administration Dr,
Berrien Springs, MI
Phone269-471-6321
 
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
 
Auburn University
Auburn, AL
Auburn University
106B Hargis Hall,
Auburn, AL
ContactOffice of Graduate Admissions
Phone334-844-4700
 
Ball State University
Muncie, IN
Ball State University
2000 W University,
Muncie, IN
ContactOffice of Graduate Admissions
Phone866-285-4723
317-285-1297
 
Boston Architectural College
Boston, MA
Boston Architectural College
320 Newbury St.,
Boston, MA
ContactDirector of Admission
Phone617-585-0123
 
Bowling Green State University
Bowling Green, OH
Bowling Green State University
120 McFall Center,
Bowling Green, OH
ContactOffice of Graduate Admissions
Phone419-372-2791
 
Brown University
Graduate School
Providence, RI
Brown University
Graduate School
47 George St., Box 1867
Providence, RI
ContactOffice of Graduate Admissions
Phone401-863-2600
 
Cal Poly Pomona
Pomona, CA
Cal Poly Pomona
3801 W. Temple Avenue, Building 98-T2
Pomona, CA
Phone909-869-5299
 
Cal Poly, San Luis Obispo
San Luis Obispo, CA
Cal Poly, San Luis Obispo
Office of Graduate Admissions,
San Luis Obispo, CA
Phone805-756-2311
 
California College of the Arts
San Francisco, CA
California College of the Arts
1111 Eighth Street,
San Francisco, CA
ContactOffice of Graduate Admissions
Phone800-447-1278
 
Carleton University
Faculty of Graduate and Postdoctoral Affairs
Ottawa, ON
Carleton University
Faculty of Graduate and Postdoctoral Affairs
Room 512 Tory Building, 1125 Colonel By Dr.,
Ottawa, ON
Phone613-520-2525
 
Carnegie Mellon University
Pittsburgh, PA
Carnegie Mellon University
5000 Forbes Ave.,
Pittsburgh, PA
ContactAssistant Vice Provost for Graduate Education
Phone412-268-7307
 
The Catholic University of America
Washington, DC
The Catholic University of America
620 Michigan Avenue, N.E.,
Washington, DC
ContactOffice of Graduate Admissions
Phone800-673-2772
202-319-5057
 
Chatham University
Pittsburgh, PA
Chatham University
Woodland Road,
Pittsburgh, PA
ContactOffice of Graduate Admissions
Phone800-837-1290
412-365-1825
 
City College
City University of New York
New York, NY
City College
City University of New York
160 Convent Avenue, Room A101
New York, NY
ContactOffice of Graduate Admissions
Phone212-650-6977
 
Clemson University
Graduate School
Clemson, SC
Clemson University
Graduate School
E-209 Martin Hall,
Clemson, SC
ContactOffice of Graduate Admissions
Phone864-656-3195
 

There were 135 schools found that offer Architecture & Related Programs


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
2156 ms 2156 ms 1 D:/Websites/graduateguide_PROD/results.cfm
1016 ms 1016 ms 1 D:/Websites/graduateguide_PROD/header.cfm
969 ms 969 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
844 ms 844 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
750 ms 83 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
156 ms 156 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
109 ms 109 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 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
78 ms 78 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
47 ms 47 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
32 ms 32 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/TL( , 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, 10333151) ] 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
15 ms 15 ms 1 D:/Websites/graduateguide_PROD/includes/pod3.cfm
15 ms 15 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestEnd(/results.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestStart(/results.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 1) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 2) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 4) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | cfcookie(session_UUID, ((%3/U]7/TL( , ) ] 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/TL( ) ] 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, 10333151) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 D:/Websites/security/application.cfm
32 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2235 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:06.006
	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:06.006
	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:06.006
	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:06.006
	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:06.006
	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 @ 00:53:06.006
		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:06.006
		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:06.006
    UPDATE referTracking_sessionID
    SET agent_ID = ?
    WHERE session_UUID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10
Parameter #2(cf_sql_integer) = 10333151

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

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

qryGetAd (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:06.006
	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) = 23

trackAd_viewing (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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) = 23

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

getSubnav (Datasource=graduateguide_prod, Time=15ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:07.007
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:07.007
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=15ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:07.007
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=0ms, Records=2) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:07.007
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 @ 00:53:07.007
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:07.007
  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:07.007
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=16ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 00:53:07.007
           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=15ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 00:53:07.007
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=16ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 00:53:07.007
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=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
    ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
    FROM Data_ads
	WHERE adID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 10

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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) = 9

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

trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=79ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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:07.007
	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:07.007
	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=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:07.007
	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=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:07.007
		select *
		from majors
		where major_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7004

getColleges (Datasource=graduateguide_prod, Time=79ms, Records=135) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:08.008
		select *, 'sponsor' as rank, 1 as show
		from parentChild_collegeMajor
		where web_ad = 'Y'
		and major = 7004
		union ALL
		select *, 'general' as rank, 1 as show
		from parentChild_collegeMajor
		where  web_ad <> 'Y'
		and major = 7004 
		order by rank desc, sort_uni, college_name asc, school_name
	
toRemove (Datasource=, Time=0ms, Records=135) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:08.008
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:08.008
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (2970,217,666,756,544,960,765,2322,2260,2412,1478,28,572,1333,3,372,485,864,999,48,39,41,1160,919,1220,920,692,1011,702,703,509,2431,715,578,193,830,2533,724,214,1340,273,451,520,524,329,1445,2393,1492,880,585,1536,950,535,1164,886,1748,462,2636,2938,2849,1208,841,1766,893,957,1993,668,767,1005,1998,769,2428,290,357,127,783,806,969,2027,2045,1577,2790,1349,133,137,2281,899,1399,234,302,1169,176,1415,2103,365,1509,432,1579,470,560,1061,240,619,1627,1803,1834,848,412,1886,1936,973,979,976,250,1178,1064,2056,2065,2085,1172,2161,1085,1112,2212,1173,1147,2232,904,2169,1114,2225,1736,155,180,189) 
getParents (Datasource=, Time=15ms, Records=135) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:08.008
    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=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 00:53:08.008
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:08.008
select email, phone, ext, phone2, ext2, address, add2, contact
from college_listings
where college_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2970

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

qryGetFooterLinks (Datasource=graduateguide_prod, Time=16ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 00:53:08.008
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 00:53:08.008
	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 @ 00:53:09.009
	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) = 194

updTracking (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 00:53:09.009
	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) = 10333151


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_VARCHAR  ColdFusion    
    
resultsets
nameresultset
 result  1
dbo.main_navigation (Datasource=graduateguide_prod, Time=0ms) in D:\Websites\graduateguide_PROD\navigation.cfm @ 00:53:07.007
    
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=7671120
CFTOKEN=f2f2a5abc614b3f4-278A1699-B8FD-2DB3-0E3A0AD903A2E69A
SESSION_UUID=%28%28%253%2FU%5D7%2FTL%28%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=Architecture_Related_Programs
FIELDNAMES=NAME,MAJOR,STATE,PAGENUM,DISPLAYNAME
MAJOR=7004
NAME=
PAGENUM=1
STATE=none
Session Variables:
cfid=7671120
cftoken=f2f2a5abc614b3f4-278A1699-B8FD-2DB3-0E3A0AD903A2E69A
entryid=10382499
session_uuid=10333151
sessionid=GARDUATEGUIDE_7671120_f2f2a5abc614b3f4-278A1699-B8FD-2DB3-0E3A0AD903A2E69A
urltoken=CFID=7671120&CFTOKEN=f2f2a5abc614b3f4-278A1699-B8FD-2DB3-0E3A0AD903A2E69A
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 15 ms