[ts] Re: Grouping by multiple attributes

2010-01-24 Thread Shaun
Hi Pat Thanks for getting back to me mate. Greatly appreciated! Yeah, that sounds like a good idea, I hadn't thought of it like that - it just takes thinking about things a little differently. Thanks for the pointer. Is there any more information on the difference between using group_by in the

[ts] has_many through vs habtm

2010-01-24 Thread phil
I used to have a habtm object in my index, but, after code updates we now have it as a has_many :through. Now I can't get the indexer to run. Here are the objects in question class Film ActiveRecord::Base has_many :amazon_genre_films has_many :amazon_genres, :through = :amazon_genre_films

Re: [ts] has_many through vs habtm

2010-01-24 Thread Pat Allan
Hi Phil What does the source for the film model look like in config/development.sphinx.yml? Don't forget to remove your database password. And while we're at it, what does the rest of your define_index block look like? And is it any better if you grab the id the long way? has

Re: [ts] Geo Searching an associated model

2010-01-24 Thread Pat Allan
Hi Eric The reason geo searches won't work when searching on Business is because you have an array of floats (which Sphinx can't handle) for both latitude and longitude. Sphinx requires single float values for both of those attributes. So, you probably want to search on Addresses instead, and

Re: [ts] Geo Searching an associated model

2010-01-24 Thread Eric Lubow
Pat, Everything you suggested was extremely useful. For the edification of those who come across this later, I a bit of the following. I added 2 Sphinx scopes (and I put them both in the Address model and the Business model): sphinx_scope(:website_only) { {:with = {:website_only =