Debugging Information
Execution Time
SQL Queries chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 08:23:52.052 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 @ 08:23:52.052 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 @ 08:23:52.052 SELECT dist_name FROM fasinfo AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 08:23:52.052 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 @ 08:23:52.052 select top 1 * from codes meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:23:52.052 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 @ 08:23:52.052 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 @ 08:23:52.052 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 @ 08:23:52.052 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 @ 08:23:52.052 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 @ 08:23:52.052 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 @ 08:23:52.052 select valid_code from codes where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y' fasinfo (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:23:53.053 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 @ 08:23:53.053 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 @ 08:23:53.053 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 @ 08:23:53.053 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 @ 08:23:53.053 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 @ 08:23:53.053 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 @ 08:23:53.053 SELECT code_type FROM user_define all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:23:53.053 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=16ms, Records=12) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:23:53.053 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) - codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 08:23:53.053 select top 1 * from codes checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT TOP 1 * FROM minutes_ln_vote vote getminutes (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 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.date_final, fas.final_prt_date, ft.* , m.meeting_name, m.meeting_dt, m.meeting_fromthru_time, m.meeting_id, m.meeting_loc, agt.ag_template_name, agt.ag_template_id, codes.long_descr px_size, codes.descr pdf_format, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, agt.pdf_header, agt.pdf_footer, ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size, am.long_descr vote_label, am.misc_alpha3 att_print_nametitle, am.misc_alpha4 att_print_format, am.loc_code att_title_place, am.large_misc_alpha roll_title_place FROM minutes ft INNER JOIN fas ON (fas.form_id = 'MINUTES' AND 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) 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 crt ON (crt.code_type = 'AG_FONT' and crt.valid_code = ft.roll_text_size) LEFT OUTER JOIN codes cv ON (cv.code_type = 'AG_JUST' and cv.valid_code = ft.vote_disp_position) LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_JUST' and cr.valid_code = ft.roll_disp_position) LEFT OUTER JOIN codes ct ON (ct.code_type = 'VOTE_WIDTH' and ct.valid_code = ft.vote_disp_width) LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and am.valid_code = CAST(ft.meeting_id as varchar)) LEFT OUTER JOIN codes amm ON (amm.code_type = 'AddlMtgMin' and amm.valid_code = CAST(ft.meeting_id as varchar)) WHERE ft.meeting_id = 1204 get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 08:23:53.053 SELECT 'Alpha','Alpha','Alpha','Alpha', min.ag_punct FROM meetings, minutes min WHERE meetings.meeting_id = ? AND min.meeting_id = meetings.meeting_id Query Parameter Value(s) - qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 select c.misc_alpha mHead_pad, c.misc_alpha2 mBody_pad, c.misc_alpha3 mPresent_pad, c.misc_alpha4 mAbsent_pad, c.misc_alpha5 mStaff_pad, c.misc_alpha6 mOthers_pad, c.misc_alpha7 mAGtext_pad, c.misc_alpha8 mMintext_pad, c.misc_alpha9 mMotion_pad, c.misc_alpha10 mVote_pad, c.misc_alpha11 mRollSection_pad from codes c where c.code_type = ? and c.valid_code = CAST(1204 as varchar) Query Parameter Value(s) - getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, descr, long_descr from codes WHERE code_type = 'AG_FONT' final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT _rowid FROM ss_ag_item WHERE ss_ag_item.form_num = 1203 getAllMnLines (Datasource=frsRO, Time=16ms, Records=34) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT ml._rowid ln_rowid, ml.ln_rowid ml_rowid, ml.form_num, ml.rev_num, ml.seq_num, ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.footer_ln, ml.left_justify, ml.page_br, c.descr as status_desc, ai.*, am.ag_item_rowid, CASE WHEN ml.header_ln = 'Y' THEN 1 WHEN ml.footer_ln = 'Y' THEN 3 ELSE 2 END AS line_sort, as1.sort_seq sort_level1, CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2, CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3, CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4, CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo, ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level, am.allow_comment, ml.ainumber min_ainumber, ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading, ml.header_ln, ml.footer_ln, ml.left_justify, CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time, CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_title ELSE '' END as ag_title, CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action FROM minutes_ln ml LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev) LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = 1203 AND ai._rowid = am.ag_item_rowid) LEFT OUTER JOIN codes AS c ON (c.code_type = 'MIN STATUS' AND c.valid_code = ml.ag_line_status) LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8))) LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8))) LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8))) LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8))) WHERE ml.form_num = 587 AND ml.rev_num = 0 ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo getMnLines (Datasource=, Time=15ms, Records=32) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getAllMnLines WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N' ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getAllMnLines WHERE getAllMnLines.header_ln = 'Y' ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4 getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 select * from getAllMnLines where footer_ln = 'Y' order by sort_level1, sort_level2, sort_level3, sort_level4 all_docs (Datasource=frsRO, Time=32ms, Records=53) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir, docs.confidentiality, docs.from_agenda, 'Y' can_look, 'Y' can_link , ml.form_num, ml.rev_num, ml._rowid ml_rowid, min.minutes_published min_published, a.agenda_published ag_published FROM minutes min INNER JOIN minutes_ln AS ml ON (ml.form_num = min.form_num AND ml.rev_num = min.rev_num) INNER JOIN minutes_docs AS docs ON(docs.form_num = ml.form_num AND docs.rev_num = ml.rev_num AND docs.ln_rowid = ml._rowid AND (docs.confidentiality IS NULL OR docs.confidentiality = '') ) LEFT OUTER JOIN agenda AS a ON (a.form_num = min.ag_form_num AND a.rev_num = min.ag_rev_num) WHERE min.form_num = 587 AND min.rev_num = 0 AND (docs.confidentiality IS NULL OR docs.confidentiality = '') all_minutes (Datasource=frsRO, Time=0ms, Records=23) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline FROM meeting_minutes WHERE form_num = 587 AND rev_num = 0 AND print_box = 'Y' AND meet_minutes IS NOT NULL AND (obsolete <> 'Y' OR obsolete IS NULL) allMotions (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text, motion.time_of_vote, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, c.descr status_desc FROM minutes_ln_motion motion LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = motion.motion_status) WHERE motion.form_num = 587 AND motion.rev_num = 0 AND motion.motion_status <> 'VERBIAGE' AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL) ORDER BY motion.ln_rowid, motion.motion_seq allVotes (Datasource=frsRO, Time=0ms, Records=91) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT v.ln_rowid, v.motion_seq, v.valid_code, v.vote, r.name, r.title, c2.descr vote_descr, c2.long_descr vote_type, c3.long_descr vote_label, v.seq_num sort1, CASE WHEN c2.long_descr = 'Y' THEN 1 WHEN c2.long_descr = 'N' THEN 2 ELSE 3 END AS sort2 FROM minutes_ln_vote AS v INNER JOIN minutes AS m ON (m.form_num = v.form_num AND m.rev_num = v.rev_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = v.form_num AND r.rev_num = v.rev_num AND r.valid_code = v.valid_code) LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote) LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND c3.valid_code = CAST(m.meeting_id AS varchar)) WHERE v.form_num = 587 AND v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) ORDER BY sort2, sort1 get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13620 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13620 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13617 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13617 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9009 get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13623 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13623 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13627 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13627 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13632 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13632 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3232 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13632 AND motion_seq = 2 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13632 AND allVotes.motion_seq = 2 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13618 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13618 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13645 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13645 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13646 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13646 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9011 get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13619 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13619 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13633 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13633 SortedList (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9012 getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3233 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13633 AND motion_seq = 2 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13633 AND allVotes.motion_seq = 2 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3234 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13633 AND motion_seq = 3 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13633 AND allVotes.motion_seq = 3 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3235 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13633 AND motion_seq = 4 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13633 AND allVotes.motion_seq = 4 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13634 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13634 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3236 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13634 AND motion_seq = 2 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13634 AND allVotes.motion_seq = 2 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13621 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13621 SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9014 getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3237 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13621 AND motion_seq = 2 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13621 AND allVotes.motion_seq = 2 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13635 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13635 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13636 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13636 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13622 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13622 SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9015 getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3238 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13622 AND motion_seq = 2 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13622 AND allVotes.motion_seq = 2 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13637 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13637 SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9016 getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3239 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13637 AND motion_seq = 2 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13637 AND allVotes.motion_seq = 2 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13638 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13638 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13639 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13639 SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9018 getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3241 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13639 AND motion_seq = 2 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13639 AND allVotes.motion_seq = 2 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13624 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13624 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13640 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13640 SortedList (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9020 getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3242 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13640 AND motion_seq = 2 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13640 AND allVotes.motion_seq = 2 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9021 getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3243 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13640 AND motion_seq = 4 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13640 AND allVotes.motion_seq = 4 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13647 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13647 SortedList (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9039 getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9022 getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3244 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13647 AND motion_seq = 3 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13647 AND allVotes.motion_seq = 3 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' getMinutesNow (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9023 get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13649 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13649 SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9040 getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9024 getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id, motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc, r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle, motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion FROM minutes_ln_motion motion INNER JOIN minutes ft ON (ft.form_num = motion.form_num) LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND r.rev_num = motion.rev_num AND r.valid_code = motion.motion_id) LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND r2.rev_num = motion.rev_num AND r2.valid_code = motion.second_id) LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar)) WHERE motion._rowid = 3245 motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM getmotions WHERE ln_rowid = 13649 AND motion_seq = 3 getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label FROM allVotes WHERE allVotes.ln_rowid = 13649 AND allVotes.motion_seq = 3 fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N' ORDER BY dataSortOrder fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:23:53.053 SELECT descr, misc_alpha, misc_alpha2, misc_alpha4 FROM codes WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13644 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13644 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13643 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13643 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9025 get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13630 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13630 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9026 get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13629 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13629 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13641 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13641 SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9041 getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9027 get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13631 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13631 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13648 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13648 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9028 get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13642 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13642 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9029 get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13625 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13625 SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from meeting_minutes WHERE meeting_minutes._rowid = 9030 get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM all_minutes WHERE ln_rowid = 13626 AND meet_minutes <> '' ORDER BY seq_num get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * FROM allMotions WHERE allMotions.ln_rowid = 13626 SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:23:53.053 SELECT * from sortList ORDER BY seqNum Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:23:53.053 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 @ 08:23:53.053 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 @ 08:23:53.053 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 @ 08:23:53.053 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=CFID=9898805; CFTOKEN=4d17ba5e32e7f8b2%2DAE3F5088%2D9AF3%2D8CD9%2D5C191BC75D4FB86C HTTP_HOST=10.20.10.48:8555 HTTP_REFERER= HTTP_URL=//agenda_publish.cfm?id=&mt=ALL&get_month=1&get_year=2021&dsp=min&min=1204&ln=13635 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=2021&dsp=min&min=1204&ln=13635 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=9898805 cftoken=4d17ba5e32e7f8b2-AE3F5088-9AF3-8CD9-5C191BC75D4FB86C hitcount=44 lastvisit={ts '2024-05-19 08:23:52'} timecreated={ts '2024-05-19 08:23:46'} urltoken=CFID=9898805&CFTOKEN=4d17ba5e32e7f8b2-AE3F5088-9AF3-8CD9-5C191BC75D4FB86C Cookie Variables: CFID=9898805 CFTOKEN=4d17ba5e32e7f8b2-AE3F5088-9AF3-8CD9-5C191BC75D4FB86C Form Fields: ATT_TYPE=AG DISPLAY_ID=1204 Session Variables: ailist=Query (21) cfid=9898805 cftoken=4d17ba5e32e7f8b2-AE3F5088-9AF3-8CD9-5C191BC75D4FB86C dbtype=SQLSERVER dsn=frsRO extpathprefix=/public/ isexternal=true logfilepath=d:\logs\ loggedin=false sessionid=FASPUBLIC_9898805_4d17ba5e32e7f8b2-AE3F5088-9AF3-8CD9-5C191BC75D4FB86C subdir=/public/ tzoffset=0 urltoken=CFID=9898805&CFTOKEN=4d17ba5e32e7f8b2-AE3F5088-9AF3-8CD9-5C191BC75D4FB86C URL Parameters: dsp=min get_month=1 get_year=2021 id= ln=13635 min=1204 mt=ALLDebug Rendering Time: 0 ms |