Debugging Information
Execution Time
SQL Queries chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 10:13:48.048 select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup' getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 10:13:48.048 select c.misc_alpha9 tz, c2.misc_alpha tz_offset from codes c left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9) where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup' chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 10:13:48.048 select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup' getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 10:13:48.048 select c.misc_alpha9 tz, c2.misc_alpha tz_offset from codes c left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9) where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup' chkSite (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 10:13:48.048 SELECT dist_name FROM fasinfo AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 10:13:48.048 SELECT misc_alpha6 subscribe_tab, misc_alpha7 officials_tab, misc_alpha8 ordinance_tab, misc_alpha9 resolution_tab, misc_alpha11 voting_tab, misc_alpha12 useTabs from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup2' codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 10:13:48.048 select top 1 * from codes meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT mt.meeting_type, mt.descr, c.long_descr notify_public FROM meeting_type mt LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type) WHERE mt.show_public = 'Y' ORDER BY mt.descr useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y' contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 select text_value1 notify_public_contact, long_descr confLink from codes where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub' chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup' chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT c.*, c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab, c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab, c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type, c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord, c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr from codes c LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3') WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2' contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 select text_value1 notify_public_contact, long_descr confLink from codes where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub' MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 select valid_code from codes where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y' fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick, srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined FROM fasinfo getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 select fasinfo.*, c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx, c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code from fasinfo left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup') AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 select text_value1, misc_alpha public_window, loc_code allowExtNotes from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup' begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT MIN(fis_yr) fis_yr FROM fas WHERE form_id = 'AGENDA' end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT MAX(fis_yr) fis_yr FROM fas WHERE form_id = 'AGENDA' AND final_apprvl = 'Y' begin_collection (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT MIN(coll_name) coll_name FROM verity_collections ORDER BY coll_name all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT code_type FROM user_define all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order, CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr FROM codes c WHERE c.code_type = 'AG TIME' OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26') AND (opt_form_id = '' OR opt_form_id IS NULL) get_agendas (Datasource=frsRO, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:13:48.048 SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num, minutes.minutes_published, a.agenda_published, a.minutes_doc_name, a.minutes_doc_link, a.default_doc_dir, minutes.default_doc_dir minutes_default_doc_dir, a.packet_doc_name, a.packet_published, minutes.form_num as min_form_num, minutes.minutes_packet_published, minutes.minutes_packet_name, ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url, min_links.link_label as min_link_label, min_links.link_url as min_link_url, rel.large_misc_alpha as release_date, agt.meeting_type FROM meetings AS m INNER JOIN agenda AS a ON ( a.meeting_id = m.meeting_id AND (a.agenda_published = 'Y' OR a.packet_published = 'Y') ) LEFT OUTER JOIN minutes ON ( minutes.meeting_id = m.meeting_id AND (minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y') ) INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS') ) LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id) LEFT OUTER JOIN form_links AS ag_links ON ( ag_links.form_id = 'AGENDA' AND ag_links.form_num = a.form_num AND ag_links.link_seq = 1 ) LEFT OUTER JOIN form_links AS min_links ON ( min_links.form_id = 'MINUTES' AND min_links.form_num = minutes.form_num AND min_links.rev_num = minutes.rev_num AND min_links.link_seq = 1 ) WHERE m.meeting_dt >= ? AND m.meeting_dt <= ? ORDER BY m.meeting_dt DESC, m.meeting_name Query Parameter Value(s) - chk_aiDisplay (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_content.cfm @ 10:13:48.048 select case when ss_agi._rowid is null then agi.display_routine else ss_agi.display_routine end as display_routine from ag_memo am inner join agenda_ln as atl on (atl.ag_memo_id = am.form_num and atl.ag_memo_rev = am.rev_num) inner join agenda as a on (a.form_num = atl.form_num) left outer join ag_item as agi on (agi._rowid = am.ag_item_rowid) left outer join ss_ag_item as ss_agi on (ss_agi.form_num = a.form_num and ss_agi._rowid = am.ag_item_rowid) where am.form_num = ? and am.rev_num = ? Query Parameter Value(s) - codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 10:13:48.048 select top 1 * from codes qryResults (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 10:13:48.048 SELECT fas.form_id, fas.form_num fas_form_num, fas.rev_num fas_rev_num, fas.rqst_loc fas_rqst_loc, 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.date_final, fas.final_prt_date, fas.orig_loginid, meetings.meeting_dt as bo_date, de.fname, de.lname, de.title as utitle, meetings.doc_dir, meetings.meeting_name, meetings.meeting_dt, meetings.meeting_id, ag_times.descr time_descr, orig_depts.dept_desc, orig_divs.div_desc, al.ag_size, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level, al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3, al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4,al.seq_num, al._rowid line_rowid, a.text_size, a.text_font, a.print_num_ai, a.att_public, a.cont_numbering, a.att_header, a.exp_header, a.line_size, a.line_bold, a.disp_num_ai, a.ag_punct, a.disp_ainumber, a.form_num ag_form_num, a.turn_off_level_dsp, a.disp_all_lvls, a.disp_rteinfo, w.email, p.phone_no, p.phone_ext, ft.meeting_id as ai_meeting_id, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format, al._rowid AS ln_rowid, al._rowid AS agenda_ln_rowid, a.form_num AS ag_num, a.rev_num AS ag_rev, a.use_old_print_format, aa.descr ag_area_desc, asa.descr ag_subarea_desc, al.seq_vchar, 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, c1.misc_alpha7 lvl_text_size, c1.misc_alpha6 dp_level_ai, c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 left_justify_all, c2.misc_alpha2 level_descriptor, amdol.text_value amdol_more_info, amdol.text_block LinesCCCBoardOrder, ft.* FROM fas INNER JOIN ag_memo AS ft ON (fas.form_num = ft.form_num AND fas.rev_num = ft.rev_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 AND form_hist.rev_num = fas.rev_num) LEFT OUTER JOIN agenda AS a ON (ft.meeting_id = a.meeting_id) LEFT OUTER JOIN agenda_ln AS al ON (al.form_num = a.form_num AND al.ag_memo_id = ft.form_num AND al.ag_memo_rev = ft.rev_num) LEFT OUTER JOIN meetings ON (ft.meeting_id = meetings.meeting_id) LEFT OUTER JOIN websecur AS w ON (w.login_id = ft.create_by) LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id) LEFT OUTER JOIN phone AS p ON (p.empl_id = w.empl_id AND p.is_primary ='Y') LEFT OUTER JOIN codes AS ag_times ON (ag_times.code_type = 'AG TIME' AND ag_times.valid_code = ft.ag_time) LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = a.text_size) LEFT OUTER JOIN ag_area aa ON (aa.meeting_type = meetings.the_meeting_type AND aa.ag_area = ft.ag_area) LEFT OUTER JOIN area_subarea AS asa ON (asa.ag_area = ft.ag_area and asa.ag_subarea = ft.ag_subarea and asa.meeting_type = meetings.the_meeting_type) LEFT OUTER JOIN dist_dept AS orig_depts ON (ft.orig_dept = orig_depts.dept_code) LEFT OUTER JOIN dept_div AS orig_divs ON (ft.orig_dept = orig_divs.dept_code AND ft.orig_div = orig_divs.div_code) LEFT OUTER JOIN form_userdef as amdol on (amdol.form_id = fas.form_id AND amdol.form_num = ft.form_num and amdol.rev_num = ft.rev_num AND amdol.code_type = 'AMDOL') LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = ft.meeting_id) LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = meetings.the_meeting_type) WHERE UPPER(fas.form_id) = 'AG_MEMO' AND fas.form_num = ? AND fas.rev_num = ? Query Parameter Value(s) - final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 10:13:48.048 SELECT _rowid FROM ss_ag_item WHERE ss_ag_item.form_num = 585 getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 10:13:48.048 SELECT valid_code, descr, long_descr from codes WHERE code_type = 'AG_FONT' getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 10:13:48.048 SELECT long_descr from getFonts WHERE valid_code = 'mediumText' getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 10:13:48.048 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT fas.final_apprvl FROM agenda, fas WHERE agenda.meeting_id = 586 AND fas.form_id = 'AGENDA' AND fas.form_num = agenda.form_num final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT _rowid, agenda.form_num FROM ss_ag_item, agenda WHERE agenda.meeting_id = 586 AND ss_ag_item.form_num = agenda.form_num get_agi_temp (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label, c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine, agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo, agt.disp_ainumber, agt.print_num_ai , m.template_id FROM meetings m, ag_template agt, meeting_type mt INNER JOIN ss_ag_item AS agi ON (agi.form_num = 585 AND agi._rowid = 70) LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine) WHERE m.meeting_id = 586 AND agt.ag_template_id = m.template_id AND mt.meeting_type = agt.meeting_type AND agi._rowid = 70 PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters FROM codes WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N' all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.* FROM user_define ud INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 70) LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '70') WHERE form_id = 'AG_MEMO' all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date FROM codes WHERE code_type IN ('ud_fi13') AND (opt_form_id = '' OR opt_form_id IS NULL) getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num, au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan, text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols, CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy FROM agi_userdef AS au WHERE au.agi_rowid = '70' order by au.seq_num get_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value, ud.form_label, codes.descr, codes.large_misc_alpha FROM form_userdef AS u INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid) LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value) WHERE UPPER(u.form_id) = 'AG_MEMO' AND u.form_num = 2822 AND u.rev_num = 0 getfi13 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT * from get_userdef WHERE code_type = 'ud_fi13' fi13q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes WHERE code_type = 'ud_fi13' AND (obsolete = 'N' AND create_date <= ? ) ORDER BY sort_order Query Parameter Value(s) - getPXvalue (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT ee.fname + ' ' + ee.lname name, websecur.login_id, ee.title utitle, websecur.email, p.phone_no, p.phone_ext, dept.dept_desc, dept.dept_code, dd.div_code, dd.div_desc FROM websecur LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id) LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department) LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND dd.div_code = ee.division) LEFT OUTER JOIN phone AS p ON (p.empl_id = ee.empl_id AND p.is_primary = 'Y') WHERE websecur.login_id = 'ssaltzburg' items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT _rowid, seq_num, text_value FROM ag_memo_item WHERE form_num = 2822 AND rev_num = 0 ORDER BY seq_num committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT dept_code, dept_desc, review_comm FROM dist_dept ReviewCommittee (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT dept_code FROM committees WHERE review_comm = 'Y' expenditures (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure FROM ag_memo_dol WHERE ag_memo_dol.form_num = 2822 AND ag_memo_dol.rev_num = 0 ORDER BY ag_memo_dol._rowid attachments (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT _rowid ag_doc_id, ag_doc_name, ag_doc_dir, ag_doc_link, sort_seq, confidentiality ,'Y' as can_look, 'Y' as can_link FROM agenda_docs ad WHERE ad.form_num = 2822 AND ad.rev_num = 0 AND (ad.confidentiality IS NULL OR ad.confidentiality = '') ORDER BY sort_seq, ag_doc_id min_attachments (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT * from codes where code_type ='asdfasdfasfa' form_rte_stops (Datasource=frsRO, Time=21ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT _rowid stop_id, descr, form_rte.stop_id chkd_stop_id, form_rte.stop_seq FROM rte_stop LEFT OUTER JOIN form_rte ON (UPPER(form_rte.form_id) = 'AG_MEMO' AND form_rte.form_num = 2822 AND form_rte.rev_num = 0 AND form_rte.stop_id = rte_stop._rowid) WHERE UPPER(rte_grp) = 'AG_MEMO' getorig (Datasource=frsRO, Time=11ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle, w.dflt_rte_stop 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) = 'AG_MEMO' AND form_num = 2822 AND rev_num = 0 AND stat_action = 'ADD' getstatus (Datasource=frsRO, Time=47ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT (hist.seq_num - 1) stop_seq, hist.stop_id, hist.action_by apprvl_id, hist.stat_date apprvl_date, hist.stat_action, hist.stat_action apprvl_stat, rte_stop.descr, rte_stop.prt_on_routing, de.fname, de.lname, de.title, fa.incl_originator FROM form_hist hist INNER JOIN rte_stop ON (rte_stop._rowid = hist.stop_id AND rte_stop.prt_on_routing = 'Y') LEFT OUTER JOIN form_actions AS fa ON (UPPER(fa.form_id) = 'AG_MEMO' AND fa.action_cd = 'AI70') LEFT OUTER JOIN websecur AS w ON (w.login_id = hist.action_by) LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id) WHERE UPPER(hist.form_id) = 'AG_MEMO' AND hist.form_num = 2822 AND hist.rev_num = 0 AND hist.stat_type = 'H' ORDER BY seq_num agmemo_status (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 10:13:48.048 SELECT * from getStatus get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 10:13:48.048 SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct FROM meetings, agenda a WHERE meetings.meeting_id = ? AND a.meeting_id = meetings.meeting_id Query Parameter Value(s) - GetThisLine (Datasource=frsRO, Time=62ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 10:13:48.048 SELECT am.form_num fas_form_num, al._rowid ln_rowid, al.form_num, al.seq_num, al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3, al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.disp_level, am.ainumber, as1.sort_seq sort_level1, al.ag_memo_id, al.ag_memo_rev, c1.descr ag_time_descr, fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl, c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format, mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber, ai.*, 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, CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time FROM agenda_ln al INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num) LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type) 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 fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num) INNER JOIN ss_ag_item AS ai ON (ai.form_num = 585 AND ai._rowid = 70) LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time) 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))) LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id) LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size) WHERE al._rowid = 14430 chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 10:13:48.048 SELECT a.disp_level FROM agenda_ln a WHERE a.form_num = 585 AND a.ag_level1 = '10' AND (a.ag_level2 = '' OR a.ag_level2 IS NULL) AND (a.ag_level3 = '' OR a.ag_level3 IS NULL) AND (a.ag_level4 = '' OR a.ag_level4 IS NULL) AND a.header_ln = 'N' AND a.footer_ln = 'N' chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 10:13:48.048 SELECT a.disp_level FROM agenda_ln a WHERE a.form_num = 585 AND a.ag_level1 = '10' AND a.ag_level2 = '' AND (a.ag_level3 = '' OR a.ag_level3 IS NULL) AND (a.ag_level4 = '' OR a.ag_level4 IS NULL) AND a.header_ln = 'N' AND a.footer_ln = 'N' chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 10:13:48.048 SELECT a.disp_level FROM agenda_ln a WHERE a.form_num = 585 AND a.ag_level1 = '10' AND a.ag_level2 = '' AND a.ag_level3 = '' AND (a.ag_level4 = '' OR a.ag_level4 IS NULL) AND a.header_ln = 'N' AND a.footer_ln = 'N' Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 10:13:48.048 SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 10:13:48.048 SELECT use_agendaquick, use_minutes, public_verity from fasinfo count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 10:13:48.048 SELECT TOP 1 c.meeting_id FROM meetings AS m, minutes AS c WHERE c.meeting_id = m.meeting_id AND c.minutes_published = 'Y' ORDER BY m.meeting_dt count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 10:13:48.048 SELECT TOP 1 c.meeting_id FROM meetings AS m, agenda AS c WHERE c.meeting_id = m.meeting_id AND c.agenda_published = 'Y' ORDER BY m.meeting_dt 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:\inetpub\PublicPages\agenda_publish.cfm CONTENT_LENGTH=0 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=gzip, br, zstd, deflate HTTP_ACCEPT_LANGUAGE= HTTP_CONNECTION=Keep-Alive HTTP_COOKIE= HTTP_HOST=10.20.10.48:8555 HTTP_REFERER= HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=6&get_year=2017&dsp=agm&seq=2822&rev=0&ag=585&ln=14430&nseq=&nrev=&pseq=2819&prev=0 HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) LOCAL_ADDR=10.20.10.48 PATH_INFO= PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm QUERY_STRING=id=&mt=ALL&get_month=6&get_year=2017&dsp=agm&seq=2822&rev=0&ag=585&ln=14430&nseq=&nrev=&pseq=2819&prev=0 REMOTE_ADDR=10.20.230.5 REMOTE_HOST=10.20.230.5 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/agenda_publish.cfm SERVER_NAME=10.20.10.48 SERVER_PORT=8555 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/10.0 WEB_SERVER_API= Client Variables: cfid=9823963 cftoken=8c5be42789458532-17B2FCF7-E2A8-6E17-E6052812F452038A hitcount=4 lastvisit={ts '2024-05-16 10:13:48'} timecreated={ts '2024-05-16 10:13:48'} urltoken=CFID=9823963&CFTOKEN=8c5be42789458532-17B2FCF7-E2A8-6E17-E6052812F452038A Cookie Variables: CFID=9823963 CFTOKEN=8c5be42789458532-17B2FCF7-E2A8-6E17-E6052812F452038A Form Fields: ATT_TYPE=AG DISPLAY_AG=585 DISPLAY_ID=2822 DISPLAY_REV=0 Session Variables: cfid=9823963 cftoken=8c5be42789458532-17B2FCF7-E2A8-6E17-E6052812F452038A dbtype=SQLSERVER dsn=frsRO extpathprefix=/public/ isexternal=true logfilepath=d:\logs\ loggedin=false sessionid=FASPUBLIC_9823963_8c5be42789458532-17B2FCF7-E2A8-6E17-E6052812F452038A subdir=/public/ tzoffset=0 urltoken=CFID=9823963&CFTOKEN=8c5be42789458532-17B2FCF7-E2A8-6E17-E6052812F452038A URL Parameters: ag=585 dsp=agm get_month=6 get_year=2017 id= ln=14430 mt=ALL nrev= nseq= prev=0 pseq=2819 rev=0 seq=2822Debug Rendering Time: 16 ms |