Basic Databases Part 2
page 3 of 5
by Philip Q
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 23078/ 146

Step 5 : More, more, MORE!

Step 5 : More, more, MORE!

So you want more than 1 column eh? Well simply add a bit more code to the While statement.

<table border=1><tr><td><strong>Addresses</strong></td><td><strong>City</strong></tr>
<% While Not RecordSet1.EOF
Response.Write("<tr><td>")
%><%=(Recordset1.Fields.Item("Address").Value)%><%
Response.Write("</td><td>") 'Don't Finish the row yet
%><%=(Recordset1.Fields.Item("City").Value)%><% 'Put in a column with some 'more data
RecordSet1.MoveNext

Wend %>
</td></tr></table>

If you know your HTML, you see that we didn't end the row quite yet, we added another column and placed the city value there, simple, and it looks like this:


View Entire Article

User Comments

Title: Real   
Name: Rizwan
Date: 1/15/2005 4:51:56 AM
Comment:
Great! What simple real way of teaching.
Great
Many thanks to Mr. Author!

Product Spotlight
Product Spotlight 
Learn More
.NET Tools
asp.net shopping cart
asp.net chart control






Ads Powered by Lake Quincy Media
Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2008 ASPAlliance.com  |  Page Processed at 7/19/2008 10:42:43 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search