Hi everyone i have a list in my Apex class which has soql query result..

String query = 'SELECT  City,Latitude__c FROM Lead WHERE City LIKE \''+city+'%\'';
       
        leadrecords = Database.query(query);   

Eg :in the above line leadrecords is alist of lead type

    private List<Lead> leadrecords;

So now iam trying to pass this list to ajavascript variable so dat javascript variable should have query  output...but when i have done like this iam able to pass the list but when iam tryong to display that it is displaying the  ids  but i want to display the field city and latitude which are storesd in that list how to do it please someone help me with the solution... to javascript variable so how to pass this list to javascript variable

Hello,

We are trying to update some Task records using data loader or with Informatica.  We have 4 triggers on Task Object which will be executed once the record set is updated.

In the past what used to happen is that when set of 50 task records got updated, they used to be batched up and sent as one set. All the Governor Limits are applied against this set.

Recently what we noticed is that, 50 record set is being split into 50 individual records and each of the triggers is run for this Individual task. This process is repeated until all the 50 records are finished. All these operations happen in one context and all the SOQLs and DMLs are added up cumulatively. This is resulting in our code crossing the governor limits which in turn is causing the failure of the update.

Is anyone else facing the same issue? Were you guys able to resolve this? and if yes how.

It would be great if any one can provide us with solution to your problem.

We really appreciate your help.

Thanks,

Girish Suravajhula

Hello,

I am planning to do a insert of a large number of records that are inside of a CSV file. In the past we have provided the client a solution of using a Java program that reads the CSV file and makes the Insert by making use of Salesforce API.

However, now that the batch mode is available I was wondering if we can make use of it in this perticular scenario. Is there a way that we can can parse a large CSV file and insert records into Salesforce using salesforce batch mode.

Right now it appears that the batch mode can only run on records that are already inserted into Salesforce. I want the other way round, I want batch mode to be operational on records that are yet to be inserted into Salesforce. 

It some one already did this, please post the code and I guess it woud be helpfull for lot of people who are running in this issue. 

    Hello,

    It would be great if some one can suggest me a way to develop Logger class that will log all my apex messages to a local file.

    This would greatly help me, as this would give me an ability to go through the failure messages, and debug the application             more effectively. 
   
    I created an apex class that logs into Salesforce Document object, but it would create 2 additional calls to Salesforce and is lot     of overhead for each request. Suggestions would be greatly appreciated.

public class Logger {
 
 
 private static final Document log = [Select d.Body From Document d where d.Name='LogFile'][0];
 
 private String logMessage = '';
 
 public void addToLog(String message){
  logMessage = logMessage + System.now() + '::' +message + '\n';
 }
 
 public void logmessage(){
 
  log.body= Blob.valueOf(log.body.toString()+ logMessage);
  update log;
  logMessage = '';
 
 }

}

I'm playing with the following example: http://www.salesforce.com/us/developer/docs/pages/Content/pages_controller_custom.htm

I created both the controller and the page. However, I see an error: http://i.imgur.com/JxJbnMy.png

I have *no* idea what went wrong. The question is how to debug this?

Hi,

I've implemented Salesforce OAuth 2.0 Web Server flow and it works perfectly well with a HTTP callback uri. But when I use an HTTPS callback URI, the page on which the User Approves the app to use Salesforce asks for less permissions than what is shown for HTTP URI. 

The Remote Access Applications setup for both is exactly the same except the callback uri's ( obviously )

