Hi Osman I guess let's start with the simple questions, though perhaps you've done this already - have you rebuilt your Sphinx setup? rake ts:rebuild
This stops Sphinx, reindexes, and restarts Sphinx - which makes sure Sphinx is aware of all the configuration changes. If that doesn't help, can you run us through an example of what you're searching for, and what you expect to match? Cheers -- Pat On 06/01/2011, at 7:39 AM, osman wrote: > Hi, > I'm using ThinkingSphinx for a new startup website. I'm tried the > above suggestions but am still getting [nil]. > The model is called category, and it has a string[100] column called > 'name'. > > category.rb index code: > define_index do > set_property :group_concat_max_len => 5000 > set_property :enable_star => 1 > set_property :min_prefix_len => 1 > > indexes name, :prefixes => true > end > > Controller code: > category_results = Category.search params[:term] + '*', :select > => "name" > > I've also tried it without the star at the end, but with no luck. Any > suggestions? > Thanks, > Osman > > On Jan 1, 2:39 am, chamroeun ou <[email protected]> wrote: >> Thanks, >> >> Yes, i find the solution. >> >> On 12/28/10, Pat Allan <[email protected]> wrote: >> >> >> >> >> >> >> >>> Hi Chamrouen >> >>> Not sure if you've got this figured out - as far as I can tell, you're using >>> :select correctly. However, you need to use the 'indexes' method inside your >>> define_index block - not 'index'. >> >>> -- >>> Pat >> >>> On 25/11/2010, at 7:43 PM, chamroeun ou wrote: >> >>>> I write the following code at the Businesslisting model >> >>>> define_index do >>>> index business_name, :sortable=>true >>>> index service >>>> index description >>>> index district.ename, :as=>:district_name >>>> end >> >>>> -----------Controller Code >>>> Businesslisting.search params[:keywords], >>>> :select=>"business_name,email,telephone" >> >>>> On Thu, Nov 25, 2010 at 2:47 PM, chamroeun ou <[email protected]> >>>> wrote: >>>> Thanks for your quick response >> >>>> We want only specific columns to be populated in the search results >>>> i have tried this >>>> BusinessListing.search "foo", :select => "id, column_a, column_b" >> >>>> But it returned null >> >>>> -------------------- >> >>>> I also try indexes location.district_name, :as => :district_name. It >>>> works. But it's a full association not just district_name column. What >>>> we actually want is just the single column. >> >>>> We are using ThinkingSpinx for our CambodiaZoom.com website >> >>>> Chamroeun >> >>>> On 11/25/10, Pat Allan <[email protected]> wrote: >>>>> On 25/11/2010, at 3:11 PM, chamroeun wrote: >> >>>>>> I am a rookie in Thinking Sphinx for Rails. >> >>>>>> I am developing a business directory search. I have 2 tables >>>>>> BusinessListing and Location. >> >>>>>> When Sphinx found a record, it will give all the fields in the table. >>>>>> How can i select only the needed fields? >> >>>>> Did you want to search on specific fields? Or did you want only specific >>>>> columns to be populated in the search results? >> >>>>> For the first, you'll want to look at the :conditions option: >>>>> http://freelancing-god.github.com/ts/en/searching.html#conditions >> >>>>> And read up on extended search syntax for more complex situations: >>>>> http://www.sphinxsearch.com/docs/manual-0.9.9.html#extended-syntax >> >>>>> For just specific columns (ie: ActiveRecord's :select option), you can >>>>> just >>>>> use :select in a search query, and it gets passed through to the >>>>> underlying >>>>> ActiveRecord::Base.find request: >>>>> BusinessListing.search "foo", :select => "id, column_a, column_b" >> >>>>>> And in another case, i also need reference to another >>>>>> table(Businesslisting=>Location(district name). i need to retrieve the >>>>>> district name to include in the resultset of businesslisting. how can >>>>>> i do that? >> >>>>> To include columns from associations in your indexes, you can just refer >>>>> to >>>>> the associations in your define_index block: >> >>>>> define_index do >>>>> # ... >>>>> indexes location.district_name, :as => :district_name >>>>> # ... >>>>> end >> >>>>> Cheers >> >>>>> -- >>>>> Pat >> >>>>> -- >>>>> 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. >> >>>> -- >>>> 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. >> >>> -- >>> 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. > > -- > 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. > -- 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.
