Apex Code Development You need to sign in to do that
Don't have an account?
Soql Query
Hi all,
I am trying to query all the records in Account and Contact object ,As I have tried Like this
public class hong12
{
public List<account> acclist{get;set;}
public List<contact> contlist{get;set;}
public hong12()
{
acclist=[select id,Name,phone,Industry,Type,NumberOfEmployees from Account];
contlist=[select id,Name,Email,phone from Contact];
}
}But I am getting Error Like this
Error: Compile Error: The property List<Contact> contlist is referenced by Visualforce Page (newhomepg) in salesforce.com. Remove the usage and try again. at line 4 column 22
I am trying to query all the records in Account and Contact object ,As I have tried Like this
public class hong12
{
public List<account> acclist{get;set;}
public List<contact> contlist{get;set;}
public hong12()
{
acclist=[select id,Name,phone,Industry,Type,NumberOfEmployees from Account];
contlist=[select id,Name,Email,phone from Contact];
}
}But I am getting Error Like this
Error: Compile Error: The property List<Contact> contlist is referenced by Visualforce Page (newhomepg) in salesforce.com. Remove the usage and try again. at line 4 column 22
In your apex class where there is contlist=[select id,Name,Email,phone from Contact]; modify it to include Account in it.
contlist=[select id,Name,Account,Email,phone from Contact];
As per the error, you are not retrieving the account from contact but you are using it in visualforce page,
Let me know if you have any issues after doing this.
Regards
Sampath Kumar Goud
All Answers
The error is because, you are modifying the existing class which is used by visualforce page newhomepg. To resolve this issue, comment the code which uses contlist in visualforce page newhomepg, save it then save the apex class and uncomment the code in visualforce page.
Mark this as best answer if this solves your issue.
Regards
Sampath Kumar Goud
System.SObjectException: SObject row was retrieved via SOQL without querying the requested field: Contact.Account
THis error came,I have updated the above What you told
I think u r trying to use {!contact.AccountId} in your visualforce page. But You hve not queried that one in your "Cont" list.
In your apex class where there is contlist=[select id,Name,Email,phone from Contact]; modify it to include Account in it.
contlist=[select id,Name,Account,Email,phone from Contact];
As per the error, you are not retrieving the account from contact but you are using it in visualforce page,
Let me know if you have any issues after doing this.
Regards
Sampath Kumar Goud
conList=[SELECT Id,Name,Account.Name,AccountId,Email,Phone FROM Contact];
Here in this query you can get AccontId and Account Name .If you need id keep AccountId ,if you need Account Name then keep Account.Name .