The page requesting the user to grant access for HTTP callback uri is asking for 3 permissions ( see https://www.dropbox.com/s/62qzsgev3nidw9o/developersalesforce.tiff ) 

1. Access your basic information

2. Access and manage your data

3. Perform requests on your behalf at any time

While the same page for HTTPS callback uri is only asking the first two options and not the third one ( see https://www.dropbox.com/s/w0k92iu42wuudug/securesalesforce.tiff )

Because of this, I cannot refresh my access tokens and the request to refresh access token fails.

Any insights on this will be highly appreciated.

Regards,

Agraj

Hello,

We are trying to update some Task records using data loader or with Informatica.  We have 4 triggers on Task Object which will be executed once the record set is updated.

In the past what used to happen is that when set of 50 task records got updated, they used to be batched up and sent as one set. All the Governor Limits are applied against this set.

Recently what we noticed is that, 50 record set is being split into 50 individual records and each of the triggers is run for this Individual task. This process is repeated until all the 50 records are finished. All these operations happen in one context and all the SOQLs and DMLs are added up cumulatively. This is resulting in our code crossing the governor limits which in turn is causing the failure of the update.

Is anyone else facing the same issue? Were you guys able to resolve this? and if yes how.

It would be great if any one can provide us with solution to your problem.

We really appreciate your help.

Thanks,

Girish Suravajhula

Trying to do the following but not having much luck... is there a way to do this?

SELECT Id, Name FROM Account WHERE BillingCity NOT LIKE '%Bentonville%'

Thanks.

I'm writing a unit test on the opportunity and opportunity line item.  I am getting the error "No standard price is defined".

Here is my test method:

public static testMethod void test3() 
    { 
    	Pricebook2 pb = new Pricebook2(Name = 'Standard Price Book 2009', Description = 'Price Book 2009 Products', IsActive = true);
    	insert pb;
    	Product2 prod = new Product2(Name = 'Anti-infectives 2007', Family = 'Best Practices', Practice__c = 'GP/BP', Service_Level__c = 'Partial Service', Product_Abbrev__c = 'CMR_Antiinfect', Sales_Unit__c = 'Each', Standard_Unit__c = 'Each', Product_Year__c = '07', Item_Type__c = 'Non-Inventory (Sales only)', IsActive = true);
    	insert prod;
    	PricebookEntry pbe = new PricebookEntry(Pricebook2Id = pb.Id, Product2Id = prod.Id, UnitPrice = 10000, IsActive = true, UseStandardPrice = false);
    	insert pbe;
    	Opportunity opp = new Opportunity(Name = 'Test Syndicated 2010', Type = 'Syndicated - New', StageName = 'Planning', CloseDate = system.today());
    	insert opp;
    	OpportunityLineItem oli = new OpportunityLineItem(opportunityId = opp.Id, pricebookentryId = pbe.Id, Quantity = 1, UnitPrice = 7500, Description = '2007 CMR #4 - Anti-Infectives');
    	insert oli;
		List<OpportunityLineItem> olis = [Select Id From OpportunityLineItem Where OpportunityId =: opp.Id];
		update olis[0];
    }

The error is thrown on the line where I try and insert the PricebookEntry record:

PricebookEntry pbe = new PricebookEntry(Pricebook2Id = pb.Id, Product2Id = prod.Id, UnitPrice = 10000, IsActive = true, UseStandardPrice = false);
    	insert pbe;

I'm not sure what I'm missing. 

Thanks for any help.

Regards.

Hi everyone,

I have a custom object called WorkItem which I have made visible through customer portal. In my org, I have overridden the "Create New WorkItem" button with a VF page and it is working perfectly fine. But, when I try to access it through my customer portal,  I am facing some problems and am not be redirected to the overriden page. rather, I am getting the standard edit page.

What do I need to do in order to fix this?

Thanks in advance.

SGM

Hi everyone i have a list in my Apex class which has soql query result..

String query = 'SELECT  City,Latitude__c FROM Lead WHERE City LIKE \''+city+'%\'';
       
        leadrecords = Database.query(query);   

Eg :in the above line leadrecords is alist of lead type

    private List<Lead> leadrecords;

So now iam trying to pass this list to ajavascript variable so dat javascript variable should have query  output...but when i have done like this iam able to pass the list but when iam tryong to display that it is displaying the  ids  but i want to display the field city and latitude which are storesd in that list how to do it please someone help me with the solution... to javascript variable so how to pass this list to javascript variable

Hello,

I am planning to do a insert of a large number of records that are inside of a CSV file. In the past we have provided the client a solution of using a Java program that reads the CSV file and makes the Insert by making use of Salesforce API.

However, now that the batch mode is available I was wondering if we can make use of it in this perticular scenario. Is there a way that we can can parse a large CSV file and insert records into Salesforce using salesforce batch mode.

Right now it appears that the batch mode can only run on records that are already inserted into Salesforce. I want the other way round, I want batch mode to be operational on records that are yet to be inserted into Salesforce. 

It some one already did this, please post the code and I guess it woud be helpfull for lot of people who are running in this issue. 

Wsdl2java (Axis 2.0) generates class extension is properly. But in Apex, generate Apex from WSDL feature is not giving appropriate class relationship.

e.g. I have following xsd in wsdl

<xsd:complexType name="Profile">
      <xsd:simpleContent>
              <xsd:extension base="xsd:string">
                 <xsd:attribute name="lang" type="xsd:string" use="optional"/>
              </xsd:extension>
      </xsd:simpleContent>
</xsd:complexType>

<xsd:complexType name="UserProfile">
        <xsd:simpleContent>
            <xsd:extension base="Profile">
                <xsd:attribute name="code" type="xsd:string"/>
            </xsd:extension>
        </xsd:simpleContent>
</xsd:complexType>

WSDL2Apex generates UserProfile and Profile classes, but dont have any relationship. In java Profile class has String _value containment. But Apex class does not have that containment too.

Any help would be appreciate.

Thanks.

Ankur