Displaying records in multiple vertical html tables... 2

NEL3644 · Sep 4, 2000

I want to dispaly a list of records consisting of "start date", "end date", "location", and "state" as column headers...but, the information I want to display is so long. So, as not to loose vertical space, I want to be able to continue displaying the list horizontaly, i. e., have at least 2 tables (each w/ start date, end date, location, and state as headers) that continue displaying records from the same list. Here is my code that doesn't do the task:

p.S. Open for sugestions...

Code:

<TABLE CELLPADDING=&quot;0&quot; BORDER=&quot;1&quot; width=780>

<TR>
<TD>
   <TABLE width=395>
     <TD align=left width=0><B><U>Start Date</U></B></TD>
     <TD align=left width=0><B><U>End Date</U></B></TD>
     <TD align=left width=0><B><U>Location</U></B></TD>
     <TD align=left width=0><B><U>State</U></B></TD>
   </TABLE>
</TD>
<TD>
   <TABLE WIDTH=395>
     <TD align=left width=0><B><U>Start Date</U></B></TD>
     <TD align=left width=0><B><U>End Date</U></B></TD>
     <TD align=left width=0><B><U>Location</U></B></TD>
     <TD align=left width=0><B><U>State</U></B></TD>
   </TABLE>
</TD>
</TR>
					
				
<CFIF GetSessions.RecordCount GTE 1>
   <CFOUTPUT QUERY=&quot;GetSessions&quot;>
     <CFIF (Len(GetSessions.StartDate) is 8) AND (Len    (GetSessions.EndDate) is 8)>
       <TR>
         <TD align=left width=0>#Left(MonthAsString(Mid (StartDate,5,2)),3)# #Mid(StartDate,7,2)#,#Mid(StartDate,1,4)#
         </TD>
	 <TD align=left width=0>#Left(MonthAsString(Mid(EndDate,5,2)),3)# #Mid(EndDate,7,2)#,#Mid
(EndDate,1,4)#
         </TD>
	 <TD align=left width=0>#Location#</TD>
	 <TD align=left width=0>#State#</TD>	
      </TR>
    </CFIF>
  </CFOUTPUT>
</CFIF>
</TABLE>

RustyNZ · Sep 7, 2000

The main reason your code won't work is that you have closed your 2 sub tables before you try to populate them.

Instead of using 2 tables with 4 cols each, you're probably better to use a single table with 8 or 9 cols (an extra col to put some space between is useful). As you go through the query results, you will assign values alternately to the left 4 cols and the right 4 cols.
This will give you results in "across then down" order, ie:

row1 row2
row3 row4
row5 etc...

If you want "down then across" order, like the following, it's a lot harder, because a) you have to know how many rows there are before generating your first table row, so that you can start the second column half way through. This may mean running the query twice. b) You'll also need to store rows 2-122 in memory.

1 123
2 124
3 125
. .
. .
. .
121 243
122

Hope this helps get you started. [sig][/sig]

NeoTurtle · Sep 30, 2000

I have a great solution for a two colum table, but it goes down and then over to the next column. Let me know if you'd like to see how I did it.

-NeoTurtle [sig][/sig]

NEL3644 · Sep 30, 2000

If you would show me how you did it that would be great Neo!
Thankx [sig][/sig]

NeoTurtle · Oct 1, 2000

NEL . . . Here's my code . . . let me know if you have any questions.

<CFQUERY DATASOURCE="MyDBase" NAME="list">
SELECT Category, CatID
FROM Categories
ORDER BY Category
</CFQUERY>

you can probably combine this next query into the first query, but I'm not quite as SQL-literate as I'd like yet.
<CFQUERY DATASOURCE="MyDBase" NAME="count">
SELECT COUNT(*) AS CatCount
FROM Categories
</CFQUERY>
[/color]
<HTML>

<HEAD>
<LINK REL="stylesheet" HREF="MyCSS.css" TYPE="text/css">
<TITLE>2 Column Table</TITLE>
</HEAD>

<BODY BGCOLOR="FFFFFF">
<TABLE WIDTH="90%" BORDERCOLOR="000080" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="CENTER" NOWRAP STYLE="border-left-width: thin; border-right-width: thin; border-top-width: thin; border-bottom-width: thin; border-width: thin; border-color: 000080; border-style: solid;">
<TR>
<TD BGCOLOR="000080" COLSPAN="2" ALIGN="CENTER">
<FONT CLASS="Sub"><B><CFOUTPUT QUERY="count">
#CatCount# Categories:


<CFSET CatCol = #CatCount#>

<CFSET CatCol2= #CatCol# / 2>

<CFSET CatColT= #Round(CatCol2)# + 1>
</CFOUTPUT></B></FONT>
</TD>
</TR>
<TR>
<TD>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="0" CELLSPACING="0" BORDERCOLOR="FFFFFF">
<CFOUTPUT QUERY="list" MAXROWS="#Round(CatCol2)#">
<TR>
<TD WIDTH="50%" CLASS="JinMAU"
BGCOLOR="###IIF(((CurrentRow MOD 2) IS 0),DE('FFFFFF'),de('EEEECC'))#">
<A HREF="sites.cfm?CatID=#CatID#" STYLE="text-decoration: none" TITLE="#Category#">
#Category#
</A>
</TD>
</TR>
</CFOUTPUT>
</TABLE>
</TD>
<TD WIDTH="50%" VALIGN="TOP">
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="0" CELLSPACING="0" BORDERCOLOR="FFFFFF">
<CFOUTPUT QUERY="list" STARTROW="#CatColT#">
<TR>
<TD WIDTH="50%" CLASS="JinMAU"
BGCOLOR="###IIF(((CurrentRow MOD 2) IS 0),DE('EEEECC'),de('FFFFFF'))#">
<A HREF="sites.cfm?CatID=#CatID#" STYLE="text-decoration: none" TITLE="#Category#">
#Category#
</A>
</TD>
</TR>
</CFOUTPUT>
</TABLE>
</TD>
</TR>
</TABLE>

<BR>

<CFINCLUDE TEMPLATE="bottomlink.html">


</BODY>
</HTML>

Let me know if you have any questions. Although I just found a small error in the code where the row color of one side doesn't match the other side. I'm going to be looking at that error soon.

-NeoTurtle [sig][/sig]

simmerdown · Sep 5, 2002

you could just use #list.RecordCount# to get the number of records, then do the math. No need for a second query ...

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Displaying records in multiple vertical html tables... 2

NEL3644

Technical User

RustyNZ

Programmer

NeoTurtle

Programmer

NEL3644

Technical User

NeoTurtle

Programmer

simmerdown

Programmer

Similar threads

Part and Inventory Search

Sponsor