Thanks very much for this Chris. I am implementing this in our Farcry CMS (6.1.1). Our editors will be very pleased to have a fix for this problem. I agree with you that items that exist as draft and approved should appear as one result (draft/approved); it is very confusing to have an additional draft record and as you say you do not get the correct records returned because of the count that is done previously. I did initially have some very confusing errors, but think I have now traced it to inconsistencies in our database. In some records the versionid is shown as null and in others it is blank. So I have amended one line of your code to read: <cfif bHasVersionID> and (versionID is null or versionID ='') </cfif> The filter by category now appears to be working correctly as far as I can see. Regards, Annette 19 November 2011 22:48:25 UTC, Chris Kent wrote:
> Just added a fix for MySQL getRecordset in > /core/packages/farcry/formtools.cfc > https://farcry.jira.com/browse/FC-2581 > > Category selection was not working and draft copies of versioned content > items were being returned back to objectadmin in non-MS SQL database types. > > 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
