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 Relational Databases 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


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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