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

Business & Commerce

Business Graduate ProgramsA Master of Business Administration, or MBA, provides a broad business education covering many areas, including management, accounting, finance, economics and entrepreneurship. Earning an MBA can lead to opportunities for career advancement, as graduates of this program gain leadership and managerial skills. Depending on a school's academic programs, students can choose either a general MBA or a specialized degree, which focuses on a specific area of study. Some business schools may require students to have several years of work experience for entry into a full-time MBA program, which typically take two years to complete.

There are 77 Graduate Schools that Offer Business & Commerce in New York

1-28 of 77 Results
SPONSORED LISTINGS
Adelphi University
Garden City, NY
Adelphi University
One South Avenue, PO Box 701
Garden City, NY
ContactOffice of Graduate Admissions
Phone800-ADELPHI
516-877-3050
 
College of Mount Saint Vincent
School of Professional and Graduate Studies
Riverdale, NY
College of Mount Saint Vincent
School of Professional and Graduate Studies
6301 Riverdale Avenue,
Riverdale, NY
ContactOffice of Graduate Admission
Phone718-405-3322
 
Hofstra University
Hempstead, NY
Hofstra University
126 Hofstra University, 105 Memorial Hall
Hempstead, NY
ContactOffice of Graduate Admissions
Phone1-866-GRADHOF
516-463-4723
 
Niagara University
Niagara University, NY
Niagara University
One Welcome Circle, Gacioch Family Alumni and Admissions Center
Niagara University, NY
ContactGraduate Studies Office
Phone800-462-2111
716-286-8327
 
Queens College
City University of New York
Queens, NY
Queens College
City University of New York
65-30 Kissena Boulevard, Jefferson Hall, Room 105
Queens, NY
ContactDirector of Graduate Admissions
Phone718-997-5200
 
University at Buffalo-SUNY
The Graduate School
Buffalo, NY
University at Buffalo-SUNY
The Graduate School
408 Capen Hall,
Buffalo, NY
Phone716-645-3482
 
St. John's University
Queens, NY
St. John's University
8000 Utopia Parkway,
Queens, NY
ContactOffice of Graduate Admissions
Phone718-990-1601
 
GENERAL LISTINGS
Alfred University
Alfred, NY
Alfred University
One Saxon Drive,
Alfred, NY
ContactOffice of Graduate Admissions
Phone800-541-9229
607-871-2115
 
Bard College
Annandale-on-Hudson, NY
Bard College
PO Box 5000,
Annandale-on-Hudson, NY
Phone845-758-7895
 
Baruch College
City University of New York
New York, NY
Baruch College
City University of New York
55 Lexington at 24th St,
New York, NY
ContactDirector of Graduate Admissions
Phone646-312-1000
 
Canisius College
Buffalo, NY
Canisius College
2001 Main Street, Lyons Hall 120
Buffalo, NY
ContactOffice of Graduate Admissions
Phone800-950-2505
716-888-2545
 
City University of New York
The Graduate Center
New York, NY
City University of New York
The Graduate Center
365 Fifth Ave.,
New York, NY
ContactOffice of Graduate Admissions
Phone877-428-6942
212-817-7470
 
Clarkson University
Potsdam, NY
Clarkson University
8 Clarkson Avenue,
Potsdam, NY
Phone315-268-6400
 
College of Saint Rose
Albany, NY
College of Saint Rose
432 Western Avenue,
Albany, NY
ContactOffice of Graduate Admissions
Phone518-454-5143
 
College of Staten Island, (CUNY)
City University of New York
Staten Island, NY
College of Staten Island, (CUNY)
City University of New York
2800 Victory Boulevard,
Staten Island, NY
ContactOffice of Recruitment and Admissions
Phone718-982-2019
 
Columbia University
Columbia Business School
New York, NY
Columbia University
Columbia Business School
3022 Broadway, 311 Uris Hall, MC 9133
New York, NY
ContactAmanda Carlson, Assistant Dean of Admissions & Financial Aid
Phone212-854-2078
 
Columbia University
Graduate School of Arts & Sciences
New York, NY
Columbia University
Graduate School of Arts & Sciences
535 W. 116th St., MC 4304, 107 Low Library
New York, NY
ContactOffice of Graduate Admissions
Phone212-854-6729
212-854-8903
 
Concordia College - New York
Bronxville, NY
Concordia College - New York
171 White Plains Road,
Bronxville, NY
Phone914-337-9300
 
