Some of our clients want to keep large volume of data for historical purpose which can be viewed in the application on-demand. I thought to try Amazon cloud first, but then found the database.com.

 

Has anybody done anything like this where most of the historical data in database.com which are fetched on-demand? If yes, please provide some guidelines.

 

Thanks

Bhaskar

We have an object, which has 65000 records. We are doing a query with Group BY claues and using limit 50000, still we are getting error 'too many query rows: 50001'.

 

Any idea?

 

Thanks in advance!

Hi,

 

In our VF page we are writing like this

<apex:repeat ........
<apex:relatedList subject = ..........
</apex:repeat .....

Inside "subject" of related list we are passing some id which we are getting from "repeat" . On display the first "repeat" is showing correct related list as it should according to the id passed, but from the next line its showing the old relatedlist again and again on every repeat. Though next time different id is being passed .

 

Any suggestions are welcome. Thanx in advance

We have an object, which has 65000 records. We are doing a query with Group BY claues and using limit 50000, still we are getting error 'too many query rows: 50001'.

 

Any idea?

 

Thanks in advance!

Hi,

 

In our VF page we are writing like this

<apex:repeat ........
<apex:relatedList subject = ..........
</apex:repeat .....

Inside "subject" of related list we are passing some id which we are getting from "repeat" . On display the first "repeat" is showing correct related list as it should according to the id passed, but from the next line its showing the old relatedlist again and again on every repeat. Though next time different id is being passed .

 

Any suggestions are welcome. Thanx in advance

Hi all,

I am new for Apex development. So please help me out. Any help will be appreciable.
Currently I am using a function in our application in which I am retrieving data from external web services and storing it in Salesforce database. I am calling this function in a ‘for’ loop because this is getting called multiple times based on the selection of checkboxes. At 1st time, this function is working properly but 2nd time, It's giving exception which is as follows:
ERROR: System.CalloutException: You have uncommitted work pending. Please commit or rollback before calling out.

Below is the function which is getting called multiple times:
WebService static void getContent(String id)
{
    String response = '';
    Http h = new Http();
    HttpRequest req = new HttpRequest();
    String url = 'url of the web service';
    req.setEndpoint(url);
    req.setMethod('GET');
    HttpResponse res=null;
    try {
        res= h.send(req);
    } catch(System.CalloutException e) {
    System.debug('ERROR: '+ e);
}

Thanks,
Manjiri