🚀 go-pugleaf

In my JSP (for category display) I have the following:

<jsp:useBean id="category"
class="com.ibm.commerce.catalog.beans.CategoryDataBean" scope="page">
<%
category.setCategoryId(categoryId);
category.setCatalogId(catalogId);
com.ibm.commerce.beans.DataBeanManager.activate(category, request);
%>
</jsp:useBean>

CategoryDataBean subcats[], cat;
subcats = category.getSubCategories();

<%
for (int i = 0; i < subcats.length; ++i)
{
      cat = subcats[i];
      if (cat.getDescription().getPublished().equals("1"))
      {
%>
<tr><td><div align="right"><font face="Arial" size="-2" class="linkstyle">
<a href="blah.html"
class="linkstyle"><%=cat.getDescription().getName()%></a></font></div>
</td></tr>
<%
    }
}
%>

----------------------------------------------------------------------------
-------------------

I need to be able to sort these by their sequence number, but from what I
can
see the sequence number is not something that can be gotten through any
getter.
So my thinking was I need to create a customized bean that extended
CategoryDataBean... or something along those lines.  Am I just thinking
wrong
or is there another way to handle this?

Thanks.

"Thomas Tolborg" <news@tolborg.dk> wrote in message
news:aa7065$19ns$1@news.boulder.ibm.com...
> "Anthony Pomtree" <apomtree@yahoo.com> wrote in message
> news:aa6oeu$165a$1@news.boulder.ibm.com...
> > Trying to set up shopping page that pulls back list of categories from
> > DB2 table.  Process works fine, but I need to customize and add a
> > field (sequence number) so I can have the categories sorted based
> > on a sequence number on the table.  I assume I need to create my
> > own custom bean that extends a current data bean in order to be able
> > to sort on the sequence number.  If this is correct, could someone
> > please give a little (actually a lot) of insight on this... if this is
not
> > the
> > case, could you please set me straight.
> >
> > Thanks.
> >
> > p.s.  Examples would be most appreciative.
> >
>
> What is it exactly that you want to do. There is already a sequence column
> on the relationtables (CATGRPREL, CATTOGRP, CATGPENREL).
>
> Remember that if you uses the sequence column, then you are forced to sort
> the categories the same way in every language, which might not be a good
> idea.
>
> /Thomas Tolborg
>
>