You need to sign in to do that
Don't have an account?

soql query not returning a value in vf page
Hi All,
iam trying to retrive the data from 2 sobjects using soql qury and trying to show in vf page but the records in child object are displayed here is the apex code
public class veepage2
{
public string ss{get;set;}
list<Physician__c>ph=new list<Physician__C>();
public list<Physician__c>getme()
{
ph=[select id,LastName__c,FirstName__c , PhysicianProd__r.PatientsOT3Mon__c,PhysicianProd__r.DCs12WeeksInd__c,PhysicianProd__r.LowConversionRateInd__c,PhysicianProd__r.NonTitratedPatientsInd__c,PhysicianProd__r.PotentialSwitchesInd__c,PhysicianProd__r.HighDCsDeathAEInd__C,PhysicianProd__r.Week8WriteInd__c,PhysicianProd__r.Week12ClaimsInd__c from Physician__C where PhysicianId__c='9900000300336'];
return p;
}
}
********************************************
<apex:page controller="veepage2" >
<apex:form >
<apex:pageBlock >
<apex:pageblocktable value="{!me}" var="m">
<apex:column value="{!m.LastName__c}"/>
<apex:column value="{!m.FirstName__c}"/>
<apex:column value="{!m.PhysicianProd__r.PatientsOT3Mon__c}"/>
<apex:column value="{!m.PhysicianProd__r.DCs12WeeksInd__c }"/>
<apex:column value="{!m.physicianprod__r.LowConversionRateInd__c}"/>
<apex:column value="{!m.physicianprod__r.NonTitratedPatientsInd__c}"/>
<apex:column value="{!m.physicianprod__r.NonTitratedPatientsInd__c}"/>
<apex:column value="{!m.physicianprod__r.PotentialSwitchesInd__c}"/>
<apex:column value="{!m.PhysicianProd__r.HighDCsDeathAEInd__c}"/>
<apex:column value="{!m.PhysicianProd__r.Week8WriteInd__c}"/>
<apex:column value="{!m.PhysicianProd__r.Week12ClaimsInd__c}"/>
</apex:pageblocktable>
</apex:pageBlock>
</apex:form>
</apex:page>
Try this.
All Answers
Try this.
Try this one controller : ---
public class veepage2
{
public string ss{get;set;}
list<Physician__c>ph{get;set;}
public void me()
{
ph = new list<Physician__c>();
ph=[select id,LastName__c,FirstName__c , PhysicianProd__r.PatientsOT3Mon__c,PhysicianProd__r.DCs12WeeksInd__c,PhysicianProd__r.LowConversionRateInd__c,PhysicianProd__r.NonTitratedPatientsInd__c,PhysicianProd__r.PotentialSwitchesInd__c,PhysicianProd__r.HighDCsDeathAEInd__C,PhysicianProd__r.Week8WriteInd__c,PhysicianProd__r.Week12ClaimsInd__c from Physician__C where PhysicianId__c='9900000300336'];
}
}
If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.
Hi naidu,
Thanks for the reply .it helped me a lot
Thanks,
Harsha