# admin-usgeospatial-one-region.tcl,v 3.0 2000/02/06 03:33:27 ron Exp
set_the_usual_form_variables
# topic required
if ![msie_p] {
set target_window "target=admin_bboard_window"
} else {
set target_window ""
}
set db [bboard_db_gethandle]
if { $db == "" } {
bboard_return_error_page
return
}
if {[bboard_get_topic_info] == -1} {
return}
if {[bboard_admin_authorization] == -1} {
return}
set sql "select bboard.*, facility, email, first_names || ' ' || last_name as name, interest_level
from bboard, users, rel_search_fac
where bboard.user_id = users.user_id
and epa_region = '$QQepa_region'
and topic_id = $topic_id
and refers_to is null
and bboard.tri_id = rel_search_fac.tri_id(+)
order by sort_key $q_and_a_sort_order"
set selection [ns_db select $db $sql]
ReturnHeaders
ns_write "
Administer $topic by Region
Administer $topic
by region"
if { $backlink != "" || $backlink_title != "" } {
ns_write " associated with
$backlink_title."
}
ns_write "
[bboard_footer]
"