•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 375,171 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 2,129 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:
Views: 7138 | Replies: 3
 |
•
•
Join Date: Sep 2006
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
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.
•
•
Join Date: Jan 2007
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by aditi19mitra 
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.
this is simple u have to make a onject of Resultset and then access the value retrieved by object.next();......might this will work
•
•
Join Date: Jan 2007
Location: Austin, TX
Posts: 30
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
Re: retrieve data from database into jsp(urgent)!!! •
•
•
•
Originally Posted by aditi19mitra
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
•
•
•
•
access avatar backup breach broadband code combo crime daniweb data data protection data transfer database design drive dropdownlist forensics government hacker hard hardware hitachi ibm internet linux medicine module net news normalization reuse security server sql storage survey terabyte web wikipedia
- retrieving a single cell of data from a MySQL database (PHP)
- insert data from one form into two diffent database table (JSP)
- urgent jdbc code (Java)
- retrieve data by VB.Net (VB.NET)
- error due to accessing database connection using jsp (JSP)
- Problem connecting my Tomcat Server and MySQL using JSP (JSP)
- Posting form data to an Oracle database (JavaScript / DHTML / AJAX)
Other Threads in the Oracle Forum
- Previous Thread: I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle
- Next Thread: Load date+hour with a ctl
