Free To Grow - Directories


	>	Directories
	>	Grantee Profiles
	>	Background
	>	National Demonstration
	>	National Evaluation
	>	Program Partners
	>	Publications

Free To Grow
Mailman School
of Public Health
Columbia University
722 West 168th Street,
8th Floor
New York, NY 10032
Phone: 212-305-8120
Fax: 212-342-1963
info@freetogrow.org

The work of Free To Grow happens through the combined efforts of many individuals. We have provided these Directories to acquaint you with the people who are behind Free To Grow.

> Evaluation Advisory Panel

> Evaluation Team

> Foundation Staff

> National Advisory Committee

> National Program Office Staff

Contact Us [info@freetogrow.org]

Disclaimer
an iapps site

Free To Grow is a national program supported by the Robert Wood Johnson Foundation and the Doris Duke Charitable Foundation with direction and technical assistance provided by the Mailman School of Public Health of Columbia University.

Queries

 (Records=1, Time=0ms)
SQL = 
sp_application_body

 (Records=1, Time=0ms)
SQL = 
sp_application_body

 (Records=1, Time=0ms)
SQL = 
sp_application_body

 (Records=1, Time=0ms)
SQL = 
sp_application_body

 (Records=1, Time=0ms)
SQL = 
sp_application_body

qry_cached (Records=1, Time=0ms)
SQL = 
sp_frame_cache 3357

qry_cache_existence (Records=1, Time=15ms)
SQL = 
sp_cached_output_get 'StyleSheet_1', 'ftg'

qry_get_text (Records=1, Time=0ms)
SQL = 
sp_get_text 3357

qry_get_text (Records=1, Time=15ms)
SQL = 
sp_get_text 3357

qry_dir_cats (Records=5, Time=16ms)
SQL = 
SELECT DISTINCT(char_3)
	FROM tbl_docs
	WHERE frame_id = 3357

get_categories (Records=5, Time=0ms)
SQL = 
select DISTINCT case 
			when tdha.attrib_id = 7434 then 'Family'
			when tdha.attrib_id = 7435 then 'Partners'
			when tdha.attrib_id = 7436 then 'Community'
			when tdha.attrib_id = 7437 then 'Web Links'
			when tdha.attrib_id = 7438 then 'General'
		end as lable,
		case 
			when tdha.attrib_id = 7434 then 1
			when tdha.attrib_id = 7435 then 2
			when tdha.attrib_id = 7436 then 3
			when tdha.attrib_id = 7437 then 4
			when tdha.attrib_id = 7438 then 5
		end as prior,
		tdha.attrib_id
	from tbl_docs td,
	     tbl_doc_has_attrib tdha
	where td.frame_id = 3359
	and td.doc_id = tdha.doc_id
	and tdha.attrib_id in (select attrib_id from tbl_attrib where type_id = 957)
	order by  prior, lable, tdha.attrib_id

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3361

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3361
	AND			site_id = 'ftg'

qry_cat_list (Records=6, Time=16ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3361
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3361)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 6
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 6
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 6
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 7
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 7
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 7
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 8
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 8
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 8
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 272
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 272
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 272
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 437
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 437
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 437
							and		tdc.frame_id = 3361

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 9
				and		td.frame_id = 3361

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 9
							and		tdc.frame_id = 3361

