I did indeed - multiple tables, single query of only the related data, instead of multiples instances of the second query (or some type of looping and comparison to only display what you want). This may be a bit outside of what you were originally asking, but was the first thing that jumped out at me as I read your question.
On 3/12/07, Mik Muller <[EMAIL PROTECTED]> wrote: > I think he meant use a single query to join the tables through code, rather > than two statements. > > > > At 05:07 PM 3/12/2007, you wrote: > >If by join the tables you mean make it one table I'm sure that can't be done > >without a HUGE rewrite of the code that drops data into and reads data out > >of those two separate tables. And I'm not even up to this task let alone a > >complete overhaul of the system... > > > >-----Original Message----- > >From: Ken Wexel [mailto:[EMAIL PROTECTED] > >Sent: Monday, March 12, 2007 1:52 PM > >To: CF-Talk > >Subject: Re: Having trouble getting variables from different tables to output > > > >perhaps i'm reading this wrong, but do you have to do 2 queries for this, or > >can you join the tables, then group the output to get what you need? > > > > -------- > Michael Muller > Admin, MontagueMA.net Website > work (413) 863-0030 > cell (413) 320-5336 > skype: michaelBmuller > http://www.MontagueMA.net > > Eschew Obfuscation > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
