I have a database with (amongst other things) a table:
tblProduct
ProductDescription and GroupCode
another table:
tblGroup
GroupCode and GroupDescription
The database is updated regularly
there are 31 GroupCodes but sometimes (and this varies) one or more
GroupCodes have zero ProductDescriptions in them
I want to be able to have a list of GroupCodes
but only show the GroupCodes which actually have records
I'm sure there must be a way to do this with cfloop but
I can't see how to do it
Can anyone help please
Seamus
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists