ASP 101 - Active Server Pages 101 - Web05
The Place ASP Developers Go!

Please visit our partners


Windows Technology Windows Technology
15 Seconds
4GuysFromRolla.com
ASP 101
ASP Wire
VB Forums
VB Wire
WinDrivers.com
internet.commerce internet.commerce
Partners & Affiliates














ASP 101 is an
internet.com site
ASP 101 is an internet.com site
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

ASP 101 News Flash 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>


Output

Samples
Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers