I don't use the tags very much, so I'm speculating, but my guess is:
<
jsp:useBean id="sh" class="com.bean.SaleHandler" scope="request"/>
That will instantiate, *one time*, a bean of the type SalesHander, and put it in request scope under the 'sh' variable name.
So, even though you've got it inside a loop, and you're adding it to a list,
you can't use the 'usebean' tag to instantiate a new bean every time through the loop. It's just going to re-use the same instance over and over again.
If that's true, then I expect this statement of yours:
> except the print section prints the first instance over-and-over,
is slightly not accurate. it's actually printing the *last* query row, over and over. Right?
[ December 10, 2008: Message edited by: Mike Curwen ]