Try grouping
SELECT blah from blah GROUP BY CategoryID, LnkCategoryID, etc..
You'll need to put every column you call in the group by as well but the
first two should be those. Then CFOUTPUT that query group= CategoryID
HTH
J.
John Wilker
Web Applications Consultant, and Author
Macromedia C
Try this out for size:
select CategoryID, LnkCategoryID, CategoryTitle
from tablename
where LnkCategoryID = 0
#getMainCats.CategoryTitle#
select CategoryID, LnkCategoryID, CategoryTitle
from tablename
where LnkCategoryID = #getMainCats.CategoryID#
- #getSubCats.CategoryTitl
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 12:36 AM
To: CF-Talk
Subject: RE: SQL & CF Question
Try grouping
SELECT blah from blah GROUP BY CategoryID, LnkCategoryID, etc..
You'll need to put every column you call in the group by as well but the
first two should be th
Paul,
That worked :-)
Thanks!
I am just gonna keep trying some things out to make sure this is the most
efficient way to do it.
Mike
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 12:52 AM
To: CF-Talk
Subject: Re: SQL & CF Ques
ore people are killed by donkeys than by airplane crashes each year"
-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 10:05 PM
To: CF-Talk
Subject: RE: SQL & CF Question
John.
I tried what u suggested, but it just outputs
5 matches
Mail list logo