Skip to Content

TheBlogReaders.com

Salesforce.com, PHP, MySQL, Javascript, Ajax, Htacces

List has no rows for assignement to SObject Error in Salesforce Apex Class

Be First!
by November 24, 2011 APEX, SALESFORCE, SOQL

List has no rows for assignement to SObject Error in Salesforce Apex Class

Error: List has no rows for assignement to SObject in Salesforce,

My Case Object SOQL was something like this:
Case caseDetail = [select id, Subject from Case where id = :caseId]

If the SOQL query for some reason would not a return a result row the error message would be raised. A way to solve this is to assign the result of the SOQL-query to an caseDetail array instead.
Case[] caseDetail = [select id, Subject from Case where id = :caseId]

and then check with conditions using size() or isEmpty

caseDetail.size() OR caseDetail.isEmpty()

Example:
if (caseDetail.size() > 0) {
/* At least one row has been returned from the SOQL query
If we for example are only expecting one opportunity as result then get a handle on it like this */
caseDetail[0].subject = ‘TheBlogReaders.com’;
update caseDetail[0];
} else {
// Query was empty
}

(556)

Previous
Next

Leave a Reply