On Jan 31, 2008 3:02 PM, Ali Majdzadeh <[EMAIL PROTECTED]> wrote: > >On Jan 31, 2008 2:30 PM, Ali Majdzadeh <[EMAIL PROTECTED]> wrote: > > > ><cfoutput>#test.ProductName#</cfoutput> would work, but i'm guessing > >you want to display the product name once, and related data beneath > >it? > > > >http://tutorial150.easycfm.com/ > > > > > >-- > >Evelyn the dog, having undergone further modification pondered the > >significance of short-person behaviour in pedal depressed, > >pan-chromatic resonance, and other highly ambient domains. "Arf," she > >said. > > Exactly. thanks a lot it works very great. Just a question. Does DISTINCT in > SQL does the same thing or not? I know it won't be so great like grouping in > CFQUERY but someone told me that I can show data once by using Distinct in > SQL. Does it work here too or it is for other situation. THANKS IN ADVANCED > AGAIN. the tutorial is great. > Benign
DISTINCT does what it sounds like it does. it will return unique records. But even if the productIDs in a set of records are the same... what if the companyIDs are different? every column in the record has to be unique for a DISTINCT query to filter it. If you're grouping the output, then presumably the data 'under' the column on which you're grouping will be different, and therefore not filtered out by adding in a DISTINCT. -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. "Arf," she said. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
