File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes What is wrong with my Quesry?!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JDBC
Reply Bookmark "What is wrong with my Quesry?!!!" Watch "What is wrong with my Quesry?!!!" New topic
Author

What is wrong with my Quesry?!!!

Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
Dear Friends,
I want to get list where text is equal to open(text=open) why is not returning any thing?
Thanks,
Elahe
-------
rs =stmt.executeQuery("select s.text,b.bugNumber,b.bdesc,b.submittedDate,b.contact,u.name from bug b, user u, statusDesc s where b.ID=s.ID and b.userId=u.userId and s.text='open'");


Thanks,
Elahe
Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
Got solved.
 
IntelliJ Java IDE
 
subject: What is wrong with my Quesry?!!!
 
Threads others viewed
I have a question....
Need help! Request Headers!
How can I show part of my text in my template?
I try to get whole row from database but...
wrong query?
WebSphere development made easy
without the weight of IBM tools
http://www.myeclipseide.com

cast iron skillet 49er

more from paul wheaton's glorious empire of web junk: cast iron skillet diatomaceous earth rocket mass heater sepp holzer raised garden beds raising chickens lawn care CFL flea control missoula heat permaculture