Thanks, John! You just saved me a lot of time trying to figure out
how to get the sorting function to work as I want it to. I know now
that it doesn't :).
On Dec 2, 2:25 pm, "John Bresnik" <[EMAIL PROTECTED]> wrote:
> Yea that's actually MySQL's fault - ORDER BYs sort like this, i.e.
> it's not Ultrasphinx - in fact Sphinx does a case fold for everything
> it indexes, stems, etc. You can get around it by using UPPER() but
> youll have to find a way to get that through Ultrasphinx or hack the
> config file (not recommended).. Easiest thing to do would be to store
> everything as lower case and then String.capitalize when needed. If
> you need the whole string capitalized:
>
> title.split.map{|s| s.capitalize}.join(" ")
>
> or something like that..
>
> On Tue, Dec 2, 2008 at 1:10 PM, liquid_rails <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > It's been a while since I've posted but I figure somebody in this
> > group may be able to help me with this...
>
> > I'm searching a database with ultrasphinx and want to return the
> > results in alphabetical order, ignoring case. However, with the
> > following command, headlines that begin with capital letters always
> > come ahead of those that don't. e.g. "Zebra" comes before "apple".
>
> > @search=Ultrasphinx::Search.new(:query => @query_string, :filters =>
> > filters, :sort_by => 'headline', :sort_mode=>'descending')
>
> > Does anyone know how I can get ultrasphinx to IGNORE the case of the
> > first letter of the headline when sorting the results? I've thought
> > of adding another column to my table, headline_downcase where the
> > headline is downcased, and doing a sort on that, but that just eats up
> > memory. There's got to be a better way!
>
> > Any help would be greatly appreciated!
>
> > Thank you,
>
> > Cheri
>
>
--~--~---------~--~----~------------~-------~--~----~
SD Ruby mailing list
[email protected]
http://groups.google.com/group/sdruby
-~----------~----~----~----~------~----~------~--~---
