• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to check if resultset has only one row or more?

 
Vidya Moorthy
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have to do a query to a table. If resultset has only one row, I have to set the bean in one particular way and if the resultset has multiple rows in a different way.
I tried


The problem with this code is even if the row count from the query is one, it sets ABC into the bean.
Should I try to get the count and then check if count > 1? If that is the case, then I have to do two queries, one to get the count and the other to do the query itself. Please advise.
Thanks in advance
Vidyaram

 
Paul Clapham
Sheriff
Posts: 21970
36
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just read the records to find out how many there are:


But if it were me I would be considering writing a query involving "count(*)" rather than potentially returning a large number of rows just to ignore them.
 
Seetharaman Venkatasamy
Ranch Hand
Posts: 5575
Eclipse IDE Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul Clapham wrote:But if it were me I would be considering writing a query involving "count(*)" rather than potentially returning a large number of rows just to ignore them.

Indeed; this is the best way
 
Vidya Moorthy
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you for posting the answers quickly!

Vidyaram
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!