• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Showing resultSet

 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am trying to print all specialty of specific category that is selected by cv holder. sId will mark checkbox checked if this already exist in db against this cv but the output is wrong as its display many duplicate records. Please help me



Thanks & best regards
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What happens if you run these queries in your sql client software?
Do you get the results that yi$ou want there?
 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't see duplicates.
 
Kuldip Shetty
Ranch Hand
Posts: 43
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Logic in Inner while loop is wrong. See my comments below in else block

 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What should I do? I mean how can I correct it?

Thanks for your reply
 
Kuldip Shetty
Ranch Hand
Posts: 43
Eclipse IDE Java
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Test the below code and verify if it works as you expected. Hope the below code helps

 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your favorable reply and giving me your precious time.

I just copy pasted the following code after ps1.close(); and its work fine



I am thankful again from the bottom of my heart

Best regards
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic