Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
    Bookmark Topic Watch Topic
  • New Topic

rs.next skips the first row while printing

 
Pranit Sonawane
Ranch Hand
Posts: 172
Java MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi al I have an application in which there is one receipt number and which will be given to the same customer as customer is going to buy more than one product at a time. For example customer buys products as below

product x = 250
product y = 300
product z = 400

hence total bill will be of
x + y + z = 950
but the receipt number will be the same

now below is my query


To view results am doing this:



now what is it doing that if the customer has purchased the 3 products namely x ,y ,z then it actually skips the first record i.e. it fetches only y & z product but displays the total = 950 where in it should display the total as 550.

Can anybody help me why it is skipping the very first record? Please help me out with this
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65337
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please do not post the same question more than once.
 
    Bookmark Topic Watch Topic
  • New Topic