your right, i wish they would support so much more in QoQ. i have read that it was not meant to be used in the way that so many people are now trying to use it. but i hope they realise that they have started the need for something that can really help people out and they should really satisfy the need they have created
i havent read or heard about any enhancements to the QoQ in version 9 though, its a real shame if they don't thanks for your help again >Glad it's working for you. > >I really wish QofQ would support the "INNER JOIN table_name tn ON >tn.column_name = " syntax. To me, it is a lot easier to visually see >how each table is being tied into the results. > >I have seen an incomplete join bring down the server when two large >tables were joined together with no criteria. Like Jochem said, that is >a Cartesian join, which means EVERY POSSIBLE combination of records from >both tables will be returned. > >Let's say you join two tables together that both have only 1,000 >records. >You're going to get 1,000,000 records back. This effect grows >exponentially. > >~Brad > > >ok thanks brad, i have taken it out of the from list, you learn >something new everyday > >i hadnt realised that by putting that in there that it would think that >i am joining it, even if i had not specified any columns from that query >but would still attempt to join it. to be honest i thought i needed it >to do the valuelist stuff as you said. > > >it has sped it up thanks. you stated that i hadnt added any join clauses >but as i think you guessed there was not meant to be a join > >thanks brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4