cfloop / cfquery and displaying results

[Wurst, Keith D.]

hi everyone. i have a question concerning cfloop, cfquery and how to display information most effectively on a page. here is the situation. i have two queries. the first query gets all my main topics. the second query gets all my sub topics. my where clause in my second query uses an IN statement and utilizes the valuelist of the results of the first query. in the past what i have done is just performed the first query, and then placed the second query within a cfloop of the results of the first one to display all the sub topics. this time around i want to build a result set on the fly without having to put the second query within my cfloop tag. any suggestions are greatly appreciated. thanks so much.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---