Paul I think you want DISTINCT, not GROUP BY
SELECT DISTINCT categoryID, subcatID FROM tblItems Where CategoryIDFK = #url.categoryID# Is that right? Nick ----- Original Message ----- From: "Paul Swingewood" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 19, 2004 5:45 PM Subject: [ cf-dev ] OT SQL Group By > Hi all working from home at the moment hence the hotmail email address. > > Can anyone help me with this please before I lose my mind (further than I > have already) > > I have this query > > <cfif #url.categoryID# eq 1> > <!--- FOOTWEAR ---> > <cfquery name="getsubcat" datasource ="#application.dsn#"> > SELECT FKcategoryID, subcatID FROM tblItems > Where CategoryIDFK = #url.categoryID# > GROUP BY subcatID > > </cfquery> > </cfif> > > The GROUP BY won't work. Aghhh! - Its driving me nuts > > Table looks something klike this > FKcategoryID subcatID > 1 1 > 1 1 > 1 1 > 1 1 > 1 2 > 1 2 > 1 2 > 1 3 > 1 3 > 2 4 > 2 4 > 2 4 > > > I want to bring back 1,2,3 when the FKcategoryID = 1 > > Regards - Paul (working on a Saturday afternoon - unheard of) > > _________________________________________________________________ > Stay in touch with absent friends - get MSN Messenger > http://www.msn.co.uk/messenger > > > -- > These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
