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

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: 2005-01-15 4:51:56 AM
Comment:
Great! What simple real way of teaching.
Great
Many thanks to Mr. Author!

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-04-25 6:56:10 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search