Cornell University
The Graduate School
Ithaca, NY
Cornell University
The Graduate School
143 Caldwell Hall ,
Ithaca, NY
ContactOffice of Graduate Admissions
Phone607-255-5820
 
Cornell University ILR School
Ithaca, NY
Cornell University ILR School
Cornell University, 218 Ives Hall
Ithaca, NY
ContactGraduate Programs Office
Phone607-255-1522
 
D'Youville College
Buffalo, NY
D'Youville College
320 Porter Avenue,
Buffalo, NY
ContactMark Pavone, Graduate Admissions Director
Phone800-777-3921
716-829-8400
 
Daemen College
Amherst, NY
Daemen College
4380 Main St.,
Amherst, NY
ContactOffice of Graduate Admissions
Phone800-462-7652
716-839-8225
 
Dominican College
Orangeburg, NY
Dominican College
470 Western Highway,
Orangeburg, NY
ContactOffice of Graduate Admissions
Phone845-848-7908
845-848-7910
 
Elmira College
Continuing Education and Graduate Studies
Elmira, NY
Elmira College
Continuing Education and Graduate Studies
117 McGraw Hall, One Park Place
Elmira, NY
ContactOffice of Graduate Studies
Phone800-354-4720
607-735-1825
 
Excelsior College
Albany, NY
Excelsior College
7 Columbia Circle,
Albany, NY
ContactOffice of Graduate Admissions
Phone888-647-2388 21
518-464-8500
 
Fashion Institute of Technology
School of Graduate Studies
New York, NY
Fashion Institute of Technology
School of Graduate Studies
227 W 27th Street, Room E315
New York, NY
ContactOffice of Graduate Admissions
Phone212-217-4300
 
Fordham University
Bronx, NY
Fordham University
441 E. Fordham Road,
Bronx, NY
ContactOffice of Graduate Admissions
Phone718-817-1000
 
Iona College
New Rochelle, NY
Iona College
715 North Avenue,
New Rochelle, NY
ContactAdmissions
Phone800-231-IONA
914-633-2502
 

There were 77 schools found that offer Business & Commerce in the state NY

SPONSORED PROGRAMS


Debugging Information
ColdFusion Server Standard 10,0,13,287689
Template /results.cfm
Time Stamp 29-May-17 11:43 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
2110 ms 2110 ms 1 D:/Websites/graduateguide_PROD/results.cfm
922 ms 922 ms 1 D:/Websites/graduateguide_PROD/header.cfm
797 ms 797 ms 1 D:/Websites/graduateguide_PROD/results_search.cfm
750 ms 750 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
672 ms 84 ms 8 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
375 ms 375 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
265 ms 265 ms 1 D:/Websites/graduateguide_PROD/includes/pod3.cfm
265 ms 265 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
250 ms 83 ms 3 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(major = 7007, pos = 6) ] 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 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
78 ms 78 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
32 ms 32 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+T=?'UL0 , 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 | 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 8 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 4) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
0 ms 0 ms 3 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrMajorAdID(MAJ = 7007) ] 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=?'UL0 , ) ] 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=?'UL0 ) ] 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, 10751917) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | referTracking_save_UA_reference(10, 10751917) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
0 ms 0 ms 1 D:/Websites/security/application.cfm
46 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2188 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

saveStart (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 23:42:59.059
            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) = 10751917

qryH_Major (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results.cfm @ 23:42:59.059
    SELECT StateList.StateName, majors.major, majors.descr FROM saved_search INNER JOIN
	majors ON saved_search.major = majors.major_id INNER JOIN StateList ON saved_search.state = StateList.StateCode
	WHERE saved_search.major = ?
    and saved_search.state = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7007
Parameter #2(cf_sql_varchar) = NY

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:42:59.059
	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) = 216

trackAd_viewing (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:42:59.059
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/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) = 216

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

getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 23:42:59.059
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 @ 23:42:59.059
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 @ 23:42:59.059
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 @ 23:42:59.059
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 @ 23:42:59.059
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 @ 23:42:59.059
  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 @ 23:42:59.059
         Select * From Majors ORDER BY Major ASC
         
getMajors3 (Datasource=graduateguide_prod, Time=15ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 23:42:59.059
           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=16ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 23:42:59.059
         Select * From Majors ORDER BY Major ASC
         
getAdIDs4 (Datasource=graduateguide_prod, Time=0ms, Records=8) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 23:42:59.059
SELECT TOP 9 adID FROM active_data_ad_list_vw
WHERE positionID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4

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

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

trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:43:00.000
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/2017';
	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
				WHERE date_viewed = @currDate 
				AND adID = @adID)
	BEGIN
		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
		VALUES (@adID, 1, @currDate)
	END
	ELSE
	BEGIN
		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
		WHERE adID = @adID
		AND date_viewed = @currDate
	END
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 167

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

