function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Harshal Katole 7Harshal Katole 7 

dynamic searching value

getting error : 
Error is in expression '{!fetchData}' in component <apex:commandButton> in page searchcoursevf: Class.SearchCourse.fetchData: line 8, column 1
An unexpected error has occurred. Your development organization has been notified.


public class SearchCourse {
    public string SearchText {set;get;}
     public string query {set;get;}
     public List<Training_Deal__c> traindeal {set;get;}
    public void fetchData(){
       
        string query = 'SELECT id, Name, Course__c,Discount__c,Student__c,Email_of_Student__c,Trainer_Appointed__c FROM Training_Deal__c WHERE Course__c =\''+SearchText+'\' ';
        traindeal=Database.query(query);
        system.debug(traindeal);
    }

}
==============================
<apex:page controller="SearchCourse" >
    <apex:form id="fm">
        <apex:inputText value="{!SearchText}"/>
        <apex:commandButton value="Search" action="{!fetchData}" reRender="fm"/><br/><br/>
        <apex:dataTable value="{!traindeal}" var="a" cellpadding="5"  rules="Rows" width="20" border="frame">
            <apex:column value="{!a.Name}" headerValue="Deal code"/>
            <apex:column value="{!a.Course__c}" headerValue="Course"/>
            <apex:column value="{!a.Discount__c}" headerValue="Discount"/>
            <apex:column value="{!a.Student__c}" headerValue="Student"/>
            <apex:column value="{!a.Email_of_Student__c}" headerValue="Student Email"/>
            <apex:column value="{!a.Trainer_Appointed__c}" headerValue="Trainer"/>
  
                         
        </apex:dataTable>
    </apex:form>
</apex:page>
Suraj Tripathi 47Suraj Tripathi 47

Hi,

You can take references from the below code.

<apex:page standardController="Account" extensions="MyPageController">
    <apex:form>
	    <apex:commandButton action="{!method}" value="Are you sure?"/>
    </apex:form>
</apex:page>
public class MyPageController {

	private String recordId;

    public MyPageController(ApexPages.StandardController controller) {
        recordId = controller.getRecord().Id;
    }
    
 	public void method() {
    // Do whatever with recordId
    }
}

If your queries are solved please mark it as the Best Answer.

Thank You

 
ravi soniravi soni
hy Harshal,
In my org code is working fine. you can take referance from below code. 
<apex:page controller="SearchCourse" >
    <apex:form id="fm">
        <apex:inputText value="{!SearchText}"/>
        <apex:commandButton value="Search" action="{!fetchData}" reRender="fm"/><br/><br/>
        <apex:dataTable value="{!traindeal}" var="a" cellpadding="5"  rules="Rows" width="20" border="frame">
            <apex:column value="{!a.Name}" headerValue="Deal code"/>
            <apex:column value="{!a.AccountNumber}" headerValue="Account Number"/>
            <!--<apex:column value="{!a.Discount__c}" headerValue="Discount"/>
            <apex:column value="{!a.Student__c}" headerValue="Student"/>
            <apex:column value="{!a.Email_of_Student__c}" headerValue="Student Email"/>
            <apex:column value="{!a.Trainer_Appointed__c}" headerValue="Trainer"/>-->
  
                         
        </apex:dataTable>
    </apex:form>
</apex:page>

---------------------------------------------------------------------------
public class SearchCourse {
    public string SearchText {set;get;}
     public string query {set;get;}
     public List<Account> traindeal {set;get;}
    public void fetchData(){
       
        string query = 'SELECT id, Name,AccountNumber FROM Account WHERE Name =\''+SearchText+'\' ';
        traindeal=Database.query(query);
        system.debug(traindeal);
    }

}

maybe there is something wrong in your query so take referance from my code.
let me know if it helps you and marking it as best answer.
Thank you