Hi, I am having problem in searching the results. If the foreign key store_id in the orders table is greater than 999, then returns the empty results. But it returns the correct result set when the its <=999. How to make it working when the store_id is greater than 999? -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Hi there I''m not quite sure what the problem is by your description - I''m guessing you''re searching on the Order model? What''s the index definition for Order? And what''s the query you''re running that isn''t working as you expect? Also: for future reference, it''s better to ask Thinking Sphinx questions on the Thinking Sphinx google group: http://groups.google.com/group/thinking-sphinx Cheers -- Pat On Dec 14, 10:08 pm, Raghu 2009 <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> Hi, > > I am having problem in searching the results. > If the foreign key store_id in the orders table is greater than > 999, then returns the empty results. But it returns the correct result > set > when the its <=999. > > How to make it working when the store_id is greater than 999? > > -- > Posted viahttp://www.ruby-forum.com/.-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Hi Pat, Thanks for your response, will post the request on the google group. Regards, Raghu -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Raghu 2009 wrote in post #968477:> Hi Pat, > > Thanks for your response, will post the request on the google group. > > Regards, > Raghuif you have a sphinx.yml file there is something called "max_matches: 100000".try that development: bin_path: "/usr/local/bin" enable_star: true morphology: libstemmer_en match_mode: any min_infix_len: 2 min_prefix_len: 2 max_matches: 100000 port: 3310 -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.