I've got it now--if you want to see the answer it is at http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7&threadi= 261933
I'm sorry for doing a double post, but it was one of those times when I needed input quickly. -----Original Message----- From: Janine Jakim Sent: Wednesday, February 06, 2002 1:07 PM To: CF-Talk Subject: CFGrid with newquery()?/List? I asked this on the forums but still don't have an answer and wonder if someone can help. I want to use CFGRID to display information as a list/loop from a table that will have many entries. I have it working 1/2 way but can't get the one field to output the way I want it. I'd like it to be: HEADER: Reading Math Science Smith A B D Thoms B C A What I am getting is (and what is somewhat expected since there are many entries for smith): Header: Reading Math Science Smith A A A Smith B B B Smith D D D I then looked at the gridrow and had the same results. I thought about trying to make and use a list or array. The grid doesn't allow it because it's not a valid query name. Is there any way to make my grades into some type of list/flatten it then show it the way I want? I started playing with NewQuery() but couldn't get it to output anything but the first line-for exmple: Smith A I've done something similar with good results using an excel output- but the excel sheet is bulky and the users need more functionality such as asc/des. Here's the code I used for my original output. Does anyone have any ideas about this? Thanks in advance!! Sorry about the length. <CFGRID NAME="StudentGrades" QUERY="StudentGradebyQuarter" WIDTH="800" HEIGHT="500" ROWHEADERS="no" COLHEADERBOLD="YES" COLHEADERALIGN="CENTER" SELECTMODE="ROW"> <CFGRIDCOLUMN NAME="NAME" HEADER="NAME" WIDTH="100"> <CFLOOP QUERY="Skills"> <CFGRIDCOLUMN NAME="Grade" HEADER="#Skills.Skill#" WIDTH="100"> ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
