Dynamic tables

soulfly73 · November 17th, 2008, 05:32 PM

Hello All,

I've posted the question before, I'm having much trouble finding a solution for the following. I have an table in which I want to put records from a query. For each record I want to build the table with a max of 4 in a row, after the forth starting an new row.. The table has to be dynamicly build.
I found a lot of examples for single tables but none for the table I have in mind, that could be off course that it is impossible. But personally I thnk it could work. I just don't know how.

Is there anyone of you that can help me?
Thanks in advance..

Code:

<div align="center">
    <table border="0" cellpadding="0" style="border-collapse: collapse" width="168" id="table30">
        <tr>
            <td width="168">&nbsp;</td>
        </tr>
        <tr>
            <td width="168">
            <table border="0" cellpadding="0" style="border-collapse: collapse" width="150" id="table31">
                <tr>
                    <td height="100">
                    &nbsp;</td>
                </tr>
                <tr>
                    <td bgcolor="#A5A5A5" style="font-family: Arial Narrow; color: #FFFFFF; font-size: 12px; font-weight: bold; text-align: left; text-transform: uppercase" height="40">
                    <table border="0" cellpadding="0" style="border-collapse: collapse" width="100%" id="table35" height="100%">
                        <tr>
                            <td width="5">&nbsp;</td>
                            <td style="text-align: left; font-family: Arial Narrow; font-size: 12PX; text-transform: uppercase; color: #FFFFFF; font-weight: bold">
                            &nbsp;</td>
                        </tr>
                    </table>
                    </td>
                </tr>
            </table>
            </td>
        </tr>
        <tr>
            <td width="168">&nbsp;</td>
        </tr>
        </table>
</div>

Old Pedant · November 17th, 2008, 06:07 PM

Why do you want a separate <TABLE> for each record??? And then another <TABLE> inside of that, no less???

Haven't you heard that tables are passe? Time to move on to CSS based formats?

You don't show any ASP code to base my answer on, but in any case the basic code is simple enough.

*IF* I understand what you are after, something like this:

Code:

<div align="center">
<table border="0" cellpadding="0" style="border-collapse: collapse" width="168" id="table30">
<tr>


    <td colspan=4>&nbsp;</td>
</tr>
<%
Set RS = yourConnection.Execute( yourSqlQuery )
For Row = 1 To 999999 
    If RS.EOF Then Exit For ' quit when no more records
    Response.Write "<tr>" & vbNewLine ' start a new row   
    For Column = 1 To 4 ' as you asked for
        If RS.EOF Then Exit For ' quit when no more records
%>
    <td width="168">
        <table border="0" cellpadding="0" style="border-collapse: collapse" width="150" id="table31">
        <tr>

            <td height="100">&nbsp;</td>
        </tr>
        <tr>

            <td bgcolor="#A5A5A5" style="font-family: Arial Narrow; color: #FFFFFF; font-size: 12px; font-weight: bold; text-align: left; text-transform: uppercase" height="40">
                <table border="0" cellpadding="0" style="border-collapse: collapse" width="100%" id="table35" height="100%">
                <tr>

                    <td width="5">&nbsp;</td>
                    <td style="text-align: left; font-family: Arial Narrow; font-size: 12PX; text-transform: uppercase; color: #FFFFFF; font-weight: bold">
                            &nbsp;</td>
                </tr>
                </table>
            </td>
        </tr>
        </table>
    </td>
<%
        RS.MoveNext
    Next ' next column
    Response.Write "</TR>" & vbNewLine ' next outer row
Next ' next row
RS.Close
%>
<tr>


    <td colspan=4>&nbsp;</td>
</tr>
</table>
</div>

Old Pedant · November 17th, 2008, 06:09 PM

Really really seems strange to me that you are going to have rows with content that will be only
40 pixels high and then you are going to separate them by blank rows 100 pixels high. Weird.

Old Pedant · November 17th, 2008, 07:06 PM

I *have* to ask.

How come you use
style="border-collapse: collapse"
when you don't have any borders to *be* collapsed??? You consistently use border=0, so what is the point??