Hi,

I'm trying to access a SFDC database from Rails, that has a custom object Employee__c, which in turn has a self referential foreign key Supervisor__r, pointing back to Employee__c.  In Rails, I have a model Employee, which has a set_table_name of 'Employee__c'.  Does anyone know how I can get the supervisor's name on a query to the employee.  It doesn't seem as if Rails allows a model to associate to itself.  Also, if I try just to pass the soql directly by using Employee.find_by_sql(), I can't figure out how to label the Supervisor__r foreign key in my query (which is being changed to supervisor_id__c when returned by asf).  For example:

Employee.find_by_sql("select e.id, e.name, e.Supervisor__r.name from Employee__c") returns

NoMethodError: You have a nil object when you didn't expect it!

The error occurred while evaluating nil.name

from C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-activesalesforce-adapter-2.0.0/lib/active_record/connection_adapters/activesalesforce_adapter.rb:347:in `each'from

from C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-activesalesforce-adapter-2.0.0/lib/active_record/connection_adapters/activesalesforce_adapter.rb:344:in `each'from

from C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-activesalesforce-adapter-2.0.0/lib/active_record/connection_adapters/activesalesforce_adapter.rb:327:in `select_all'from

from (irb):10

Has anybody done this?

Thanks in advance.