On Thu, Mar 12, 2009 at 08:44:23AM -0500, Kenneth Marshall wrote:
> Kristian,
>
> I think the problem is in SearchBuilder/Handle.pm in the function
> _MakeClauseCaseInsensitive. It looks like it only skips the lower()
> for integer values. I think that you can replace the if test with
> something like:
>
> if ($value !~ /^[\d:- ]+$/) { # don't downcase integer values or timestamps
Oops, that should read:
if ($value !~ /^[-\d: ]+$/) { # don't downcase integer values or timestamps
because when including a dash ('-') in the character list it must
come first.
Sorry,
Ken
>
> I do not have a sample query to test with, but if this works
> please let me know so I can log a bug report against DBIx::SearchBuilder.
>
> Thanks,
> Ken
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
