BCC MEETING AGENDA
March 13, 2012
 12:30 PM
           
CALL TO ORDER - Chairman Doug Conkey
 
12:30 PRIVATE MEETING - A Private Meeting between the Board of County Commissioners and its attorneys held under the authority of Section 286.011 (8) Florida Statutes, fo the purpose of providing advice to the attorneys concerning pending litigation in which Clay County is a party.
 
INVOCATION -  Commissioner Robinson      
 
PLEDGE - Commissioner Davis                   
 
ROLL CALL
 
ARTWORK - All Schools Trading Cards
 
PET ADOPTIONS              
 
SPECIAL STAFF RECOGNITION
 
APPROVAL OF MINUTES    
 
1. BCC Meeting of February 28, 2012
 
CONSENT AGENDA
 
2. Approval of Stipulated Final Judgment for Parcel 104 of Henley Road
 
3. Approval of Stipulated Final Judgment for Parcel 45 of Henley Road
 
4. Approval of Satisfaction of SHIP Mortgage for Dana S. Josey
 
5. Approval of Subordination of SHIP Mortgage for Delector Swanigan.
 
6. Finance Business
The Finance Department business is submitted to request approval and ratification by the Board for various warrants and disbursements in order to meet the requirements of Ch. 136.06 (1), Fl Statute. Acceptance and disposal of various Board property and various documents are submitted for the Board's information. At times, approval is requested for various finance related issues.
 
7. Budget, Finance & Human Services Committee Report of March 5, 2012 (Comm. Stewart)
 
8. Economic Development Committee Report of February 27, 2012. (Comm. Cummings)
 
OLD BUSINESS - No Business
 
NEW BUSINESS
 
9. Approval of a Safety and Education Articulation Agreement for FY 11/12 between the BCC, Clay County School Board (CCSB), and the Clay County Sheriff’s Office (CCSO) to facilitate funding from the School Board to the Clay County Sheriff’s Office, through the BCC, for Youth Resource Officers and related services to the Clay County High Schools. The Clay County School Board will reimburse the Sheriff's Office in the amount of $450,000.00 for the services provided.
(M. Scruby/B. Johns)
 
10. Final Public Hearing to consider a Substantial Deviation Determinination regarding a Notice of Proposed Change (NOPC) for The Crossings at Fleming Island, Eagle Harbor at Fleming Island Joint Venture, Development of Regional Impact (DRI)
 
11. Final Public Hearing to Consider an amendment to the Development Order of The Crossings DRI, Eagle Harbor Joint Venture
 
12. Discussion on CIP.
 
COUNTY MANAGER/CLERK OF THE BOARD - No Business
 
COUNTY ATTORNEY - No Business
 
LETTERS FOR ACTION - No Letters
 
LETTERS/DOCUMENTATION (For Information/For the Record)
 
13. Fleming Island Advisory Committee Minutes of January 26, 2012
 
14. Bid Opening Tabulations for February 21, 2012
A. RFP No. 11/12-6, Broker Services

Bid Opening Tabulations for February 28, 2012
A. Bid No. 11/12-8, Highridge Estates Paving Phase I

Bid Opening Tabulations for March 6, 2012
A. Bid No. 11/12-9, Redi-Mix Concrete
 
PUBLIC COMMENTS
 
COMMISSIONERS' COMMENTS
 


Note: If any person decides to appeal any final decision made by the County Commission with respect to any matter considered at this meeting or hearing, he/she will need a record of the proceedings, and for such purpose, he/she may need to ensure that a verbatim record of the proceedings is made, which record includes the testimony and evidence upon which the appeal is to be based (F.S. 286-0105). Individuals with disabilities needing assistance to participate in any of these proceedings should contact the County Manager at least three (3) working days in advance of the meeting date and time at (904) 284-6347.

In accordance with the Americans With Disabilities Act, any person needing a special accommodation to participate in this matter should contact the Clay County ADA Coordinator by mail at Post Office Box 1366, Green Cove Springs, Florida 32043, or by telephone number (904) 269-6376, no later than three (3) days prior to the hearing or proceeding for which this notice has been given. Hearing impaired persons can access the foregoing telephone number by contacting the Florida Relay Service at 1-800-955-8770 (Voice) or 1-800-955-8771 (TDD).

Debugging Information
ColdFusion Server Standard 8,0,1,195765
Template /print_agenda.cfm
Time Stamp 14-Mar-12 01:19 AM
Locale English (US)
User Agent
Remote IP 10.200.30.25
Host Name 10.200.30.25

Execution Time

Total Time Avg Time Count Template
62 ms 62 ms 1 top level C:\Inetpub\wwwroot\print_agenda.cfm
47 ms 47 ms 1 C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm
0 ms 0 ms 1 C:\Inetpub\wwwroot\agpub_client_defines.cfm
0 ms 0 ms 1 C:\Inetpub\wwwroot\dsi_client_defines.cfm
0 ms 0 ms 1 C:\Inetpub\wwwroot\frs\agenda\agenda_utilities.cfm
0 ms 0 ms 1 CFC[ C:\Inetpub\wwwroot\frs\cfm_utilities\print_agenda.cfc | qryAgLines(645) ] from C:\Inetpub\wwwroot\frs\cfm_utilities\print_agenda.cfc
0 ms 0 ms 1 CFC[ C:\Inetpub\wwwroot\frs\cfm_utilities\print_agenda.cfc | qryAgenda(645) ] from C:\Inetpub\wwwroot\frs\cfm_utilities\print_agenda.cfc
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
62 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

