No Prob.
--K
-----Original Message-----
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 10:55 AM
To: CF-Talk
Subject: RE: outputting data in a matrix
This worked just great. Thank you.
Richard Colman
-----Original Message-----
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:55 AM
To: CF-Talk
Subject: RE: outputting data in a matrix
No offence to anyone but your all making this much more difficult than it
is.
With a little creative HTML you can do this.
<CFQUERY name="get_stuff" datasource="katrinachapman">
SELECT bookcat.Name, book.title
FROM bookcat, book
WHERE book.catid = bookcat.id
ORDER BY bookcat.name
</CFQUERY>
<TABLE>
<TR>
<CFOUTPUT query="get_stuff" group="name">
<td valign="top">
<TABLE>
<TR>
<TD><b>#name#</b>
</TD>
</TR>
<CFOUTPUT>
<TR>
<TD>#title#
</TD>
</TR>
</CFOUTPUT>
</TABLE>
</td>
</CFOUTPUT>
</TR>
</TABLE>
This is just an example but you don't need to make it more difficult than it
is. Of course you can modify this so that you only go three across or pull
a certain number of records at a time. If you'd like to see this in action
go to www.katrinachapman.com/test_group.cfm and if you need any help please
feel free to contact me off list.
--K
-----Original Message-----
From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 6:57 AM
To: CF-Talk
Subject: RE: outputting data in a matrix
Richard,
If you're comfortable with using Crystal Reports, give that a try.
~Mark
-----Original Message-----
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:28 PM
To: CF-Talk
Subject: outputting data in a matrix
Can someone suggest how to do this:
category1 category2 category3
-------- ---------- -------
item 1 item 1 item 1
item 2 item 2 item 2
item 3 item 3
item 4
where the data table looks like:
category, item, etc.
there will be an unequal number of items per category.
ideas for an approach appreciated. Thank you.
Richard Colman
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
