aspose file tools*
The moose likes Servlets and the fly likes resultset question... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "resultset question..." Watch "resultset question..." New topic
Author

resultset question...

karan, chopra
Ranch Hand

Joined: Jun 05, 2001
Posts: 115
hi folks,i have the following problem,wonder if anyone could help me out..
1.)in my servlet i execute a SQL query on one of the tables of my database,the query returns a couple of tables and stores the result in the resultset.then i display the result in my servlet.everything is fine till now..but when my query is run so that it returns some columns from 2 tables of my database then each value of the resultset is displayed 12 times on the servlet,ie,say each row is displayed a couple of times and not a single time which i want(because i am storing the different values of the resultset into different arrays)..why is this so..plz help....
thanks in advance
regards
karan
vikinsa
Ranch Hand

Joined: Apr 18, 2001
Posts: 46
That should not happen. I think there is a serious trouble with your presentation logic. Check the loops in the program.

Originally posted by karan, chopra:
hi folks,i have the following problem,wonder if anyone could help me out..
1.)in my servlet i execute a SQL query on one of the tables of my database,the query returns a couple of tables and stores the result in the resultset.then i display the result in my servlet.everything is fine till now..but when my query is run so that it returns some columns from 2 tables of my database then each value of the resultset is displayed 12 times on the servlet,ie,say each row is displayed a couple of times and not a single time which i want(because i am storing the different values of the resultset into different arrays)..why is this so..plz help....
thanks in advance
regards
karan


------------------
Vikas Aggarwal
Technology Associate
http://www.vikinsa.com


Vikas Aggarwal<BR>Technology Associate<BR>http://www.vikinsa.com
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: resultset question...