FYI, the reason the first approach didn't work is that the zipcode is stored as a string, and string attributes can not be filtered (easily). For further information: http://freelancing-god.github.com/ts/en/common_issues.html#string_filters
On May 29, 4:52 pm, Rob Sterner <[email protected]> wrote: > A good night's sleep makes a big difference. I've changed my > define_index to: > > define_index do > indexes custom > indexes zipcode > end > > And my code to: > > Resume.search('foo', :conditions => {:zipcode => "02474|02482"}) > > That seems to do the trick. Just need to grok the behavior/syntax a > little more and I think I'll be good, thanks for listening :-D > > Cheers, > Rob > > On May 28, 8:37 pm, Rob Sterner <[email protected]> wrote: > > > My apologies up front for what's probably something trivial, but I'm > > beating my head against the wall trying to get this query to work. My > > define_index in resume.rb: > > > define_index do > > indexes custom > > has zipcode > > end > > > My attempt to use said index: > > > Resume.search('foo', :with => {:zipcode => ["90210","12345"]}) > > > This comes up dry every time. The database column resumes.zipcode is > > a varchar(10). Ideally I'd get back a result set of Resumes with > > 'foo' somewhere in resumes.custom within resumes.zipcode matching one > > of the ZIP codes passed. > > > This, obviously, works great (note they're Integers, not Strings): > > > Resume.search('foo', :with => {:zipcode => (0..99999)}) > > > Trying to craft a custom Range to pass, for example > > > (02474..02482) > > > gives me a nice `Illegal octal digit` SyntaxError. > > > Any help is much appreciated, many thanks in advance! -- 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.
