This is the (complete) source code for the "all sites" screen. It consists of standard html, simplified with Instant Framework replacement tags (the tags starting with _R_). The data comes from standard SQL queries embedded in Instant Framework tags. This file can be modified in minutes or created by simple cut and paste of a similar screen. Changes to the source file are visible to users instantly.

Instant Framework requires minimal coding skills to use and can be used effectively with just a basic knowledge of SQL and html. Instant Framework itself is written in Perl using the Perl CGI and DBI libraries, and can easily be ported to any platform or webserver, including Windows 2000.

_R_IFTOP
_R_NAVBAR
<div class="pagecontent">
_R_DEFAULT_START
sort = site_name
_R_DEFAULT_END
_R_OPTION_START_DELETE
delete from site where site_id = _R_SITE_ID
_R_OPTION_END_DELETE

_R_OPTION_START_SAVE
insert into site values(NULL, _R_SITE_NAME)
_R_OPTION_END_SAVE

_R_OPTION_START_UPDATE
update site set site_name = _R_SITE_NAME where site_id = _R_SITE_ID
_R_OPTION_END_UPDATE

_R_QUERY_START_ONE
select site_id, site_name
from site
order by _R_SORT
_R_QUERY_END_ONE
<H2 >All sites</H2>

<TABLE align="center" cellpadding="5">

<TR><TD><B><a href="admin?action=all_sites&sort=site_id">Site #</B></a></TD>
<TD><B><a href="admin?action=all_sites&sort=site_name">Site Name</B></a></TD>
<TD><B>Actions</B></TD>
</TR>
_R_REPEAT_START_ONE
<TR>
<TD>_R_SITE_ID</TD>
<TD>_R_SITE_NAME</TD>
<TD><a href="/cgi-bin/admin?action=all_sites&option=delete&site_id=_R_SITE_ID&sort=_R_SORT">
delete</a>&nbsp;&nbsp;&nbsp; 
<a href="/cgi-bin/admin?action=edit_site&site_id=_R_SITE_ID">edit</a>
</TD>
</TR>
_R_REPEAT_END_ONE

</TABLE>
<P align="center">Add a <a href="/cgi-bin/admin?action=new_site">new
site</a></P>
<P align="center">Return to <a href="/cgi-bin/admin">main screen</a></P>
</div>
</body></html>