Hcfyk

How to place nodes around a circle from some initial angle?

What connection does MS Office have to Netscape Navigator?

What did we know about the Kessel run before the prologues?

Does soap repel water?

I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin

Is it my responsibility to learn a new technology in my own time my employer wants to implement?

Why isn't acceleration always zero whenever velocity is zero, such as the moment a ball bounces off a wall?

What happens if you roll doubles 3 times then land on "Go to jail?"

Why, when going from special to general relativity, do we just replace partial derivatives with covariant derivatives?

Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?

Can MTA send mail via a relay without being told so?

What is the purpose of the Evocation wizard's Potent Cantrip feature?

unclear about Dynamic Binding

Domestic-to-international connection at Orlando (MCO)

Is micro rebar a better way to reinforce concrete than rebar?

Flying from Cape Town to England and return to another province

How to avoid supervisors with prejudiced views?

I want to delete every two lines after 3rd lines in file contain very large number of lines :

What flight has the highest ratio of time difference to flight time?

Unreliable Magic - Is it worth it?

Arranging cats and dogs - what is wrong with my approach

Why do remote US companies require working in the US?

Display a text message if the shortcode is not found?

Why the difference in type-inference over the as-pattern in two similar function definitions?

Check if object is null and return null

3

I'm doing a query to an object. My question is if nothing returns is it technically null. I want to return null if it is.

People person = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') limit 1];

if (person == null)
 return null;

apex visualforce visualforce-component

share|improve this question

asked Mar 20 at 21:19

ebarebar

234

add a comment | 

3

I'm doing a query to an object. My question is if nothing returns is it technically null. I want to return null if it is.

People person = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') limit 1];

if (person == null)
 return null;

apex visualforce visualforce-component

share|improve this question

asked Mar 20 at 21:19

ebarebar

234

add a comment | 

I'm doing a query to an object. My question is if nothing returns is it technically null. I want to return null if it is.

People person = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') limit 1];

if (person == null)
 return null;

apex visualforce visualforce-component

share|improve this question

asked Mar 20 at 21:19

ebarebar

234

People person = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') limit 1];

if (person == null)
 return null;

share|improve this question

asked Mar 20 at 21:19

ebarebar

234

share|improve this question

asked Mar 20 at 21:19

ebarebar

234

asked Mar 20 at 21:19

ebarebar

234

asked Mar 20 at 21:19

ebarebar

234

3 Answers
3

active

oldest

votes

5

The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:

People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1]) 
 person = record;

return person; // will return null or a single record

share|improve this answer

edited Mar 21 at 0:49

answered Mar 20 at 21:23

sfdcfoxsfdcfox

262k12209454

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
  
  – Jayant Das
  Mar 20 at 21:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JayantDas That's what I meant, of course, but I went ahead and clarified.
  
  – sfdcfox
  Mar 21 at 0:50
  

  
  
  
  

add a comment | 

3

One way to do this is to check for the number of records returned:

People[] persons = [...];
if (persons.size() == 0) return null;

as your code as written will generate this exception if no records match:

System.QueryException: List has no rows for assignment to SObject

share|improve this answer

answered Mar 20 at 21:22

Keith CKeith C

96.3k1096214

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Or simply isEmpty() :)
  
  – Eric
  Mar 21 at 4:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Eric I always forget that method...
  
  – Keith C
  Mar 21 at 8:04
  

  
  
  
  

add a comment | 

1

Change the code to:

People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];

if (people.size() == 0)
 return null;
 else 
 return people[0];

share|improve this answer

answered Mar 20 at 21:23

Phil WPhil W

641210

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f254673%2fcheck-if-object-is-null-and-return-null%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

5

The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:

People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1]) 
 person = record;

return person; // will return null or a single record

share|improve this answer

edited Mar 21 at 0:49

answered Mar 20 at 21:23

sfdcfoxsfdcfox

262k12209454

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
  
  – Jayant Das
  Mar 20 at 21:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JayantDas That's what I meant, of course, but I went ahead and clarified.
  
  – sfdcfox
  Mar 21 at 0:50
  

  
  
  
  

