Thinking Sphinx Query. Please Help.

Hi, I am new with ruby on rails. I am working on a project. I which i have a model named "ngo.rb" and it has a "has_one" association with another model named "ngo_staff.rb"

Description of model :

1. Ngo

Hi,

A suggestion without trying this out... If your number_of_full_time & number_of_part_time are integers but are stored as strings then why convert them? Remove the casting while indexing & just search on them as strings:

Ngo.search :with => {:full_time_members => "12" }

The other option is of course to store them as integers if that is what they always are ... but I guess you have a reason why you did it this way.

Hope this helps, Harry