This is a discussion on MySQL Upsert Question within the Salesforce PHP Tutorials forums, part of the Salesforce category; Hi there,
Ignore my previous question.. I was able to do an
-
MySQL Upsert Question
Hi there,
Ignore my previous question.. I was able to do an upsert, however, I'm seem to be stuck at the 200 record limit. Is there a work around?
Thank you,
Kevin Davis
Last edited by Kevin Davis; 02-09-2011 at 01:34 PM.
Reason: Change in question
-
what do you mean exactly man? Are you only processing a total of 200 records or 200 at a time ?
-
Sorry I should have been more clear. I have a data set that has more than 200 records and when I reach the 200 limit it stops.
-
Hi Kevin,
Yes, some Objects have their own restrictions on how many records it queries at a time and even though you put a higher number, SalesForce will override your perference. I usually set the batches at 1000 per query as this is a safe number. I think 2k is about the maximum you can go.
Now, about your stopping issue, this just means that you need to use the queryMore method instead of the query method.
Why don't you take a look at the page below for an example of this:
PHP Toolkit 13.0 QueryMore Sample (Partner) - developer.force.com
Similar Threads
-
By Willis in forum Salesforce PHP Tutorials
Replies: 0
Last Post: 04-13-2010, 08:33 PM
-
By jeff in forum Salesforce Coding Discussions
Replies: 2
Last Post: 08-12-2009, 03:33 PM
-
By PaulC in forum Salesforce PHP Tutorials
Replies: 3
Last Post: 08-12-2009, 12:33 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
Bookmarks