use the SQL Luke!  LOL!  Yeah, try building SQL to do this, you can then use the GROUP attribute of cfoutput to display it correctly.  


a result set like this
blk,sm,10
blk,med,15
blk,lg,20
wht,sm,10
wht,med,15
wht,lg,20


can be displayed as
blk,10,15,20
wht,10,15,20

Doug

-----Original Message-----
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 1:07 PM
To: CF-Talk
Subject: Structs Question

I was wondering if someone would be willing to point me to a good reference for building structs from queries. I have a product catalog that I am working on, and I think that I need to use a struct to get this to display correctly. The out put will look like this:

First row will contain an empty cell, then x number of cells that represent sizes (sm-4xl)
next row, first cell will have a color, then the price for each size of that color under the corresponding size.

Thanks,

Bruce
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to