Applied the patches in both tickets. Hopefully in 6.1 we can start addressing these issues by moving these queries into the gateways.
Blair On Fri, Mar 18, 2011 at 1:10 AM, Tomek kott <[email protected]> wrote: > 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 > -- 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
