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 Sql not working for multiple rows Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Sql not working for multiple rows" Watch "Sql not working for multiple rows" New topic
Author

Sql not working for multiple rows

Rakesh Keerthi
Ranch Hand

Joined: Jul 16, 2012
Posts: 144
Hi,

My below code is working only if there is a single row. could you please help me in doing it for all the rows retrieved from the database.




please help me with it.

Thanks
Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

just to get it over with jsp and servlets

you are creating many forms with the same name... won't that be a problem. infact you are making lots of buttons with the same name each time round the loop.

Try writing this as a static page, and finding out how to make it work, then if you want to become a good developer move the sql to a servlet, then write the web page properly.
Rakesh Keerthi
Ranch Hand

Joined: Jul 16, 2012
Posts: 144
Hi Wendy,

Thanks for the reply. I've moved my SQL code to a servlet, now what to do? i'm still getting the same result.

Wendy Gibbons
Bartender

Joined: Oct 21, 2008
Posts: 1107

Wendy Gibbons wrote:just to get it over with jsp and servlets

you are creating many forms with the same name... won't that be a problem. infact you are making lots of buttons with the same name each time round the loop.

Try writing this as a static page, and finding out how to make it work
, then if you want to become a good developer move the sql to a servlet, then write the web page properly.


Now do the bit in bold
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Sql not working for multiple rows