function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sivapriyaa maniam sivakumarsivapriyaa 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>  
Best Answer chosen by sivapriyaa maniam sivakumar
Hanimi ReddyHanimi Reddy
<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="{!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

Hanimi ReddyHanimi Reddy
<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="{!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....
This was selected as the best answer
sivapriyaa maniam sivakumarsivapriyaa maniam sivakumar
Hi Hanimi Reddy,
Thanks. I got it.