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]
