This method requires the text override mode of the data object to be set to
partial text override to work.
Check that the SQLTextOverrideSelect property of the data object is set to
Partial.
If this still cannot work, try using the setSqlTextOrder() method instead .
It has the same method signature as setSelectOrderStr(), and I do not know
the difference between them.
But I've actually have tried out the former and it works fine for me.
> -----Original Message-----
> From: Kaluza, Isabel SLGA [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 20, 1999 11:08 PM
> To: '[EMAIL PROTECTED]'
> Subject: [ND] Changing Order by Clause Dynamically
>
> I have a page connected to the following dataobject
> SELECT dbo.Subscribers.Name, dbo.Subscribers.SubscriberID,
> dbo.Subscribers.Password, dbo.Subscribers.Address1,
> dbo.Subscribers.Address2, dbo.Subscribers.PostalCode,
> dbo.Subscribers.AgentNo, dbo.Subscribers.SupplierCode,
> dbo.Subscribers.EffectiveDate, dbo.Subscribers.ExpiryDate,
> dbo.Subscribers.Active, dbo.Subscribers.Privs, dbo.Subscribers.SLGAUser,
> dbo.Subscribers.EmailAddress FROM dbo.Subscribers ORDER BY
> dbo.Subscribers.SubscriberID ASC
>
>
> ON THE PAGE I have 3 buttons. When a user hits one of the buttons I want
> the order in the select clause above to change. The following logic
> worked
> in ND 3.1.x. The button was pressed, the page was reloaded with order by
> clause changed. In ND 4.x I try the following and IT DOESN"T WORK.
> AM I USING setSelectOrderStr correct based on the above Select Statement??
>
>
> Here is the code for one of the buttons
> //[[SPIDER_EVENT<btSortName_onWebEvent>
> public int btSortName_onWebEvent(CSpWebEvent event)
> {
> CSpSelect vDetailObject1 = (CSpSelect) CSpider.getDataObject
> ("doqSubscribersMain");
> vDetailObject1.setSelectOrderStr ("Name");
> this.load("pgSubscribersMain");
> return(PROCEED);
> }
> //]]SPIDER_EVENT<btSortName_onWebEvent>
>
> What AM I DOING WRONG?
> Thanx for the help...
>
> Isabel Kaluza
> Junior Systems Planning Analyst
> Saskatchewan Liquor and Gaming Authority
> <mailto:[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]
