ASP Tables

liunx · Jan 10, 2008

I am using tables to view information on my website retrieved from a database. There are a few things that I'm stuck on. 
 
(1) Can you have more than 1 table on the same page. 
 
(2) How do I set the size value of a picture stored on my database. 
 
(3) My table is currently verticle. How could I make it horizontal. 
 
I would be very greatful for some help and advice. 
 
Here is the code that is on my ASP page that retrieves the information from my database (Access): 
 
 
<% 
Dim myConn, myDB 
Dim rs 
Dim SQL 
Dim searchString 
 
searchString=Request.Form("pName") 
 
SQL = "SELECT * FROM tblProfile WHERE first_name= 'terry' ORDER BY Last_Name,First_Name;" 
 
Set myConn=Server.CreateObject("ADODB.Connection") 
 
myDB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\webareas\as921\RealCyprus\fixtures.mdb" 
 
myConn.Open myDB 
 
Set rs=myConn.Execute(SQL) 
 
Response.Write("<table border='1' cellpadding='5'><tr><td></td> 
<td>First Name</td> 
<td>Surname</td> 
<td>Age</td> 
<td>Height</td> 
<td>Weight</td> 
<td>Position</td> 
<td>Foot</td> 
<td>Games</td> 
<td>Goals</td></tr>") 
 
 
while not rs.EOF%> 
 
<tr> 
<td><img src=http://www.htmlforums.com/archive/index.php/<%=rs("picture")%>></td> 
<td><%=rs("first_name")%></td> 
<td><%=rs("last_name")%></td> 
<td><%=rs("age")%></td> 
<td><%=rs("height")%></td> 
<td><%=rs("weight")%></td> 
<td><%=rs("position")%></td> 
<td><%=rs("foot")%></td> 
<td><%=rs("games")%></td> 
<td><%=rs("goals")%></td> 
</tr> 
 
 
<% rs.MoveNext 
 
wend 
%> 
</table> 
 
</BODY> 
</HTML>1) you can have as many tables as you want. when the page it done rendering it is all html anyway so whatever you do it is not asp that is stopping you. 
 
2) you can't set the size of an image until it is shown on the page. you then have to use the width and heigth in an image tag. 
 
3) why wouold you want it horizontal? that would make you page go way to the right.sorry, I meant to say my table is horizontal and I wanted it to be verticle, because it is currently way to the right. 
 
Where would I put the height and width tags in the code I have used in my original post.set your width to your table to 100%. if it is still too wide then you have to many table cells to stop it. 
 
<td><img src=http://www.htmlforums.com/archive/index.php/<%=rs("picture")%> height="whatever" width="whatever"></td> 
 
that is what you need but I do not know the image diminsions.Thanks mate, tried it and it worked.

ASP Tables

liunx

Guest