• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
Ranch Hand
Posts: 98
  • 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
 
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
 
Aji Ozkan
Ranch Hand
Posts: 98
  • 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
Boost this thread!