[ale] OT: Nested sql statements

[Christopher Fowler]

Use Vectors to group stuff


On Mon, 2002-06-24 at 17:50, Kevin O'Neill Stoll wrote:
> Hey all,
> 
> I'm building an XML resultset in a JavaBean which I then send to a JSP
> which transforms the result into html. I have a grouping issue
> that I'm not sure how to tackle the 'best' way.
> 
> The output looks something like this:
> An Assignment, which has many codes
>    A code, which has many deliverables
>       deliverables, which there are many of
> 
> 
> So far I have two ideas but I'm not really happy with either. The
> first is to have a nested resultset in the JavaBean that would produce the
> proper grouping in the XML document. The second is to do some conditional
> processing in the XSL stylesheet to get the grouping to come out right.
> 
> I don't like the nested resultsets because it just seems ugly. I really
> don't like the stylesheet idea because it seems really ugly. Great
> reasons, huh? :p
> 
> Anywho, I would appreciate some ideas and pointers as to how I could
> accomplish this with a clean and efficient solutions.
> 
> TIA,
> 
> 
> =====
> Kevin Stoll
> http://kevinstoll.org
> 
> OpenSource Software...FREE!
> Angering Bill Gates...priceless.
> ============================================================
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> 
> ---
> This message has been sent through the ALE general discussion list.
> See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
> sent to listmaster at ale dot org.
> 
> 
> 



---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.