Found! Worked this way:
has partner.city.state_name
has "CRC32(state_name)", :as => :state, :type => :integer
And ...
sphinx_scope(:by_state) { | state_name | {
:with => { :state => state_name.to_crc32 }
} }
Thanks a lot!
On Jul 31, 4:48 pm, benoror <[email protected]> wrote:
> Thanks Pat, I understand now the string problem. But how can I apply
> the CRC32 solution to the associated value ?
>
> Thanks again!
>
> On Jul 30, 10:54 pm, Pat Allan <[email protected]> wrote:
>
>
>
> > You're right about Sphinx not storing the string properly - 0.9.9 and
> > earlier don't have a true concept of string attributes. 1.10-beta does, but
> > Thinking Sphinx doesn't yet support that (I'm working on it).
>
> > In the meantime, it's worth reading
> > this:http://freelancing-god.github.com/ts/en/common_issues.html#string_fil...
>
> > Cheers
>
> > --
> > Pat
>
> > On 31/07/2010, at 12:21 PM, benoror wrote:
>
> > > Hi, I have many sphinx_scopes in my application's models, but one of
> > > them doesn't work, I think it's because the odd way Sphinx store the
> > > associated value.
>
> > > As an example I will show some key pieces of my Product class model,
> > > product.rb:
>
> > > ...
> > > belongs_to :partner
> > > # And partner belongs to city
> > > ...
> > > define_index do
> > > ...
> > > has partner.city(:state_name), :as => :state, :type => :string
> > > ...
> > > end
> > > ...
> > > sphinx_scope(:by_state) { | state_name | {
> > > :with => { :state => state_name }
> > > } }
>
> > > Then I try in console:
>
> > > Product.by_city('whatever_i_put_here_throws_same_resultset')
>
> > > I guess sphinx is not storing the string properly, any ideas? Thanks a
> > > lot!
>
> > > --
> > > You received this message because you are subscribed to the Google Groups
> > > "Thinking Sphinx" group.
> > > To post to this group, send email to [email protected].
> > > To unsubscribe from this group, send email to
> > > [email protected].
> > > For more options, visit this group
> > > athttp://groups.google.com/group/thinking-sphinx?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
