Select count(*) where WHERE f='brown-eyes' AND somecol='big_feet' I can only guess that's what you want to do. But if this isn't it, you should probably learn proper database lingo and re-ask the question.
Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 10:52 AM To: CF-Talk Subject: RE: Matrix problem You're right. Matrix must be thowing folks off. But I'm afraid you've lost me, now. Let me try again. I'm working with a body of monthly 500 reports from which I need to distill certain information. For the report output (which will take the form of a matrix), assume column f is Brown_Eyes and assume row 5 is Big_Feet. I can easily imagine a query of the DB WHERE brown-eyes AND big_feet returns a list of 25 of the 500 db records. But what I want to do is ouput the COUNT, not a list of db records. Is this better? ------------------ Rick I don't think I understood the question. And, given that there's been no response in the last hour and a half, I suspect no one else did, either. To me, a matrix is simply an n-dimensional array where n > 1. In a 2-dimensional matrix, column f will intersect row 5 exactly once. Your query approach suggests that you are working with a matrix of n > 2. So you are looking for a count of (f, 5, x) is populated where x is the third dimension. Am I anywhere near the mark? -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -----Original Message----- : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] : Sent: Monday, March 17, 2003 8:13 AM : To: CF-Talk : Subject: Matrix problem : : : I'm not very experienced at this, but I need to create a report : that creates a matrix (the number of times where, say, column f : intersects the row 5). : : I see how I can work the query (a kind of Where F AND 5 : statement--other approaches appreciated). But I'm at a loss : about how to output it so that it counts the total number instead : of lists each incident. : : Is it done in the query or in the output? : : Rick : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
