| ASP 101 News Flash |
 |
|
|
|
Sample HTML Code generated by the ASP:
<p><strong>SQL Query:</strong> SELECT * FROM [sales] ORDER BY [SalesmanId] asc;</p>
<table border="1" cellspacing="0">
<tr>
<td bgcolor="#CCCCCC"><strong>SalesmanId (<a href="?field=SalesmanId&order=asc&field=SalesmanId&order=asc">+</a> / <a href="?field=SalesmanId&order=desc&field=SalesmanId&order=asc">-</a>)</strong></td>
<td bgcolor="#CCCCCC"><strong>Timestamp (<a href="?field=Timestamp&order=asc&field=SalesmanId&order=asc">+</a> / <a href="?field=Timestamp&order=desc&field=SalesmanId&order=asc">-</a>)</strong></td>
<td bgcolor="#CCCCCC"><strong>Amount (<a href="?field=Amount&order=asc&field=SalesmanId&order=asc">+</a> / <a href="?field=Amount&order=desc&field=SalesmanId&order=asc">-</a>)</strong></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">1</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">3000</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">1</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2000</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">2</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">3250</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">2</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">3000</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">3</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1200</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">3</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2045</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">4</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1600</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">4</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">3085</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">5</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">2000</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">5</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">3290</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">6</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1520</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">6</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">4900</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">7</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1840</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">7</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2000</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">8</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1560</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">8</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2700</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">9</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">2140</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">9</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">1310</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">10</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1600</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">10</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2075</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">11</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">2150</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">11</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">3490</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">12</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1230</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">12</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2340</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">13</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1360</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">13</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">1390</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">14</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1100</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">14</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">3245</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">15</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1900</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">15</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">4810</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">16</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1340</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">16</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2710</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">17</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">1320</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">17</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">3500</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">18</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">2610</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">18</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">1355</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">19</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">3210</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">19</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2655</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">20</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">3150</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">20</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">3220</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">21</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">750</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">21</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">4000</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">22</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">420</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">22</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">4000</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">23</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">980</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">23</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">4000</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">24</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">565</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">24</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2400</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">25</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">2100</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">25</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">1690</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">26</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">2580</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">26</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">3000</td>
</tr>
<tr>
<td bgcolor="#FFFFFF">27</td>
<td bgcolor="#FFFFFF">7/23/2002 11:43:00 AM</td>
<td bgcolor="#FFFFFF">2450</td>
</tr>
<tr>
<td bgcolor="#CCCCFF">27</td>
<td bgcolor="#CCCCFF">7/24/2002 11:43:00 AM</td>
<td bgcolor="#CCCCFF">2050</td>
</tr>
</table>
|
|
