<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>[var..script_name] TbsSQL v3 Native Debug Console </title>
<style type="text/css">
<!--
td { font-size: 12px; }
-->
</style>
</head>
<body leftmargin=12 topmargin=12 bgcolor="#E5E5E5">
<hr color=Navy size=3>
<br>
<table width="800" border="0" cellspacing="5" cellpadding="5" align="center" bgcolor="#ffffcc">
<tr>
<td width=7 rowspan=999> </td>
<td colspan=5 align=left>   <b>Native Trace & Debug Console for TbsSQL v3.0 -- TbsSQL version [var.Db.Version] </b>
<hr>
  <font size="-2" color="#FF0000">v3 TRACE statements and query results GRID echoed to screen above. Check "Debug Console" box to see CONSOLE window</font>
</td>
<td width=7 rowspan=999> </td>
</tr>
<tr>
<td valign=top>
<table width=100% cellspacing=0 border=1 cellpadding=2>
<td width="240" height=3 bgcolor="#CACACA"><strong>Name</strong></td>
<td align=center width="100" height=3 bgcolor="#CACACA"><strong>Group</strong></td>
<td align=center width="10" height=3 bgcolor="#CACACA"><strong>eMail</strong></td>
<td align=center width="100" height=3 bgcolor="#CACACA"><strong>Phone</strong></td>
</tr>
<tr bgcolor="#E4E4E4" height=3 >
<td valign=top valign=top> <font color="Maroon"><b>[blk.name]</b></font><br>[blk.address] </td>
<td valign=top align=center > [blk.category;.;]</td>
<td valign=top align=center > [blk.email;block=tr;ondata=f_mail_cloak;htmlconv=no]</td>
<td valign=top ><div align="center"> [blk.ph_home;ifempty=not available]<br>
</div></td>
</tr>
<tr bgcolor="#F0F0F0" height=3 >
<td valign=top> <font color="Maroon"><b>[blk.name]</b></font><br>[blk.address] </td>
<td valign=top align=center> [blk.category;.;]</td>
<td valign=top align=center> [blk.email;.;block=tr;ondata=f_mail_cloak;htmlconv=no]</td>
<td valign=top><div align="center"> [blk.ph_home;ifempty=not available]<br>
</div></td>
</tr>
</table>
</td>
<td rowspan=999 valign=top>
<form action="" method="POST">
<table border="1" width=110 height=10 cellpadding="0" cellspacing="0" summary="">
<tr><td width=130>
<table border="0" width=130 cellpadding="3" cellspacing="0" summary="">
<tr><td class=left_menu bgcolor="#cccccc" align=left> View by group</td></tr>
<tr><td class=left_menu bgcolor="#F0F0F0"><input type="radio" name=category value="All" /> All</td></tr>
<tr><td class=left_menu bgcolor="#F0F0F0"><input type="radio" name=category value="[cat.category;block=tr]" /> [cat.category]s </td></tr>
<tr><td class=left_menu bgcolor="#F0F0F0" align=left>  </td></tr>
<tr><td class=left_menu bgcolor="#cccccc" align=left> Optionally show </td></tr>
<tr><td class=left_menu bgcolor="#F0F0F0"><input type="checkbox" name=debug value="DebugIt" [var.ischecked;noerr] /> Debug Console
<tr><td class=left_menu bgcolor="#F0F0F0">
</td></tr>
<tr><td class=left_menu bgcolor="#F0F0F0" align=center><br><input type="submit" name=action value="Submit"/><br /><br /></td></tr>
</table>
</td></tr>
</table>
</form>
</td>
</tr>
<!-- =================================== -->
<tr><td >
<table width="650" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td align=left style="font-size: 12px;">
Notes: <b>[1]</b> There is a 'bad query' in the script to illustrate what happens when query errors are produced<br>
Notes: <b>[2]</b> The main list is on a query that is cached for 1 min as members typically added frequently.<br>
Notes: <b>[3]</b> 'View by Group' menu is built from a query that's cached for 2 min as groups values seldom change.<br>
Notes: <b>[4]</b> Obviously, I set short time frames for the CacheTimeout to illustrate cache re-sets. <br>
Notes: <b>[5]</b> <font size="-2" color="#FF0000">Check the "Debug Console" box to see the Console, otherwise the TRACE result is echoed!! </font>
<br><br>
</td></tr>
<tr><td align=center style="font-size: 11px;">See the <u><a href="highlight_file_emailcloak_html_v3.php" target="_blank">TBS Template source</a></u> and the <u><a href="highlight_file_emailcloak_v3.php" target="_blank"> PHP code source</a></u> for your viewing pleasure</td></tr>
</table>
</td></tr>
<!-- =================================== -->
</table>
<br>
<hr color=Navy size=3>
<showme>
<br>[var.show_me;magnet=showme;htmlconv=no;noerr]
</showme>
</body>
</html>