RE: SQL & CF Question

2002-03-14 Thread John Wilker
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

Re: SQL & CF Question

2002-03-14 Thread Paul Giesenhagen
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

RE: SQL & CF Question

2002-03-14 Thread Tangorre, Michael T.
[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

RE: SQL & CF Question

2002-03-14 Thread Tangorre, Michael T.
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

RE: SQL & CF Question

2002-03-15 Thread John Wilker
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