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>