Debugging Information
Execution Time
SQL Queries chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 06:51:14.014 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 @ 06:51:14.014 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=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 06:51:14.014 SELECT dist_name FROM fasinfo AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 06:51:14.014 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 @ 06:51:14.014 select top 1 * from codes meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 SELECT MAX(fis_yr) fis_yr FROM fas WHERE form_id = 'AGENDA' AND final_apprvl = 'Y' begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:51:14.014 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 @ 06:51:14.014 SELECT code_type FROM user_define all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:51:14.014 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=15ms, Records=10) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:51:14.014 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) - pageTitle (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT menu_label FROM fas_menu WHERE web_page = '../fas/term_report.cfm' fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * FROM fasinfo get_fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT use_minutes, use_agendaquick, term_remind_days, c.misc_alpha4 hosted FROM fasinfo LEFT OUTER JOIN codes c ON (c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup') checkCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from codes WHERE code_type = 'FORM_ID' AND valid_code = 'AG_MEMO' getMeetingTypes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 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' and c.misc_alpha15 = 'Y' AND CAST(mt.pdf_header as varchar) <> 'N' ORDER BY mt.descr getRecs (Datasource=frsRO, Time=16ms, Records=194) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 select tt._rowid tt_rowid, tt.*, codes.long_descr, codes.dataSortOrder, mt.descr from codes, term_tracker tt INNER JOIN meeting_type mt ON (mt.meeting_type = tt.meeting_type AND mt.obsolete <> 'Y') where codes._rowid = tt.code_rowid and codes.code_type = 'AG_OFF' and tt.term_end >= ? order by tt.meeting_type, tt.lname, tt.fname Query Parameter Value(s) - getRecsCount (Datasource=, Time=0ms, Records=194) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs getRecs2 (Datasource=, Time=0ms, Records=194) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs getForm (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT t.*, CASE WHEN t.ag_punct = '' THEN 'None' WHEN t.ag_punct = 's' THEN ') close paren' WHEN t.ag_punct = 'd' THEN '( ) open/close parens' WHEN t.ag_punct = 'p' THEN '. period' ELSE '' END AS ag_punct_descr, ? meeting_dt, NULL meeting_fromthru_time, NULL meeting_name,t.ag_template_id meeting_id, ait.item_text dflt_ai_template, ait.print_time, dl.long_desc, mt.logo_plcmnt, mt.printed_logo, mt.descr, c.descr text_font_descr, cc.long_descr px_size, cc.descr pdf_format, c1.misc_alpha prt_att_links, c1.misc_alpha2 info_header, c1.misc_alpha3 page_start, c1.text_value3 all_bold, c1.misc_alpha4 use_spec_instr, c1.loc_code use_purge_comments, c1.descr level_in_bookmark , c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, c1.misc_alpha10 printMinutes FROM ag_template t LEFT OUTER JOIN ag_item AS ait ON (ait._rowid = t.ag_item_rowid) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = t.meeting_type) LEFT OUTER JOIN dist_loc AS dl ON (dl.loc = t.meeting_loc) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG_FONTTYPE' AND c.valid_code = t.text_font) LEFT OUTER JOIN codes AS cc ON (cc.code_type = 'AG_FONT' and cc.valid_code = t.text_size) left outer JOIN codes AS c1 ON (c1.code_type = 'AddlAQ' AND c1.valid_code = t.ag_template_id) WHERE t.meeting_type = 'BOA' Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 SELECT valid_code, descr, long_descr from codes WHERE code_type = 'AG_FONT' getLvlPdf (Datasource=, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 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 @ 06:51:14.014 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' getRecs (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs2 WHERE meeting_type = 'BOA' getTermDays (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT c.text_value2 FROM codes c WHERE c.code_type = 'TERM_DAYS' AND c.valid_code = 'BOA' getForm (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT t.*, CASE WHEN t.ag_punct = '' THEN 'None' WHEN t.ag_punct = 's' THEN ') close paren' WHEN t.ag_punct = 'd' THEN '( ) open/close parens' WHEN t.ag_punct = 'p' THEN '. period' ELSE '' END AS ag_punct_descr, ? meeting_dt, NULL meeting_fromthru_time, NULL meeting_name,t.ag_template_id meeting_id, ait.item_text dflt_ai_template, ait.print_time, dl.long_desc, mt.logo_plcmnt, mt.printed_logo, mt.descr, c.descr text_font_descr, cc.long_descr px_size, cc.descr pdf_format, c1.misc_alpha prt_att_links, c1.misc_alpha2 info_header, c1.misc_alpha3 page_start, c1.text_value3 all_bold, c1.misc_alpha4 use_spec_instr, c1.loc_code use_purge_comments, c1.descr level_in_bookmark , c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, c1.misc_alpha10 printMinutes FROM ag_template t LEFT OUTER JOIN ag_item AS ait ON (ait._rowid = t.ag_item_rowid) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = t.meeting_type) LEFT OUTER JOIN dist_loc AS dl ON (dl.loc = t.meeting_loc) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG_FONTTYPE' AND c.valid_code = t.text_font) LEFT OUTER JOIN codes AS cc ON (cc.code_type = 'AG_FONT' and cc.valid_code = t.text_size) left outer JOIN codes AS c1 ON (c1.code_type = 'AddlAQ' AND c1.valid_code = t.ag_template_id) WHERE t.meeting_type = 'CCCSMWS' Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' getRecs (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs2 WHERE meeting_type = 'CCCSMWS' getTermDays (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT c.text_value2 FROM codes c WHERE c.code_type = 'TERM_DAYS' AND c.valid_code = 'CCCSMWS' getForm (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT t.*, CASE WHEN t.ag_punct = '' THEN 'None' WHEN t.ag_punct = 's' THEN ') close paren' WHEN t.ag_punct = 'd' THEN '( ) open/close parens' WHEN t.ag_punct = 'p' THEN '. period' ELSE '' END AS ag_punct_descr, ? meeting_dt, NULL meeting_fromthru_time, NULL meeting_name,t.ag_template_id meeting_id, ait.item_text dflt_ai_template, ait.print_time, dl.long_desc, mt.logo_plcmnt, mt.printed_logo, mt.descr, c.descr text_font_descr, cc.long_descr px_size, cc.descr pdf_format, c1.misc_alpha prt_att_links, c1.misc_alpha2 info_header, c1.misc_alpha3 page_start, c1.text_value3 all_bold, c1.misc_alpha4 use_spec_instr, c1.loc_code use_purge_comments, c1.descr level_in_bookmark , c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, c1.misc_alpha10 printMinutes FROM ag_template t LEFT OUTER JOIN ag_item AS ait ON (ait._rowid = t.ag_item_rowid) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = t.meeting_type) LEFT OUTER JOIN dist_loc AS dl ON (dl.loc = t.meeting_loc) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG_FONTTYPE' AND c.valid_code = t.text_font) LEFT OUTER JOIN codes AS cc ON (cc.code_type = 'AG_FONT' and cc.valid_code = t.text_size) left outer JOIN codes AS c1 ON (c1.code_type = 'AddlAQ' AND c1.valid_code = t.ag_template_id) WHERE t.meeting_type = 'CCMTGF' Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 SELECT valid_code, descr, long_descr from codes WHERE code_type = 'AG_FONT' getLvlPdf (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 SELECT long_descr from getFonts WHERE valid_code = '' getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' getRecs (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs2 WHERE meeting_type = 'CCMTGF' getTermDays (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT c.text_value2 FROM codes c WHERE c.code_type = 'TERM_DAYS' AND c.valid_code = 'CCMTGF' getForm (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT t.*, CASE WHEN t.ag_punct = '' THEN 'None' WHEN t.ag_punct = 's' THEN ') close paren' WHEN t.ag_punct = 'd' THEN '( ) open/close parens' WHEN t.ag_punct = 'p' THEN '. period' ELSE '' END AS ag_punct_descr, ? meeting_dt, NULL meeting_fromthru_time, NULL meeting_name,t.ag_template_id meeting_id, ait.item_text dflt_ai_template, ait.print_time, dl.long_desc, mt.logo_plcmnt, mt.printed_logo, mt.descr, c.descr text_font_descr, cc.long_descr px_size, cc.descr pdf_format, c1.misc_alpha prt_att_links, c1.misc_alpha2 info_header, c1.misc_alpha3 page_start, c1.text_value3 all_bold, c1.misc_alpha4 use_spec_instr, c1.loc_code use_purge_comments, c1.descr level_in_bookmark , c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, c1.misc_alpha10 printMinutes FROM ag_template t LEFT OUTER JOIN ag_item AS ait ON (ait._rowid = t.ag_item_rowid) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = t.meeting_type) LEFT OUTER JOIN dist_loc AS dl ON (dl.loc = t.meeting_loc) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG_FONTTYPE' AND c.valid_code = t.text_font) LEFT OUTER JOIN codes AS cc ON (cc.code_type = 'AG_FONT' and cc.valid_code = t.text_size) left outer JOIN codes AS c1 ON (c1.code_type = 'AddlAQ' AND c1.valid_code = t.ag_template_id) WHERE t.meeting_type = 'CCSWS' Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 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 @ 06:51:14.014 SELECT long_descr from getFonts WHERE valid_code = 'mediumText' getPXvalue (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' getRecs (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs2 WHERE meeting_type = 'CCSWS' getForm (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT t.*, CASE WHEN t.ag_punct = '' THEN 'None' WHEN t.ag_punct = 's' THEN ') close paren' WHEN t.ag_punct = 'd' THEN '( ) open/close parens' WHEN t.ag_punct = 'p' THEN '. period' ELSE '' END AS ag_punct_descr, ? meeting_dt, NULL meeting_fromthru_time, NULL meeting_name,t.ag_template_id meeting_id, ait.item_text dflt_ai_template, ait.print_time, dl.long_desc, mt.logo_plcmnt, mt.printed_logo, mt.descr, c.descr text_font_descr, cc.long_descr px_size, cc.descr pdf_format, c1.misc_alpha prt_att_links, c1.misc_alpha2 info_header, c1.misc_alpha3 page_start, c1.text_value3 all_bold, c1.misc_alpha4 use_spec_instr, c1.loc_code use_purge_comments, c1.descr level_in_bookmark , c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, c1.misc_alpha10 printMinutes FROM ag_template t LEFT OUTER JOIN ag_item AS ait ON (ait._rowid = t.ag_item_rowid) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = t.meeting_type) LEFT OUTER JOIN dist_loc AS dl ON (dl.loc = t.meeting_loc) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG_FONTTYPE' AND c.valid_code = t.text_font) LEFT OUTER JOIN codes AS cc ON (cc.code_type = 'AG_FONT' and cc.valid_code = t.text_size) left outer JOIN codes AS c1 ON (c1.code_type = 'AddlAQ' AND c1.valid_code = t.ag_template_id) WHERE t.meeting_type = 'CCWS' Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' getRecs (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs2 WHERE meeting_type = 'CCWS' getTermDays (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT c.text_value2 FROM codes c WHERE c.code_type = 'TERM_DAYS' AND c.valid_code = 'CCWS' getForm (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT t.*, CASE WHEN t.ag_punct = '' THEN 'None' WHEN t.ag_punct = 's' THEN ') close paren' WHEN t.ag_punct = 'd' THEN '( ) open/close parens' WHEN t.ag_punct = 'p' THEN '. period' ELSE '' END AS ag_punct_descr, ? meeting_dt, NULL meeting_fromthru_time, NULL meeting_name,t.ag_template_id meeting_id, ait.item_text dflt_ai_template, ait.print_time, dl.long_desc, mt.logo_plcmnt, mt.printed_logo, mt.descr, c.descr text_font_descr, cc.long_descr px_size, cc.descr pdf_format, c1.misc_alpha prt_att_links, c1.misc_alpha2 info_header, c1.misc_alpha3 page_start, c1.text_value3 all_bold, c1.misc_alpha4 use_spec_instr, c1.loc_code use_purge_comments, c1.descr level_in_bookmark , c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, c1.misc_alpha10 printMinutes FROM ag_template t LEFT OUTER JOIN ag_item AS ait ON (ait._rowid = t.ag_item_rowid) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = t.meeting_type) LEFT OUTER JOIN dist_loc AS dl ON (dl.loc = t.meeting_loc) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG_FONTTYPE' AND c.valid_code = t.text_font) LEFT OUTER JOIN codes AS cc ON (cc.code_type = 'AG_FONT' and cc.valid_code = t.text_size) left outer JOIN codes AS c1 ON (c1.code_type = 'AddlAQ' AND c1.valid_code = t.ag_template_id) WHERE t.meeting_type = 'HOUS' Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' getRecs (Datasource=, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs2 WHERE meeting_type = 'HOUS' getTermDays (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT c.text_value2 FROM codes c WHERE c.code_type = 'TERM_DAYS' AND c.valid_code = 'HOUS' getForm (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT t.*, CASE WHEN t.ag_punct = '' THEN 'None' WHEN t.ag_punct = 's' THEN ') close paren' WHEN t.ag_punct = 'd' THEN '( ) open/close parens' WHEN t.ag_punct = 'p' THEN '. period' ELSE '' END AS ag_punct_descr, ? meeting_dt, NULL meeting_fromthru_time, NULL meeting_name,t.ag_template_id meeting_id, ait.item_text dflt_ai_template, ait.print_time, dl.long_desc, mt.logo_plcmnt, mt.printed_logo, mt.descr, c.descr text_font_descr, cc.long_descr px_size, cc.descr pdf_format, c1.misc_alpha prt_att_links, c1.misc_alpha2 info_header, c1.misc_alpha3 page_start, c1.text_value3 all_bold, c1.misc_alpha4 use_spec_instr, c1.loc_code use_purge_comments, c1.descr level_in_bookmark , c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, c1.misc_alpha10 printMinutes FROM ag_template t LEFT OUTER JOIN ag_item AS ait ON (ait._rowid = t.ag_item_rowid) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = t.meeting_type) LEFT OUTER JOIN dist_loc AS dl ON (dl.loc = t.meeting_loc) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG_FONTTYPE' AND c.valid_code = t.text_font) LEFT OUTER JOIN codes AS cc ON (cc.code_type = 'AG_FONT' and cc.valid_code = t.text_size) left outer JOIN codes AS c1 ON (c1.code_type = 'AddlAQ' AND c1.valid_code = t.ag_template_id) WHERE t.meeting_type = 'OSC' Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' getRecs (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs2 WHERE meeting_type = 'OSC' getTermDays (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT c.text_value2 FROM codes c WHERE c.code_type = 'TERM_DAYS' AND c.valid_code = 'OSC' getForm (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT t.*, CASE WHEN t.ag_punct = '' THEN 'None' WHEN t.ag_punct = 's' THEN ') close paren' WHEN t.ag_punct = 'd' THEN '( ) open/close parens' WHEN t.ag_punct = 'p' THEN '. period' ELSE '' END AS ag_punct_descr, ? meeting_dt, NULL meeting_fromthru_time, NULL meeting_name,t.ag_template_id meeting_id, ait.item_text dflt_ai_template, ait.print_time, dl.long_desc, mt.logo_plcmnt, mt.printed_logo, mt.descr, c.descr text_font_descr, cc.long_descr px_size, cc.descr pdf_format, c1.misc_alpha prt_att_links, c1.misc_alpha2 info_header, c1.misc_alpha3 page_start, c1.text_value3 all_bold, c1.misc_alpha4 use_spec_instr, c1.loc_code use_purge_comments, c1.descr level_in_bookmark , c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, c1.misc_alpha10 printMinutes FROM ag_template t LEFT OUTER JOIN ag_item AS ait ON (ait._rowid = t.ag_item_rowid) LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = t.meeting_type) LEFT OUTER JOIN dist_loc AS dl ON (dl.loc = t.meeting_loc) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG_FONTTYPE' AND c.valid_code = t.text_font) LEFT OUTER JOIN codes AS cc ON (cc.code_type = 'AG_FONT' and cc.valid_code = t.text_size) left outer JOIN codes AS c1 ON (c1.code_type = 'AddlAQ' AND c1.valid_code = t.ag_template_id) WHERE t.meeting_type = 'PZ' Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 06:51:14.014 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 @ 06:51:14.014 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 @ 06:51:14.014 SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText' getRecs (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT * from getRecs2 WHERE meeting_type = 'PZ' getTermDays (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\fas\term_publish.cfm @ 06:51:14.014 SELECT c.text_value2 FROM codes c WHERE c.code_type = 'TERM_DAYS' AND c.valid_code = 'PZ' 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=CFID=9897268; CFTOKEN=9451b002d6fa58f8%2DAAED7922%2DD220%2D779D%2DB291B6670BEB2F78 HTTP_HOST=10.20.10.48:8555 HTTP_REFERER= HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=1&get_year=2017&term=y 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=1&get_year=2017&term=y 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=9897268 cftoken=9451b002d6fa58f8-AAED7922-D220-779D-B291B6670BEB2F78 hitcount=86 lastvisit={ts '2024-05-19 06:51:14'} timecreated={ts '2024-05-19 06:50:57'} urltoken=CFID=9897268&CFTOKEN=9451b002d6fa58f8-AAED7922-D220-779D-B291B6670BEB2F78 Cookie Variables: CFID=9897268 CFTOKEN=9451b002d6fa58f8-AAED7922-D220-779D-B291B6670BEB2F78 Form Fields: FROMDATE={ts '2023-05-19 06:51:14'} MODE= TODATE={ts '2024-05-19 06:51:14'} Session Variables: ailist=Query (11) cfid=9897268 cftoken=9451b002d6fa58f8-AAED7922-D220-779D-B291B6670BEB2F78 dbtype=SQLSERVER dsn=frsRO extpathprefix=/public/ isexternal=true logfilepath=d:\logs\ loggedin=false sessionid=FASPUBLIC_9897268_9451b002d6fa58f8-AAED7922-D220-779D-B291B6670BEB2F78 subdir=/public/ tzoffset=0 urltoken=CFID=9897268&CFTOKEN=9451b002d6fa58f8-AAED7922-D220-779D-B291B6670BEB2F78 URL Parameters: get_month=1 get_year=2017 id= mt=ALL term=yDebug Rendering Time: 0 ms |