You need to sign in to do that
Don't have an account?
sivapriyaa maniam sivakumar
Error:Unknown property 'SearchController.Loc__c'
Hi everyone,
I am getting error "Unknown property 'SearchController.Loc__c' " in VisualForce Page.Please review the code .
Let me know where i did mistake.
Thanks in advance
Apex Code :
public with sharing class SearchController {
private String soql {get;set;}
public List<Loc__c> Searchlocation {get;set;}
public String sortDir {
get { if (sortDir == null) { sortDir = 'asc'; } return sortDir; }
set;
}
public String sortField {
get { if (sortField == null) {sortField = 'location'; } return sortField; }
set;
}
public void runQuery() {
try {
Searchlocation = Database.query(soql + ' order by ' + sortField + ' ' + sortDir + ' limit 20');
} catch (Exception e) {
ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'));
}}
public PageReference runSearch() {
String location = Apexpages.currentPage().getParameters().get('location');
soql = 'select Comp__c,Client__c, Competitor__c, Type__c,Event_Name__c, Et_Desc__c , Et_Addr__c, Dt_Ti__c, Ct_person__c,Ph_Num__c, from loc__C where loc__c != null';
runQuery();
return null;
}
}
VF Code:
<apex:page controller="SearchController" sidebar="false">
<apex:form >
<apex:pageBlock title=" Find a Location" mode="edit">
<table width="100%" border="0">
<tr>
<td width="200" valign="top">
<apex:pageBlock title="Parameters" mode="edit" id="criteria">
<script type="text/javascript">
function doSearch() {
searchServer(
document.getElementById("location").value,
);
}
</script>
<apex:actionFunction name="searchServer" action="{!runSearch}" rerender="results">
<apex:param name="location" value="" />
</apex:actionFunction>
<table cellpadding="1" cellspacing="1">
<tr>
<td style="font-weight:bold;">Location<br/>
<input type="text" id="location" onkeyup="doSearch();"/>
</td>
</tr>
</table>
</apex:pageBlock>
</td>
<td valign="top">
<apex:pageBlock mode="edit" id="results">
<apex:pageBlockTable value="{! Loc__c}" var="location">
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Company Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Comp__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Comp__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Client Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Client__C" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Client__C}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Competitor Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Competitor__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Competitor__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Type" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Type__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Type__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Event Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Event_Name__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Event_Name__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Event Description" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Event_Desc__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Event_Desc__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Date and Time" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Dt_Ti__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Dt_Ti__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Contact Person" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Ct_person__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Ct_person__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Phone Number" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Ph_Num__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Ph_Num__c}"/>
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock>
</td>
</tr>
</table>
</apex:pageBlock>
</apex:form>
</apex:page>
I am getting error "Unknown property 'SearchController.Loc__c' " in VisualForce Page.Please review the code .
Let me know where i did mistake.
Thanks in advance
Apex Code :
public with sharing class SearchController {
private String soql {get;set;}
public List<Loc__c> Searchlocation {get;set;}
public String sortDir {
get { if (sortDir == null) { sortDir = 'asc'; } return sortDir; }
set;
}
public String sortField {
get { if (sortField == null) {sortField = 'location'; } return sortField; }
set;
}
public void runQuery() {
try {
Searchlocation = Database.query(soql + ' order by ' + sortField + ' ' + sortDir + ' limit 20');
} catch (Exception e) {
ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Ooops!'));
}}
public PageReference runSearch() {
String location = Apexpages.currentPage().getParameters().get('location');
soql = 'select Comp__c,Client__c, Competitor__c, Type__c,Event_Name__c, Et_Desc__c , Et_Addr__c, Dt_Ti__c, Ct_person__c,Ph_Num__c, from loc__C where loc__c != null';
runQuery();
return null;
}
}
VF Code:
<apex:page controller="SearchController" sidebar="false">
<apex:form >
<apex:pageBlock title=" Find a Location" mode="edit">
<table width="100%" border="0">
<tr>
<td width="200" valign="top">
<apex:pageBlock title="Parameters" mode="edit" id="criteria">
<script type="text/javascript">
function doSearch() {
searchServer(
document.getElementById("location").value,
);
}
</script>
<apex:actionFunction name="searchServer" action="{!runSearch}" rerender="results">
<apex:param name="location" value="" />
</apex:actionFunction>
<table cellpadding="1" cellspacing="1">
<tr>
<td style="font-weight:bold;">Location<br/>
<input type="text" id="location" onkeyup="doSearch();"/>
</td>
</tr>
</table>
</apex:pageBlock>
</td>
<td valign="top">
<apex:pageBlock mode="edit" id="results">
<apex:pageBlockTable value="{! Loc__c}" var="location">
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Company Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Comp__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Comp__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Client Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Client__C" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Client__C}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Competitor Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Competitor__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Competitor__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Type" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Type__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Type__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Event Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Event_Name__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Event_Name__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Event Description" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Event_Desc__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Event_Desc__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Date and Time" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Dt_Ti__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Dt_Ti__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Contact Person" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Ct_person__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Ct_person__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Phone Number" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Ph_Num__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!Loc__c.Ph_Num__c}"/>
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock>
</td>
</tr>
</table>
</apex:pageBlock>
</apex:form>
</apex:page>
<apex:form >
<apex:pageBlock title=" Find a Location" mode="edit">
<table width="100%" border="0">
<tr>
<td width="200" valign="top">
<apex:pageBlock title="Parameters" mode="edit" id="criteria">
<script type="text/javascript">
function doSearch() {
searchServer(
document.getElementById("location").value,
);
}
</script>
<apex:actionFunction name="searchServer" action="{!runSearch}" rerender="results">
<apex:param name="location" value="" />
</apex:actionFunction>
<table cellpadding="1" cellspacing="1">
<tr>
<td style="font-weight:bold;">Location<br/>
<input type="text" id="location" onkeyup="doSearch();"/>
</td>
</tr>
</table>
</apex:pageBlock>
</td>
<td valign="top">
<apex:pageBlock mode="edit" id="results">
<apex:pageBlockTable value="{!Searchlocation}" var="location">
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Company Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Comp__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Comp__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Client Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Client__C" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Client__C}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Competitor Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Competitor__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Competitor__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Type" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Type__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Type__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Event Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Event_Name__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Event_Name__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Event Description" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Event_Desc__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Event_Desc__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Date and Time" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Dt_Ti__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Dt_Ti__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Contact Person" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Ct_person__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Ct_person__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Phone Number" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Ph_Num__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Ph_Num__c}"/>
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock>
</td>
</tr>
</table>
</apex:pageBlock>
</apex:form>
</apex:page>
Use this code....
All Answers
<apex:form >
<apex:pageBlock title=" Find a Location" mode="edit">
<table width="100%" border="0">
<tr>
<td width="200" valign="top">
<apex:pageBlock title="Parameters" mode="edit" id="criteria">
<script type="text/javascript">
function doSearch() {
searchServer(
document.getElementById("location").value,
);
}
</script>
<apex:actionFunction name="searchServer" action="{!runSearch}" rerender="results">
<apex:param name="location" value="" />
</apex:actionFunction>
<table cellpadding="1" cellspacing="1">
<tr>
<td style="font-weight:bold;">Location<br/>
<input type="text" id="location" onkeyup="doSearch();"/>
</td>
</tr>
</table>
</apex:pageBlock>
</td>
<td valign="top">
<apex:pageBlock mode="edit" id="results">
<apex:pageBlockTable value="{!Searchlocation}" var="location">
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Company Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Comp__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Comp__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Client Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Client__C" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Client__C}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Competitor Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Competitor__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Competitor__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Type" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Type__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Type__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Event Name" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Event_Name__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Event_Name__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Event Description" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Event_Desc__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Event_Desc__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Date and Time" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Dt_Ti__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Dt_Ti__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Contact Person" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Ct_person__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Ct_person__c}"/>
</apex:column>
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Phone Number" action="{!toggleSort}" rerender="results">
<apex:param name="sortField" value="Ph_Num__c" assignTo="{!sortField}"/>
</apex:commandLink>
</apex:facet>
<apex:outputField value="{!location.Ph_Num__c}"/>
</apex:column>
</apex:pageBlockTable>
</apex:pageBlock>
</td>
</tr>
</table>
</apex:pageBlock>
</apex:form>
</apex:page>
Use this code....
Thanks. I got it.