🚀 go-pugleaf

The queries are returned by sequence number ordering implicitly, I would prefer
to be able to change that but you can easily do forward and reverse order any
customer ordering would require your own new finder.

Set the sequence numbers in the cattogrp for root categories and in the
catgrprel for subcategories and they should show up in the correct order in your
display.

Automagically.
:-)
geo

Anthony Pomtree wrote:

> 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
> >
> >