It sounds like this is probably coming from an SQL database? If it is modify the query you're using to sort on the DBML-side. If your query looked like: select * from books You would modify it. Having mutliple levels of order by varies from DBMS to DBMS, but it'll look something like this: select * from books order by book_name, id Or something to that effect. Sorting using the DBMS is more desirable as well because the DBMS is likely to sort it more quickly, with all its indicies and so forth. If you tell me which DBMS you're using, I probably know exactly what you should do to your query. Mario Lang wrote:
Hi.
I am constructing a search interface for a catalog. The objects I index have three relevant properties: title (textual title) id (the id, sortable) book_title (the name of the book where the chapter is included)
I want to have atabular result like this:
Book 1 Chapter 1.1 Chapter 2.1 Book 2 Chapter 1.1 Chapter 4.2
To acomplish this I currently do something like:
<dtml-in Catalog sort=id> <tr> <td><dtml-if first-book_title><dtml-var book_title></dtml-if></td> <td><dtml-var title></td> </tr> </dtml-in>
But, to have the list look nice, I'd need to specify two fields for sorting, book_title should be the primary field sorted by, and id should be the field all identical book_title entries should be sorted on.
Is there a way to do this with dtml-in?
CYa, Mario <mlang@delysid.org>
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- Ken Kinder 303.381.7631