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]
