File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Struts and the fly likes Recording sql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Recording sql query" Watch "Recording sql query" New topic
Author

Recording sql query

kirankumar dondapati
Greenhorn

Joined: May 25, 2007
Posts: 4
i have id-primary key,jobNo-it can have repeated values,owner of job and start date fields in a table. i want to write query which will extract current owner of job ,jobno, with the date when the job was started for example
ID jobNo ownerofjob startdate
1 99 kiran 8-02-07
2 99 dondapati 09-03-07
3 99 sunil 12-03-07
4 1000 ask 14-03-07
i want result as 99,sunil and date 8-02-07(when the job started)
please help regarding this .
Ajit Kanada
Ranch Hand

Joined: Jan 23, 2001
Posts: 95
Why ar eu posting this in Struts forum?
Please use JDBC forums


Thankx
Ajit
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Recording sql query
 
Similar Threads
question reg. a stored procedure
regarding sql query
Refresh Problem
Issue Whie Deploying EJB on JBoss AS 5.1.0...
How to show results as zero if no record exists?