User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 456,583 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,644 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums

retrieve data from database into jsp(urgent)!!!

Join Date: Jan 2007
Location: Austin, TX
Posts: 30
Reputation: Memento is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
Memento Memento is offline Offline
Light Poster

Solution Re: retrieve data from database into jsp(urgent)!!!

  #3  
Jan 14th, 2007
Originally Posted by aditi19mitra View Post
hi guys,
i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.


To get the results in the correct order you can add an ORDER BY clause to your query. DESC stands for descending which will start with the hightest values first.

SELECT t.col_1, t.col_2, t.date_col
FROM some_table t
WHERE t.col_1 = ‘something’
ORDER BY t.date_col DESC
Reply With Quote  
All times are GMT -4. The time now is 6:27 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC