You need to sign in to do that
Don't have an account?
shephali
Error: Compile Error: Illegal assignment from List<AggregateResult> to List<Contact_Agent__c> public class Verify { public list<Code> C{set;get;} public Verify() { C=[select MAX(Code__c) from Contact_Agent__c]; } } how to correct it?
Error: Compile Error: Illegal assignment from List<AggregateResult> to List<Contact_Agent__c>
public class Verify {
public list<Code> C{set;get;}
public Verify()
{ C=[select MAX(Code__c) from Contact_Agent__c];}
}
how to correct it???
public class Verify {
public list<Code> C{set;get;}
public Verify()
{ C=[select MAX(Code__c) from Contact_Agent__c];}
}
how to correct it???
MAX(Code__c) will return single value not bulk...so no need to use "pageblocktable",simply use <apex:outputtext>
<apex:page controller="Verify" sidebar="false">
<apex:form >
<apex:pageBlock >
Max Value is : <apex:outputText value="{!c}" ></apex:outputText>
</apex:pageblock>
</apex:form>
</apex:page>
+++++++++++++++++++++++++++++++++++++++++++++++++
public class Verify {
public Object C{set;get;}
public Verify(){
AggregateResult[] groupedResults = [select MAX(Code__c)maxvalue from Contact_Agent__c];
c= groupedResults[0].get('maxvalue');
}
}
All Answers
modify your code like below....
public class Verify {
public Object C{set;get;}
public Verify(){
AggregateResult[] groupedResults = [select MAX(Code__c)maxvalue from Contact_Agent__c];
Object c= groupedResults[0].get('maxvalue');
}
}
Thanks for Your reply.here now I am unable to fetch this object to VF page.
I am getting this error.
Error: Unknown property 'Object.Code__c'
provide me vf code also...
here is the vf code with error.
Error: Unknown property 'Object.Code__c'
<apex:page controller="Verify" sidebar="false">
<apex:form >
<apex:pageBlock>
<apex:pageblocktable value="{!Code}" var="c">
<apex:column value="{!c.Code__c}"/>
</apex:pageblocktable>
</apex:pageblock>
</apex:form>
</apex:page>
MAX(Code__c) will return single value not bulk...so no need to use "pageblocktable",simply use <apex:outputtext>
<apex:page controller="Verify" sidebar="false">
<apex:form >
<apex:pageBlock >
Max Value is : <apex:outputText value="{!c}" ></apex:outputText>
</apex:pageblock>
</apex:form>
</apex:page>
+++++++++++++++++++++++++++++++++++++++++++++++++
public class Verify {
public Object C{set;get;}
public Verify(){
AggregateResult[] groupedResults = [select MAX(Code__c)maxvalue from Contact_Agent__c];
c= groupedResults[0].get('maxvalue');
}
}
It is working....:)