On Wed, 15 Sep 2004 06:23:25 -0700 (PDT), Al Everett wrote:
>
> <cfoutput query="qArticleByIndustry" group="indus_name">
> #indus_name#<br>
> <cfoutput query="qArticleByIndustry">
> <blockquote>
> #article_title# - #DateFormat(article_date,"mmmm, yyyy")#<br>
> </blockquote>
> </cfoutput>
> </cfoutput>
Don't you mean "group" rather than "query" on the inner CFOUTPUT?
Oh, and why not use a JOIN rather than doing it in the WHERE?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Trouble with Two Table Query - Doh! Les Mizzell
- Re: Trouble with Two Table Query - Doh! Al Everett
- Re: Trouble with Two Table Query - Doh! Philip Arnold
- Re: Trouble with Two Table Query - Doh! Al Everett