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

unexpected token: Order
hi
i trying to sort the columns in pageblock table..
i am getting the error.. unexpected token: Order
code in class:
public ApexPages.StandardSetController con{get; set;}
//SETS THE SORT DIRECTION FOR THE SORTING COLUMN
public String sortExpression{
get {
return sortExp;
}
set {
//if the column is clicked on then switch between Ascending and Descending modes
if (value == sortExp)
sortDirection = (sortDirection == 'DESC')? 'ASC' : 'DESC';
else
sortDirection = 'ASC';
sortExp = value;
}
}
//method returning sort direction value i.e ASC
public String getSortDirection(){
//if not column is selected
if (sortExpression == null || sortExpression == '')
return 'ASC';
else
return sortDirection;
}
//METHOD TO SORT THE SEARCH RESULT COLUMNS
public void sortData(){
if(searchQuery != null && searchQuery.length() > 0) {
String sortFullExp = sortExpression + ' ' + sortDirection;
system.debug('*****'+sortFullExp);
con = new ApexPages.StandardSetController(Database.getQueryLocator(searchQuery + ' Order By ' + sortFullExp + ' limit 5000'));
con.setPageSize(20);
}
}
page:
<apex:pageBlockTable value="{!canlist}" var="cc">
<apex:column headerValue="Candidate Name" value="{!cc.Name}">
<apex:facet name="header">
<apex:commandLink action="{!sortData}" value="Name{!IF(sortExpression=='Name',IF(sortDirection='ASC','▲','▼'),'')}" id="relOrg" status="splashStatus" reRender="searchResultPanel" onclick="setSubmit();">
<apex:param value="Name" name="Name" assignTo="{!sortExpression}" ></apex:param>
</apex:commandLink>
</apex:facet>
</apex:column>
<apex:column value="{!cc.Email__c}">
<apex:facet name="header">
<apex:commandLink action="{!sortData}" value="Email{!IF(sortExpression=='Email__c',IF(sortDirection='ASC','▲','▼'),'')}" id="relg" status="splashStatus" reRender="searchResultPanel" onclick="setSubmit();">
<apex:param value="Email__c" name="Name" assignTo="{!sortExpression}" ></apex:param>
</apex:commandLink>
</apex:facet>
</apex:column>
<apex:column value="{!cc.Number__c}">
</apex:column>
</apex:pageBlockTable>
Does the controller variable searchQuery have a 'select fieldlist from someSobject where somefilter' and all literal strings are properly surrounded by matching quotes?
Add a debug statement for searchquery so you can see what it looks like -- then, use SFDC Workbench or Eclipse IDE to verify that your SOQL statement is valid
thanks
athi