Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
aalazzaniaalazzani 

How can I determine if any elements were retrieved by the query?

I am writing a query in an Apex Code method and I want to make sure that there is at least one element retrieved before I start accessing elements by index. I tried .length, .count, .length() but none gave me how many elements were retrieved by the query. How can I determine if any elements were retrieved by the query? Here is my code below and thanks in advance for your help.

Thanks,

Aref

Code:
LeadAssignment__c[] defaultLeadAssignments = [Select User__c from LeadAssignment__c where Name = '00000'];

if(defaultLeadAssignments.length > 0){
 defaultUser  = defaultLeadAssignments[0].User__c ; 
}

Message Edited by aalazzani on 11-16-2007 12:27 AM

Message Edited by aalazzani on 11-16-2007 12:29 AM

Message Edited by aalazzani on 11-16-2007 12:30 AM

tschatztschatz

I think lists work with myList.size()

tryCode:

if(defaultLeadAssignments.size() > 0){
 defaultUser  = defaultLeadAssignments[0].User__c ; 
}

//or 

if(0 < defaultLeadAssignments.size()){
 defaultUser  = defaultLeadAssignments[0].User__c ; 
}


 
aalazzaniaalazzani
Hi tschatz,

Yes that worked. Thanks a lot.

Aref