Sign Up ›
  • jchanowitz
  • NEWBIE
  • 25 Points
  • Member since 2007
  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 6
    Questions
  • 18
    Replies
SOLVED
2 replies

Self Joins using ActiveSalesforce

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:353:in `add_rows'

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

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

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

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

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

C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.3/lib/active_record/base.rb:661:in `find_by_sql'

from (irb):10

 

Has anybody done this?

 

Thanks in advance.

6 replies

Eclipse IDE not able to access src in a Sandbox project

I'm all of a sudden unable to use a Sandbox project in Eclipse.  If I try to "Refresh from Server" for any asset under src/unpackaged  I get back a ServiceException stating the package was deleted in my production organization and is no longer accessible from the sandbox (UNKNOWN_EXCEPTION).   

 

An app I have still works when pointing to the sandbox, the schema explorer for the project still works, and I'm able to see my classes, triggers, etc. in the correct sandbox from the salesforce UI.  Developer instance Eclipse projects still work, and any new sandbox projects I create throw the same errors.

 

I haven't changed anything between it working and not working, (other than a pretty long SF maintanance outage Friday nite??).

 

Anybody else seeing this behavior with sandboxes, or am I personally doing something stupid here.  

 

Thanks.

8 replies

Custom Class Mapping from Web Service Client to Apex Code

I'm trying to use the Value Object design pattern to call an Apex Code web service method to save a non-trivial object graph into the database.  My client is Flex / Flex Toolkit.  I create an SObject in the client, using the name of the custom class I've created in my Apex class, something like: 
 
.  I then pass that object as a parameter to
2 replies

Cross domain issue when calling Apex Code from Flex

I’m trying to invoke Apex code exposed as a web service from Flex using the Flex Toolkit, and am having cross domain security issues again.  It works fine when I run it as a local file.  When running from a domain, I get back "Security error accessing url."

 

The policy file that the Toolkit loads is at:

 

http://na3-api.salesforce.com/services/Soap/u/cross-domain.xml

 

But the endpoint that I’m calling is at:

 

http://na3-api.salesforce.com/services/Soap/class/MyClass

 

The Flash Player Security White Paper says “The scope of the permissions defined in a policy file includes all resources within the directory and within nested subdirectories.”

 

So it appears that the above policy file only supports API calls, and not Apex Code calls.  Is there, or could there be, a policy file to support both?

4 replies

Calling webservice method from java client

Hi All,
    I have created a new class (apex code) in salesforce with one webservice method in it. This method takes two arguments and creates new contact in sf.
   I want to call this method from java client. Is it possible?
   Please help to explain me asap.
 
Thanks,
Jegdish
6 replies

Apex and Flex 2 Web Services

I know this is supposed to be possible but I can't find any docs - I saw it at the last dev conf.
 
I have a webService exposed via Apex and I need to access that data from Flex Builder 2 but I can't seem to get it working.
 
If anyone has done this or knows where the docs are please get back to me.
 
thanks
-c
22 replies

Flex toolkit and cross domain issues

Hi,
 
I'm trying to use the flex toolkit.  I can run the salesforce.mxml app with no problems locally, but receive security sandbox errors when running from a server.  I can see the apex login call is finding a cross-domain.xml file, but i still receive the violation.
 
The domain the toolkit requests data from is: .../services/Soap/u/9.0
 
but the file is at  .../services/Soap/u/cross-domain.xml.
 
Does anyone know if it's location is an issue, or is there something else I'm doing wrong?
 
Thanks.  It sure seems like a great tool if I can deploy it.
 
Jay