This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JSP and the fly likes Max(Date) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Max(Date)" Watch "Max(Date)" New topic
Author

Max(Date)

kalyan
Greenhorn

Joined: Jan 22, 2002
Posts: 5
i wanna select the maximum date from the database.
my database is MYSQL and i access my database using JSP.
I tried the following the query
select Max(WeeklyDate) from tblWeeklyReport;
Weekly date is a coloumn in the table tblWeeklyReport.
but it's giving the following error
coloumn not found
so cud someone suggest me as to how to retrieve the maximum date from the dates already stored in the database thru JSP.
Madhav Lakkapragada
Ranch Hand

Joined: Jun 03, 2000
Posts: 5040
"kalyan"
your name deosn't agree with the javaranch guidelines. Please take a moment and re-register after reviewing the guidelines at http://www.javaranch.com/name.jsp
thanks for your cooperation.
- satya


Take a Minute, Donate an Hour, Change a Life
http://www.ashanet.org/workanhour/2006/?r=Javaranch_ML&a=81
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Max(Date)
 
Similar Threads
jsp table
inserting a string containing date into oracle table which has the date type field
RETREIVING MAX (DATE) FROM DATABASE
EJBQL
how to synchornize "select"?