Code:

trigger EndSSUAccessWhenContactIsSetToFormerUser on Contact bulk (after update) 
{
 Set<Id> lConIds = new Set<Id>();
 for (Contact c : Trigger.new)
 {
  lConIds.add(c.Id);
 }
 List<SelfServiceUser> lSSUs = new List<SelfServiceUser>([select Id, IsActive, ContactId from SelfServiceUser where ContactId in :lConIds]);
 Map<Id,SelfServiceUser> lSelfServiceUsers = new Map<Id,SelfServiceUser>();
 for(SelfServiceUser s: lSSUs)
 {
  lSelfServiceUsers.put(s.ContactId,s);
 }
 
 List<SelfServiceUser> lSelfServiceUserUpdates = new List<SelfServiceUser>();
 for (Contact c : Trigger.new)
 {
  SelfServiceUser s = lSelfServiceUsers.get(c.Id);
  if(c.OMG_ContactType__c == 'Former User' && s != null && s.IsActive)
  {
   s.IsActive = false;
   lSelfServiceUserUpdates.add(s);
   if(lSelfServiceUserUpdates.size() == 200) 
   {
       //update lSelfServiceUsersUpdates;
       lSelfServiceUserUpdates.clear();   
   }
  }
 }
 if(lSelfServiceUserUpdates.size() > 0)
 {
  //update lSelfServiceUsersUpdates;
 }
}

 
We have a custom field that determines the status of a contact.  If the contact is set to a "Former User" we would like to remove access to the case self service portal.  However, I am having trouble updating the SelfServiceUser object inside of my after trigger.  Also, any suggestions on how to improve efficiency of this code would be greatly appreciated.

I'm trying to integrate salesforce with our legacy DB.  I have an Order__c with Order_Products__c Master Detail relationship.  When I am building my soap message how do I reference the detail fields?  I'm using Java to do the integration.  Anyone have an sample code or is this possible?  I assume it will be something similar to Order__c.fieldName  Any guidance?

Is there any way to override the behavior of the Save button on a standard object (i.e., Opportunity)?  Basically we were planning on building an S-control that looks to see if an Opportunity (for a particular product type) is closed/won and if it is update a Boolean field on the Opportunity.  Unfortunately it does not look like it’s possible to override or hide the standard Save button.   Can anyone think of a work around other than outbound messaging to a hosted solution that will update the record via the API?  We are using SFDC Enterprise Edition.

Thank you,
Scott

Code: My issue is this. I've created a custom field on my 'pelkins@parallels.com' account. And, I'm using the API to upsert data. The call executes and the results are returned without error. Per the UpsertResults returned, every row has failed to upsert with the message in the Subject line above. So, my question is WHY— I have refreshed my wsdl via XML download. I see the property in the API and via my login in SalesForce, but for some reason, the custom field is not recognized. Whassup–

Hey Everyone,

I have created 2 formula fields. One field called Today determines the current day of the week (monday, tuesday, etc...), the other field called Run Day will evaluate if the Today field is equal to a picklist field called Delivery Day. If so it will say Production Run Today, if not No Production Run Today.

For some reason the 2nd formula field doesnt seem to work correctly. Can anyone help out? My code is below:

IF(ISPICKVAL(Delivery_Day__c,Today__c),"Production Run Today", "No Production Run Today")


Thanks,
Rich

I have a JavaScript variable I'm setting to create a lead from a contact. Some of the fields contain carriage returns. As you can imagine, JavaScript does not like this.

This is my example variable:

lead.set("Description", "{!Contact.Description}");

How is the best way to clean up this variable so it doesn't show up with carriage retruns?

lead.set("Description", "This is my test example

test

test");




-Scott

I'm struggling a bit to write a simple join query using the 'relationship query' syntax of SOQL.
Could someone please post any ideas about how to obtain the following info in a single SOQL command.
Here is the pseudo code:
Get all contacts for accounts that have assets with product='X'
I know I can iterate through all assets and grab each account one at a time but I thought there must be a better way.

I've tried the following which throws SOQL syntax errors:

Select a.Id, a.AccountNumber, a.Name, (SELECT id,lastname,firstname,email FROM Contacts), (SELECT status, Product2Id from Assets ) from Account a where a.Assets.Product2Id = '01t40000000bgY7AAI'