Tables from a database?

[joey o.]

Hi,
I'm trying to format all rows retrieved from a RecordSet into a table where each row and column of the Database is displayed as rows and columns in the table. This is not a problem.
Here is the challange given to me: I NEED to do this generically without writting the table tags more than once into a database. I'm hoping to do this using one row in the database containing the <Table>,<TR>,<TH>,<TD> tags and their closes, as well as a field that returns ( via ASP using "eval") the desired recordset to format located in another table. Has anyone done any work on this and is anyone willing to share? Also links on the subject are welcome.

Hi ....
rather than putting the html table tag in the Database
u can always make use of response.write .....
Bu using response.write, u can actually write once within the loop....Hope this help...


<TABLE>
<TR>
<%Do While Not rs.EOF %>
<TD><%Response.Write rs("Fieldname")%></TD>
<%rs.MoveNext%>
<%Loop%>
</TR>
</Table>



Regards,
Mac

[joey o.]

Nope,
Thanks for trying. I've got that much already but the challange is to put the formatting into a line of the database so never again do I have to write an html tag for a table on my asp pages for any site. In the end I only want to call the database, request the recordset and retrieve it preformatted in a table. I know it can be done but I'm hoping someone's been there before to offer assistance and/or direction.