aspose file tools*
The moose likes JDBC and the fly likes Records to be displayed in ascending order retrived by calling a function through java program Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Records to be displayed in ascending order retrived by calling a function through java program" Watch "Records to be displayed in ascending order retrived by calling a function through java program" New topic
Author

Records to be displayed in ascending order retrived by calling a function through java program

haripriya vedula
Greenhorn

Joined: May 31, 2008
Posts: 24
Hi,

I have called a function from my java program which gets results and displays in jsp.

Records are displayed in descending order.
I need to display the records in ascending format . In DB I cannot edit and change the select .... orderby ...query, we dont have permissions to do that.

Any help is appreciable.

Thanks in advance

Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

You can change your method to sort your collection of results after you've got them.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Tim McGuire
Ranch Hand

Joined: Apr 30, 2003
Posts: 820

haripriya vedula wrote:Hi,

I have called a function from my java program which gets results and displays in jsp.

Records are displayed in descending order.
I need to display the records in ascending format . In DB I cannot edit and change the select .... orderby ...query, we dont have permissions to do that.

Any help is appreciable.

Thanks in advance


You probably will have to sort the returned collection in your java code, like Paul said. First, though, check the API for this "function" you have to call. You may find that there is an argument that controls sort order.
 
 
subject: Records to be displayed in ascending order retrived by calling a function through java program