qry_cat_text (Records=1, Time=16ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 9
							and		tdc.frame_id = 3361

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3360

get_frame_properties (Records=1, Time=15ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3360
	AND			site_id = 'ftg'

qry_cat_list (Records=5, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3360
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3360)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 1
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=16ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 1
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 1
							and		tdc.frame_id = 3360

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 2
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 2
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 2
							and		tdc.frame_id = 3360

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 3
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 3
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 3
							and		tdc.frame_id = 3360

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 4
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 4
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=15ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 4
							and		tdc.frame_id = 3360

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 5
				and		td.frame_id = 3360

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 5
							and		tdc.frame_id = 3360

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 5
							and		tdc.frame_id = 3360

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3812

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3812
	AND			site_id = 'ftg'

qry_cat_list (Records=6, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3812
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3812)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 49
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=15ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 49
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 49
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 50
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 50
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 50
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 51
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 51
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 51
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 52
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 52
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 52
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 438
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=15ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 438
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 438
							and		tdc.frame_id = 3812

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 53
				and		td.frame_id = 3812

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 53
							and		tdc.frame_id = 3812

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 53
							and		tdc.frame_id = 3812

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3362

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3362
	AND			site_id = 'ftg'

qry_cat_list (Records=5, Time=15ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3362
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3362)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 10
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 10
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 10
							and		tdc.frame_id = 3362

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 11
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 11
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 11
							and		tdc.frame_id = 3362

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 12
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 12
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 12
							and		tdc.frame_id = 3362

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 13
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 13
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 13
							and		tdc.frame_id = 3362

qry_docs_num (Records=1, Time=16ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 14
				and		td.frame_id = 3362

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 14
							and		tdc.frame_id = 3362

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 14
							and		tdc.frame_id = 3362

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3375

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3375
	AND			site_id = 'ftg'

qry_cat_list (Records=0, Time=0ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3375
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3375)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

get_children (Records=1, Time=0ms)
SQL = 
SELECT 	lable,
			url,
			frame_id
	FROM	tbl_feature_usage
	WHERE	parent_id = 3363
	
	AND		frame_id not in (3365,3367)
	
	AND		frame_id not in (3877)
	order by creation_date

nav (Records=11, Time=Cached Query)
SQL = 
SELECT DISTINCT 
					tfu.frame_id,
					tfu.lable,
					CASE
				    WHEN tfu.feature_id = null THEN tfu.url 
				    ELSE ts.root_url + tfu.url  
				   	END
				    AS  url,
					tfu.creation_date
		FROM		tbl_feature_usage tfu, tbl_sites ts
		WHERE		tfu.site_id = 'ftg'
		and			tfu.site_id = ts.site_id
		AND		tfu.hidden = 0
		AND		(
				frame_id in (3348)
				
		
		
		
			OR frame_id = (select parent_id
								from tbl_feature_usage
								where frame_id = 3357)
		
		
		
			OR parent_id = (select parent_id
								from tbl_feature_usage
								where frame_id = 3357)
		
		
		
			OR parent_id = 3357
		
		
		
			OR parent_id = (	SELECT parent_ID
								FROM	tbl_feature_usage
								WHERE	frame_id in (	SELECT	parent_id
														FROM	tbl_feature_usage
														WHERE	frame_id = 3357)
							)
		
		)
		ORDER BY	tfu.creation_date

get_children (Records=2, Time=0ms)
SQL = 
SELECT 	lable,
			url,
			frame_id
	FROM	tbl_feature_usage
	WHERE	parent_id = 3354
	AND		frame_id not in (3382)
	order by creation_date

get_site_id (Records=1, Time=0ms)
SQL = 
SELECT	 	site_id
	FROM	 	tbl_feature_usage
	WHERE	 	frame_id = 3354

get_frame_properties (Records=1, Time=0ms)
SQL = 
SELECT		tool_config
	FROM		tbl_feature_usage
	WHERE		frame_id = 3354
	AND			site_id = 'ftg'

qry_cat_list (Records=5, Time=15ms)
SQL = 
select 	tdc.name, 
				tdc.doc_category_id,
				tdc.doc_category_order_num,
				tdc.frame_id
		from 	tbl_docs td,
				tbl_doc_categories tdc
		where 	tdc.frame_id = 3354
		AND		tdc.status = 1
		AND		tdc.frame_id = td.frame_id
		and		td.doc_category_id in (select doc_category_id from tbl_doc_categories where frame_id = 3354)
		group by tdc.doc_category_id, tdc.name, tdc.doc_category_order_num, tdc.frame_id
		order by tdc.doc_category_order_num, tdc.name

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 15
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 15
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 15
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 16
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 16
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 16
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=15ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 17
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 17
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 17
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 18
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 18
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 18
							and		tdc.frame_id = 3354

qry_docs_num (Records=1, Time=0ms)
SQL = 
select 	Count(td.doc_id) 'count'
				from 	tbl_docs td
				where 	td.doc_category_id = 19
				and		td.frame_id = 3354

qry_cat_abstract (Records=1, Time=0ms)
SQL = 
select 	tdc.abstract
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 19
							and		tdc.frame_id = 3354

qry_cat_text (Records=1, Time=0ms)
SQL = 
select 	tdc.text
							from 	tbl_doc_categories tdc
							where 	tdc.doc_category_id = 19
							and		tdc.frame_id = 3354

qry_user_group (Records=0, Time=0ms)
SQL = 
SELECT	group_id
	FROM	tbl_user_in_grps
	WHERE	user_id = 0
	AND		group_id in (372,374)

Execution Time

1218 milliseconds

31 ms	STARTUP, PARSING, & SHUTDOWN
16 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\ACCESS_CONTROL\ORGTOOLS.CFM
15 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\CACHED_OUTPUT.CFM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\CONTENT\BROWSER_DETECT.HTM
437 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\CONTENT\CATEGORIES_INFO_IN_FRAME.CFM
16 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\CONTENT\VALIDATE_VAR_AS_INT.HTM
15 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\REPORTING\HITBOXE.CFM
16 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\REPORTING\INCLUDE_DEDUCE_TITLES.CFM
172 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SITES\FTG\FTG_INTERNAL.HTM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SITES\FTG\FTG_TOP_NAV.HTM
47 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\STRIPWHITESPACE.CFM
46 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\FRAME_CONFIG_HAS_STRUCT.HTM
203 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV.CFM
31 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV_EXTENSION\FTG_3354_SUBNAV.CFM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV_EXTENSION\FTG_3359_SUBNAV_POPUP.CFM
16 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV_EXTENSION\FTG_3360_SUBNAV_POPUP.CFM
16 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV_EXTENSION\FTG_3361_SUBNAV_POPUP.CFM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV_EXTENSION\FTG_3362_SUBNAV_POPUP.CFM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV_EXTENSION\FTG_3363_SUBNAV_POPUP.CFM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV_EXTENSION\FTG_3375_SUBNAV_POPUP.CFM
16 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\CUSTOM_TAGS\SYSTEM\ORG_NAV_EXTENSION\FTG_3812_SUBNAV_POPUP.CFM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\INCLUDES\UDF_STRING_FUNCTIONS.CFM
62 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\PLATES\STAFF_INFO\2674\STAFF_INFO.HTM
31 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\PUB\APPLICATION_BODY.HTM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\CNLIB\PUB\ONREQUESTEND_BODY.HTM
16 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\FTG\APPLICATION.CFM
0 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\FTG\ONREQUESTEND.CFM
16 ms	\\FILE1\INETPUB\WWWPROD\ORGITECTURE\WWWROOT\FTG\STAFF_INFO3357\STAFF_INFO.HTM

Parameters

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=\\file1\inetpub\wwwprod\orgitecture\wwwroot\ftg\staff_info3357\staff_info.htm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_COOKIE=CFID=14746256; CFTOKEN=35477524; CSS_SET_ID=1
HTTP_HOST=www.freetogrow.org
HTTP_REFERER=http://www.freetogrow.org/
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.0; Windows 98)
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/staff_info3357/staff_info.htm
PATH_TRANSLATED=\\file1\inetpub\wwwprod\orgitecture\wwwroot\ftg\staff_info3357\staff_info.htm
QUERY_STRING=
REMOTE_ADDR=66.243.56.98
REMOTE_HOST=66.243.56.98
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/staff_info3357/staff_info.htm
SERVER_NAME=www.freetogrow.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI