Re: Fix for MySQL objectadmin record seelction

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: farcry-dev-/[email protected]
To unsubscribe, email: farcry-dev+unsubscribe-/[email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry