Hi Everbody, Our Testing/production server is having following problem, any suggestion, advice or pointers will greatly help- I have a search page with several text boxes and a combo box for sorting by various data fields. On the web event of search button I take the selected value from the combobox & add to the DO using setSqlTextOrder(..). The result page shows 20 records at a time and it has next and prev buttons. The DO used for getting the results does not use caching as we deal with real time data. PROBLEM: When ever I use the sort by combobox it gets the result in order as desired in the first page but when I use the next button it uses the order by the field I had used the last time and then again if I use the next button it orders by correct field. Since I am not using caching for that DO ND sends the sql every time I use the next button, I saw the sql it is sending is changing alternately reagrding the order by field. QUESTIONS: Why would it change the sql alternately, is it bringing it from cache some where? How can I fix it? This is not happening in the development env. could it be a function of RDBMS service parameters like No.of workers etc? TIA Vishal _________________________________________________________________________ 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]
