It shouldn't be doing that, it should be deduping the results. Blair
On Tue, Nov 22, 2011 at 9:24 AM, Chris Kent <[email protected]> wrote: > Thanks Blair, I have added comment to the ticket to explain why the extra > condition is still required. > > The problem with not including > <cfif bHasVersionID> > and versionID is null > </cfif> > > Is that for a content item that has been approved and then a draft copy > made for editing. This one content item returns 2 rows in the record set to > objectamdin. > > You see the draft/approved row and then a second row for the same content > item that is draft. > > This does not loot right and also causes problems wit the number of > content items returned. If there are 3 content items, C1, C2 & C3, and the > first item C1 is approved and has a draft copy then all you get back is > C1 draft/approved > C1 draft > C2 > > You do not see C3. > > The code immediately prior to building the record set is determining how > many records to send back, this calculates that there are 3 content items > to return. But the code that returns the content items requires the extra > where condition to not return the draft record for a versioned content > item. > > Chris. > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: [email protected] > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry > -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