trackAd_viewing (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:43:00.000
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/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=0ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
		select *
		from majors
		where major_id = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7007

getColleges (Datasource=graduateguide_prod, Time=47ms, Records=77) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
		select *, 'sponsor' as rank, 1 as show
		from parentChild_collegeMajor
		where web_ad = 'Y'
		and state = 'NY' and major = 7007
		union ALL
		select *, 'general' as rank, 1 as show
		from parentChild_collegeMajor
		where  web_ad <> 'Y'
		 and state = 'NY' and major = 7007 
		order by rank desc, sort_uni, college_name asc, school_name
	
toRemove (Datasource=, Time=0ms, Records=77) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
	select college_id from getColleges where subcollege_id = 0
findOthers (Datasource=, Time=0ms, Records=0) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
		select distinct college_id 
		from getColleges 
		where college_id NOT IN (679,698,729,761,766,774,2412,684,687,688,691,693,695,700,701,705,703,3060,715,2296,718,719,720,723,1249,724,726,731,2560,732,736,737,2799,738,739,742,744,1244,745,685,746,2451,747,749,2849,756,760,764,2400,762,767,768,769,771,772,773,775,777,2801,781,782,784,785,783,787,788,790,803,802,791,2398,793,806,808,811,812,813) 
getParents (Datasource=, Time=0ms, Records=77) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
    select *
 	from getColleges
	where subcollege_id = 0
	and rank <> 'sponsor'
	union all
    select *
 	from getColleges
	where rank = 'sponsor'
	order by rank desc, sort_uni, college_name asc, school_name
getStateName (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
SELECT StateName as state
FROM StateList
WHERE StateCode = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = NY

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

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

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

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

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

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

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
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) = 684

getContact (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
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) = 687

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
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) = 688

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:00.000
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) = 691

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 693

getContact (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 695

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 700

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

getContact (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 705

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

getContact (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 3060

getContact (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 715

getContact (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 2296

getContact (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 718

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 719

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

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 723

getContact (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 1249

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 724

getContact (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 726

getContact (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\results_search.cfm @ 23:43:01.001
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) = 731

getAdIDs (Datasource=graduateguide_prod, Time=15ms, Records=3) in D:\Websites\graduateguide_PROD\includes\pod3.cfm @ 23:43:01.001
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) = 7007

getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=3, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 23:43:01.001
	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_varchar) = 7007

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:43:01.001
	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) = 119

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

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:43:01.001
	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) = 87

trackAd_viewing (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:43:01.001
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/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) = 87

qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:43:01.001
	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) = 202

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

qryGetFooterLinks (Datasource=graduateguide_prod, Time=16ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 23:43:01.001
	select * from footer_links_vw
qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 23:43:01.001
	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 @ 23:43:01.001
	DECLARE @adID INT, @currDate varchar(10);
	SET @adID = ?;
	SET @currDate = '05/29/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 @ 23:43:01.001
	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) = 10751917


Stored Procedures

sp_referTracking_USER_AGENT_insert (Datasource=graduateguide_prod, Time=16ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 23:42:59.059

    
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 @ 23:42:59.059
    
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=80
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=8093740
CFTOKEN=b6c61ab1de9da882-6A78EFA4-FF65-DD82-D0A753124B61FBA1
SESSION_UUID=%28%28%253%2BT%3D%3F%27UL0%20
SHOW_DEBUG=Yes
Form Fields:
DISPLAYNAME=New_York_Business_Commerce
FIELDNAMES=NAME,MAJOR,STATE,PAGENUM,DISPLAYNAME
MAJOR=7007
NAME=
PAGENUM=1
STATE=NY
Session Variables:
cfid=8093740
cftoken=b6c61ab1de9da882-6A78EFA4-FF65-DD82-D0A753124B61FBA1
entryid=10803949
session_uuid=10751917
sessionid=GARDUATEGUIDE_8093740_b6c61ab1de9da882-6A78EFA4-FF65-DD82-D0A753124B61FBA1
urltoken=CFID=8093740&CFTOKEN=b6c61ab1de9da882-6A78EFA4-FF65-DD82-D0A753124B61FBA1
URL Parameters:
ADID__BOTTOM=0
ADID__TOP=0
Debug Rendering Time: 31 ms