all_userdef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\print_agenda.cfm @ 01:19:12.012
	SELECT code_type FROM user_define
all_codes (Datasource=frsexternal, Time=0ms, Records=10) in C:\Inetpub\wwwroot\print_agenda.cfm @ 01:19:12.012
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, dataSortOrder as sort_order,

		   c.misc_alpha2,
 		   CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type IN ('AG TIME')
	AND (opt_form_id = '' OR opt_form_id IS NULL)
qryResults (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\cfm_utilities\print_agenda.cfc @ 01:19:12.012
	SELECT fas.form_num fas_form_num, fas.action_cd fas_action_cd, fas.current_stop fas_current_stop, fas.routing_apprvl fas_routing_apprvl,
		   fas.final_apprvl fas_final_apprvl, fas.final_print fas_final_print, fas.fis_yr fas_fis_yr, fas.final_stop fas_final_stop,
		   fas.date_final fas_date_final, fas.final_prt_date fas_final_prt_date,
		   ft.* ,
		   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id, mt.meeting_type,
		   agt.ag_template_name, agt.ag_template_id, codes.long_descr px_size, codes.descr pdf_format,
		   form_hist.stat_date as bo_date,
	 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo,
	 	   c1.text_value1 pdf_header, c1.text_value2 pdf_footer, c1.misc_alpha prt_att_links,
	 	   c1.misc_alpha3 page_start, c1.misc_alpha2 info_header, c1.text_value3 all_bold
	FROM fas
	INNER JOIN agenda AS ft ON (ft.form_num = fas.form_num)
	INNER JOIN form_hist ON (	UPPER(form_hist.form_id) = fas.form_id AND
				UPPER(form_hist.stat_action) = 'ADD' AND
				form_hist.form_num = fas.form_num)
	INNER JOIN meetings AS m ON (m.meeting_id = ft.meeting_id)
	LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = ft.ag_template_id)
	LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = ft.text_size)
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = m.meeting_id)	
	WHERE UPPER(fas.form_id) = 'AGENDA' AND
				fas.form_num = 645
get_temp_vars (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\agenda\agenda_utilities.cfm @ 01:19:12.012
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = 646 AND
		      a.meeting_id = meetings.meeting_id
getFonts (Datasource=frsexternal, Time=15ms, Records=7) in C:\Inetpub\wwwroot\print_agenda.cfm @ 01:19:12.012
		SELECT valid_code, descr, long_descr from codes
		WHERE code_type = 'AG_FONT'
getLvlPdf (Datasource=, Time=0ms, Records=1) in C:\Inetpub\wwwroot\print_agenda.cfm @ 01:19:12.012
		SELECT long_descr, descr from getFonts
		WHERE valid_code = 'mediumText'
final_check (Datasource=frsexternal, Time=0ms, Records=4) in C:\Inetpub\wwwroot\frs\cfm_utilities\print_agenda.cfc @ 01:19:12.012
		SELECT _rowid
		FROM ss_ag_item
		WHERE ss_ag_item.form_num = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 645

qryResults (Datasource=frsexternal, Time=0ms, Records=34) in C:\Inetpub\wwwroot\frs\cfm_utilities\print_agenda.cfc @ 01:19:12.012
	SELECT al._rowid ln_rowid, al.form_num, al.seq_num,
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.header_ln, al.footer_ln, al.page_br,	
		   al.video_link,
		   
		   ai.box1_label, ai.disp_title, ai.box1_disp, ai.box1_publ,
		   ai.box2_label, ai.box2_disp, ai.box2_publ, ai.box3_label, ai.box3_disp, ai.box3_publ,
		   ai.box4_label, ai.box4_disp, ai.box4_publ, ai.box5_label, ai.box5_disp, ai.box5_publ,
		   ai.box6_label, ai.box6_disp, ai.box6_publ, ai.box7_label, ai.box7_disp, ai.box7_publ,
	       ai.b1_lbl_ag_disp, ai.b2_lbl_ag_disp, ai.b3_lbl_ag_disp,
		   ai.b4_lbl_ag_disp, ai.b5_lbl_ag_disp, ai.b6_lbl_ag_disp, ai.b7_lbl_ag_disp,
		   ai.box1_label, ai.box2_label, ai.box3_label,
		   ai.box4_label, ai.box5_label, ai.box6_label, ai.box7_label,
		   ai.box1_csen, ai.box2_csen, ai.box3_csen,
		   ai.box4_csen, ai.box5_csen, ai.box6_csen, ai.box7_csen,		   
		   ai.print_time, ai.time_label, ai.ainumber_label, ai.lbl_bold, ai.lbl_size, ai.lbl_underline,
		   ai.ai_exp_layer, ai.ai_exp_sort,	ai.title_label, ai.prt_title_lbl,
		   am.ag_item_rowid, am.prt_exp_agenda,
		   CASE WHEN al.header_ln = 'Y' THEN 1
		   		WHEN al.footer_ln = 'Y' THEN 3
		   		ELSE 2 END AS line_sort,
		   
		   as1.sort_seq sort_level1,
		   CASE WHEN al.ag_level2 != '' AND al.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,	
		   CASE WHEN al.ag_level3 != '' AND al.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
		   CASE WHEN al.ag_level4 != '' AND al.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,	
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN al.ag_memo_id ELSE -1 END AS sort_memo,	
		   
		   al.ag_size, al.ag_font, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
		   am.allow_comment, am.ainumber, al.ag_memo_id, al.ag_memo_rev, al.ag_line_status, c.descr status_desc, al.ag_subject, al.ag_title ag_heading,
		   al.left_justify, al.color_impact,
		   codes.long_descr px_size, codes.descr pdf_format,	   
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time,
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_title ELSE '' END as ag_title,
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_action ELSE al.ag_action END as ag_action
	FROM agenda_ln al
	LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
	
	LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = al.form_num AND ai._rowid = am.ag_item_rowid)
	
	LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = al.ag_line_status)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = al.ag_size)
	
	LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = al.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(al.ag_level1 AS binary(8)))
	LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = al.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(al.ag_level2 AS binary(8)))
	LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = al.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(al.ag_level3 AS binary(8)))
	LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = al.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(al.ag_level4 AS binary(8)))
	WHERE al.form_num = ?
	ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 645

