944,144 Members | Top Members by Rank

Ad:
  • Oracle Discussion Thread
  • Unsolved
  • Views: 18986
  • Oracle RSS
Oct 14th, 2006
0

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

Expand 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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
aditi19mitra is offline Offline
1 posts
since Sep 2006
Jan 12th, 2007
0

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

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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
sandeep0708 is offline Offline
6 posts
since Jan 2007
Jan 14th, 2007
1

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

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
Reputation Points: 12
Solved Threads: 0
Light Poster
Memento is offline Offline
30 posts
since Jan 2007
Dec 28th, 2007
0

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

try with cusom tags
Reputation Points: 10
Solved Threads: 0
Newbie Poster
arunaponnuraj is offline Offline
1 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle
Next Thread in Oracle Forum Timeline: Load date+hour with a ctl





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC