July
June
May
April
March
February
January
 | 
|
 | List has no rows for assignement to SObjectCategory: Salesforce | ||||
I was modifying a test class for a trigger when I bumped into this error message - "List has no rows for assignement to SObject". This means that an object instance that is to be assigned a value from a SOQL query does not get assigned, i.e. the SOQL query return no value. My case was something like this:
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 Opportunity array instead.
and then check with conditions:
This way no error is raised. |  | ||||
| Tags: salesforce, sobject, soql, apex, error message | |||||
| Related blog entries: - Backing up your Salesforce data - How to disable and enable chatter and the new user interface - Importing a Salesforce field to a BigMachines attribute - Record Type ID: id value not valid for the users profile - What happens on a Visualforce page with a controller - Modifying the Salesforce Partner Edit page - The Thames Lodge in Staines - Creating an attachment instance in a testMethod - SOQL vs SQL - Where to change the Salesforce API version of a class - Prevent delete on a button or link in Salesforce - The salesforce id can be 15 or 18 digits long - Two ways of logging in with Salesforce Data Loader - Salesforce training podcasts - Standard Salesforce object prefixes - Copying a Salesforce object instance and keeping the id? - The select statement in Apex Data Loader and Apex Explorer sometime differs - Date issue when migrating with Salesforce Data Loader - Login error when logging into BigMachines - A look at BigMachines - Lessons learned when deleting large amounts of data with the Salesforce Dataloader - Swedish characters become strange characters during upsert with the Salesforce dataloader - Learning about cloud computing and Salesforce | |||||
| Created by Niklas Waller - 2010-02-17 23:00:13 |
| ||||
|
|