add a comment | 

5

The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:

People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1]) 
 person = record;

return person; // will return null or a single record

share|improve this answer

edited Mar 21 at 0:49

answered Mar 20 at 21:23

sfdcfoxsfdcfox

262k12209454

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The syntax in your code throws a QueryException if you try it -- only if there's no record returned.
  
  – Jayant Das
  Mar 20 at 21:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JayantDas That's what I meant, of course, but I went ahead and clarified.
  
  – sfdcfox
  Mar 21 at 0:50
  

  
  
  
  

add a comment | 

The syntax in your code throws a QueryException if you try it, and there are no records to return. Instead, use one of the other common patterns. This is one that I use:

People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1]) 
 person = record;

return person; // will return null or a single record

share|improve this answer

edited Mar 21 at 0:49

answered Mar 20 at 21:23

sfdcfoxsfdcfox

262k12209454

People person; // is null
for(People record: [SELECT Type FROM People WHERE Type LIKE '%Construction%' LIMIT 1]) 
 person = record;

return person; // will return null or a single record

share|improve this answer

edited Mar 21 at 0:49

answered Mar 20 at 21:23

sfdcfoxsfdcfox

262k12209454

answered Mar 20 at 21:23

sfdcfoxsfdcfox

262k12209454

answered Mar 20 at 21:23

sfdcfoxsfdcfox

262k12209454

3

One way to do this is to check for the number of records returned:

People[] persons = [...];
if (persons.size() == 0) return null;

as your code as written will generate this exception if no records match:

System.QueryException: List has no rows for assignment to SObject

share|improve this answer

answered Mar 20 at 21:22

Keith CKeith C

96.3k1096214

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Or simply isEmpty() :)
  
  – Eric
  Mar 21 at 4:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Eric I always forget that method...
  
  – Keith C
  Mar 21 at 8:04
  

  
  
  
  

add a comment | 

3

One way to do this is to check for the number of records returned:

People[] persons = [...];
if (persons.size() == 0) return null;

as your code as written will generate this exception if no records match:

System.QueryException: List has no rows for assignment to SObject

share|improve this answer

answered Mar 20 at 21:22

Keith CKeith C

96.3k1096214

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Or simply isEmpty() :)
  
  – Eric
  Mar 21 at 4:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Eric I always forget that method...
  
  – Keith C
  Mar 21 at 8:04
  

  
  
  
  

add a comment | 

One way to do this is to check for the number of records returned:

People[] persons = [...];
if (persons.size() == 0) return null;

as your code as written will generate this exception if no records match:

System.QueryException: List has no rows for assignment to SObject

share|improve this answer

answered Mar 20 at 21:22

Keith CKeith C

96.3k1096214

People[] persons = [...];
if (persons.size() == 0) return null;

share|improve this answer

answered Mar 20 at 21:22

Keith CKeith C

96.3k1096214

answered Mar 20 at 21:22

Keith CKeith C

96.3k1096214

answered Mar 20 at 21:22

Keith CKeith C

96.3k1096214

1

Change the code to:

People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];

if (people.size() == 0)
 return null;
 else 
 return people[0];

share|improve this answer

answered Mar 20 at 21:23

Phil WPhil W

641210

add a comment | 

1

Change the code to:

People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];

if (people.size() == 0)
 return null;
 else 
 return people[0];

share|improve this answer

answered Mar 20 at 21:23

Phil WPhil W

641210

add a comment | 

Change the code to:

People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];

if (people.size() == 0)
 return null;
 else 
 return people[0];

share|improve this answer

answered Mar 20 at 21:23

Phil WPhil W

641210

People[] people = [SELECT Id, Type FROM People WHERE (Type LIKE '%Construction%') LIMIT 1];

if (people.size() == 0)
 return null;
 else 
 return people[0];

share|improve this answer

answered Mar 20 at 21:23

Phil WPhil W

641210

answered Mar 20 at 21:23

Phil WPhil W

641210

answered Mar 20 at 21:23

Phil WPhil W

641210