Tables

[alsjka]

Hi, is there any way of having tables come out like this in coldfusion (see below)? I need to output errors down the left side then jump back up to the top and display the data from top to bottom?

Errors|Date
1/22/04 | 1/22/05
one two two
one two two
one two two
one two two


thank you

 

[r937]

sure, just use a one-row, 3-column TABLE

in each cell, use BR to separate lines



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[alsjka]

Not sure if I am following. I am trying to do this. I am running a query I output the errors down the left side 1st.
Then I would like to come back and out put all the errors for 1/22/04 starting at the top to the bottom(i need to do math against the error numbers). Did I explain better. I am having hard time explaining this table thing?
I am not sure the 1 rom 3 column table would work?


Date
Errors 1/22/04 1/22/05

bad 1
bad 2
bad 3

 

[r937]

no, that's less clear than before

can you give some actual examples

the first time, it was two two two two two two two two

the second time it was all blanks

are you CFOUTPUTting over the same result set three times?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[TruthInSatire]

the query is going to look something like this, rudy will help if i'm wrong (probable)
<cfquery>
select yourDate, bad1, bad2, bad3, count(bad1) as countBad1, count(bad2) as countBad2, count(bad3) as countbad3
group by yourdate
</cfquery>

once you get your query straight. you'll have to loop both horazontally and vertically because your number of dates will be unknown.



If you don't ask the right questions, you don't get the right answers. A question asked in the right way often points to its own answer. Asking questions is the ABC of diagnosis. Only the inquiring mind solves problems.

-Quote by Edward Hodnett

 

[alsjka]

This is from the page. I would like to have it look like this and be able to do the math like totals. but I seem to be missing something sooo simple this morning. right now i am creating the table with information on the left (like the primary etc) then running a query to get the data on the right (the numbers) for 12/23/04. But when I create the table I end up at the bottom of the table and then the queried information start thus at the bottom of the table.
How would I go about getting my page formatted like this?
I am forgetting how to jump back up after creating the table? I hope this exaplins better.


DATE OF READING 12/23/2004
METER & LOCATION UNIT/MULT
PRIMARY METER #1-05 KWH*2625 99922
PRIMARY METER #1-07 KWH*2625 09888
PRIMARY (TOTAL) KWH*2625 109810