• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

rs.next() returning false for second row..

 
Ajit Kanada
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I am using jdk1.4 SQL200 to retrive data from miltiple tables..
I have following code..
I get problem in rsForQuery2.next() ie for second dynamic query it shows rsForQuery2.next() is false so its unable to enter while ..
what can be the problem?
Ajit
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
most likely, your query returns no matches. Did you check your query ( cut and pasted for your System.out.println() ) in your SQL editor to verify that indeed the query returns results?
Jamie
 
Ajit Kanada
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Yes u are correct .
Its because i had only one row..
Thanx for the reply
Ajit
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic