I've done this by creating href object for each column, which call internal call
"First", and inclueded the following code:
----------------------------------------
//[[SPIDER_EVENT<ondoSortCol1WebEvent>
public int ondoSortCol1WebEvent( String args[] )
{
int command = PROCEED_WITH_BUILTIN_HANDLING;
CSpSelect select = (CSpSelect) CSpider.getDataObject("doSelectEmpDepartment");
select.setSelectOrderStr("FAC_EMPLOYEE.PSOFT_EMPLID,FIN_EMP_DEPARTMENT.DEPTID");
command = doAction(args); // execute goto 'First'
return(command);
}
//]]SPIDER_EVENT<ondoSortCol1WebEvent>
-----------------------------------------------
I hope it helps.
Bogdan
[EMAIL PROTECTED] wrote:
> I have a results page with columns of infomation populated as the result of a bound
>DataObject query. The DataObject sql
> has a default sort order of Position_Number (the leftmost column on the page)
>ascending. I would like to duplicate the
> behavior of an MFC CListControl by clicking the column heading to change the sort
>order primary key. This would require
> changing the "SelectOrder" section of the DataObject .sdo file to reflect the
>changed primary sort key. Does anybody have
> a recomendation on how to implement a dynamic column sort?
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
