Blair, Turns out the problem is in /core/tags/formtools/objectadmin.cfm, lines 304 and 333:
Instead of <cfoutput>AND #i# LIKE '%#whereValue#%'</cfoutput> It should be <cfoutput>AND lower(#i#) LIKE '%#whereValue#%'</cfoutput> This works for both mySQL and Oracle, so should be safe. Come to think of it, this is essentially the same bug I described here (in a different context) https://farcry.jira.com/browse/FC-2068 This new bug is listed as: https://farcry.jira.com/browse/FC-2465 Solutions are given for both (no patch files though) Tomek On Mar 16, 11:18 pm, Blair McKenzie <[email protected]> wrote: > The filtering is done in /core/packages/farcry/formtools.cfm getRecordset. > It's a mess of a function, but there is occasional oracle specific stuff. > Not something that's easy for me to test. > > Blair > > On Thu, Mar 17, 2011 at 1:18 PM, Tomek kott <[email protected]> wrote: > > sorry, let me ammend the oracle statement. If the default filter has a > > value (say a specific year), then all future filtering actions work on > > that content type. If the filter is blank by default, it does not > > work. > > > Any ideas? > > > On Mar 16, 7:34 pm, Blair McKenzie <[email protected]> wrote: > > > I've backported the fix to p600. > > > > Blair > > > > On Thu, Mar 17, 2011 at 10:30 AM, Blair McKenzie <[email protected]> > > wrote: > > > > Are you running on MySQL? I found this bug yesterday in trunk and I > > haven't > > > > checked to see if it's a problem in p600. > > > > > Blair > > > > > On Thu, Mar 17, 2011 at 5:27 AM, Tomek kott <[email protected]> > > wrote: > > > > >> Hi folks, > > > > >> I just noticed that when using filtering, the table is not being > > > >> updated (going from FC5.1.11 to 6.0.11). Generally, I can submit the > > > >> filtering form, but the same table shows up after the screen > > > >> refreshes. This is true on all content types for which filtering is > > > >> available. Is there something different that needs to be done in the > > > >> objectadmin definition? Has anyone else ran into this problem? > > > > >> The only clue I have is that it seems that the number of entries that > > > >> is displayed (i.e. pages, or table rows) is correct. If i search for a > > > >> unique string of a content type that is available for filtering, it > > > >> shows only one table row. It just happens that the row shown is the > > > >> same for the general query. > > > > >> TIA, > > > > >> Tomek > > > > >> -- > > > >> 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 -- 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