getAgHeader (Datasource=, Time=0ms, Records=1) in C:\Inetpub\wwwroot\print_agenda.cfm @ 01:19:12.012
	select * from getAgLines where header_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getAgFooter (Datasource=, Time=0ms, Records=1) in C:\Inetpub\wwwroot\print_agenda.cfm @ 01:19:12.012
	select * from getAgLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getAgLines (Datasource=, Time=0ms, Records=32) in C:\Inetpub\wwwroot\print_agenda.cfm @ 01:19:12.012
	select * from getAgLines where header_ln <> 'Y' and footer_ln <> 'Y'
	order by line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo
getorig (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\print_agenda.cfm @ 01:19:12.012
	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle
	FROM form_hist
	LEFT OUTER JOIN websecur AS w ON (w.login_id = form_hist.action_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	WHERE UPPER(form_id) = 'AGENDA' AND form_num = 645
	AND stat_action = 'ADD'
AQLogo (Datasource=, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
		SELECT printed_logo, logo_plcmnt FROM getform
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4512 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4512 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4532 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4532 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4539 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4539 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4538 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4538 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4515 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4515 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4516 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4516 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4525 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 16 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4525 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4531 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 16 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4531 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4527 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4527 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4511 AND rev_num = 1 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and 'Y' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 2 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4511 AND
						rev_num = 1
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4540 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 12 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4540 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4541 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 12 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4541 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=15ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4542 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4542 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4526 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4526 AND
						rev_num = 0
					order by au.seq_num
items (Datasource=frsexternal, Time=0ms, Records=1) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4524 AND rev_num = 0 AND
			((seq_num = 1 and ' ' = 'Y') OR
			(seq_num = 2 and ' ' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and 'Y' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
getUserDef (Datasource=frsexternal, Time=0ms, Records=0) in C:\Inetpub\wwwroot\frs\publish\print_agenda_dsp.cfm @ 01:19:12.012
					SELECT au.field_type, au.query_name, au.fld_name,
						   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
						   codes.descr, codes.large_misc_alpha
					FROM form_userdef fu
					INNER JOIN agi_userdef AS au ON (au.agi_rowid = 1 AND
													 au.code_type = fu.code_type AND au.ag_print = 'Y')
					LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
					WHERE fu.form_id = 'ag_memo' AND
						form_num = 4524 AND
						rev_num = 0
					order by au.seq_num

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=C:\Inetpub\wwwroot\print_agenda.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
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=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.myclay.org
HTTP_REFERER=
HTTP_USER_AGENT=
PATH_INFO=/print_agenda.cfm
PATH_TRANSLATED=C:\Inetpub\wwwroot\print_agenda.cfm
QUERY_STRING=seq=645&reloaded=true
REMOTE_ADDR=10.200.30.25
REMOTE_HOST=10.200.30.25
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/print_agenda.cfm
SERVER_NAME=www.myclay.org
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Client Variables:
cfid=321029
cftoken=30157757
hitcount=1
lastvisit={ts '2012-03-14 01:19:12'}
timecreated={ts '2012-03-14 01:19:12'}
urltoken=CFID=321029&CFTOKEN=30157757

Cookie Variables:
CFID=321029
CFTOKEN=30157757

Session Variables:
cfid=321029
cftoken=30157757
dbtype=SQLSERVER
dsn=frsexternal
extpathprefix=/frs/
isexternal=true
loggedin=false
sessionid=FAS_321029_30157757
urltoken=CFID=321029&CFTOKEN=30157757

URL Parameters:
RELOADED=true
SEQ=645
Debug Rendering Time: 16 ms