Hi pat,
I got serious issue in my application,
sample code:
zip_code= zipcodes.collect(&:zipcode).try(:join,"|")
@donates= Donate.search params[:search],:conditions => {:zip =>
"#{zip_code}"}In zip_code ,i am getting more than 500 zip codes , i am getting 0 records .If i given less 200 records it is working fine wat to do ? Even in the sphnix.yml,i given mem_limit=128M but no use On Sep 10, 6:05 pm, Arun Prakash <[email protected]> wrote: > Hi Pat, > Its working fine but again one problem, > :conditions => {:zip => "(01234 | 56789)"} " > > In this i have more than 500 zip codes.If i passed whole thing in side > the condition result is 0 but if i passed the less number of zip > codes inside the condition it is working fine.Whether i need to mem limit in > spinix.yml file .Any suggestions? > > Best Regards > Arun Prakash C.K > > Keep On Sharing Your Knowledge with Others > > > > > > > > On Fri, Sep 10, 2010 at 4:45 PM, Pat Allan <[email protected]> wrote: > > This is because :with_all is for filters, which only apply to attributes. > > Currently you have zip as a field - which is probably the best option, as > > you can't currently filter by string attributes. > > > -- > > Pat > > > On 10/09/2010, at 7:11 PM, Arun <[email protected]> wrote: > > > Hi pat , > >> Now its working fine but one doubt , can i use with_all filters > >> instead of" :conditions => {:zip => "(01234 | 56789)"} " because i am > >> getting the condtion like value like this > >> z= [92656, 92698, 92801, 92802, 92803, 92804, 92805] > > >> @donates = Donate.search params[:search],:with_all => {:zip =>z} > > >> so result should come related to this code only but it is not working > >> for me ?? > > >> Any sugesstion ? > > >> On Sep 10, 3:54 pm, Pat Allan <[email protected]> wrote: > > >>> Sphinx can only query against the information it knows about - ie: > >>> what's in the index. > > >>> So, if you want to query against zip codes, make sure you have a field > >>> for that column: > > >>> indexes zip > > >>> Keep in mind that string attributes can't be used for filters: > >>>http://freelancing-god.github.com/ts/en/common_issues.html#string_fil... > > >>> If you want to query by multiple zip codes, then check out the sphinx > >>> docs for the extended match mode syntax - you'll want to wrap all zip > >>> codes together with parentheses, and separate them with OR pipes: > > >>> Donate.search :conditions => {:zip => "(01234 | 56789)"} > > >>> Cheers > > >>> -- > >>> Pat > > >>> On 10/09/2010, at 6:37 PM, Arun <[email protected]> wrote: > > >>> Hi Pat, > > >>> In the donate model block is > >>>> define_index do > >>>> indexes title > >>>> end > > >>> On Sep 10, 3:34 pm, Pat Allan <[email protected]> wrote: > > >>>>> Hi Arun > > >>> What does the define_index block in your Donate model look like? > > >>> -- Pat > > >>> On 10/09/2010, at 6:32 PM, Arun <[email protected]> wrote: > > >>> thanks i have installed 2.0.0.rc2 and in the filters i am using the > >>>>>> array only. > > >>> Even though i perforemd search like this > >>>>>> donate = Donate.search "Stringer", :conditions => {:zip =>91795} > >>>>>> Stringer word is matched with zipcode but result is not retrieving > >>>>>> and > >>>>>> also i regenerated the index and i restarted the servers also > >>>>>> what to > >>>>>> do ? > > >>> On Sep 10, 3:16 pm, Pat Allan <[email protected]> wrote: > > >>>>>>> Hi Arun > > >>> What does your define_block look like?Because you can't use string > >>>>>>> attributes for filters. > > >>> Also, probably best using 2.0.0.rc2 - though that shouldn't change > >>>>>>> anything in this situation. > > >>> Cheers > > >>> -- > >>>>>>> Pat > > >>> On 10/09/2010, at 6:12 PM, Arun <[email protected]> wrote: > > >>> Hi friend, > >>>>>>>> I have installed the "gem 'thinking-sphinx', '2.0.0.rc1', :require > >>>>>>>> => > >>>>>>>> 'thinking_sphinx'" in the rails 3 application > > >>> Search function is working but Attribute Filters,field condtions > >>>>>>>> is > >>>>>>>> not working > > >>> I need to search donation name with matched zipcodes only ,so i > >>>>>>>> used > >>>>>>>> like this > >>>>>>>> @donates = Donate.search params[:search],:with_all => {:zip => > >>>>>>>> zipcodes.collect(&:zipcode)} > > >>> But it is retrieving the result even it not matching also and i > >>>>>>>> tried > >>>>>>>> like this in console to check sphinx > > >>> Donate.search "Stringer", :conditions => {:zip => '91795'} > >>>>>>>> zip code belongs to "stringer" but it is also not retrieving > > >>> where i am doing wrong?? > > >>> -- > >>>>>>>> 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]<thinking-sphinx%2Bunsubscribe@ > >>>>>>>> googlegroups.com> > >>>>>>>> . > >>>>>>>> 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]<thinking-sphinx%2Bunsubscribe@ > >>>>>> googlegroups.com> > >>>>>> . > >>>>>> 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]<thinking-sphinx%2Bunsubscribe@ > >>>> googlegroups.com> > >>>> . > >>>> 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]<thinking-sphinx%2Bunsubscribe@ > >> googlegroups.com> > >> . > >> 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]<thinking-sphinx%2Bunsubscribe@ > > googlegroups.com> > > . > > 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.
