You could add the "order by" clause as a dynamic criteria to the dataobject.
You could get the column name as a "web var" and use it to sort the result
set.
Hope this helps.
-----Original Message-----
From: Curt Springer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 18, 1999 5:22 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ND] Sorting on columns on a results page
Hi,
I don't know what the best approach would be, but another option would be
to unbind the DO, have a DO for each sort, then execute the appropriate DO
and set the results set values into the fields.
Not elegant, but sometimes the clunky approach works better.
-- Curt Springer, Team NetDynamics
At 02:09 PM 5/18/99 -0800, [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]
>
_________________________________________________________________________
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]
_________________________________________________________________________
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]
