In the Studio, when you make a DataObject 'Partially overridable', the
studio asks you what part of the SQL you want to override, and shows you a
small cute list which contains 'OrderBy' among other things. With this
setting, you should be able to do
dataObject.setSqlTextOrder(String)
Never tried this stuff, but should hopefully work.
Aby
> -----Original Message-----
> From: Datta, Sushovan [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 18, 1999 5:30 PM
> To: 'Curt Springer';
> [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ND] Sorting on columns on a results page
>
> 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]
_________________________________________________________________________
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]
