Re: [Catalyst] Retrieve all users belong to a category and all its sub categories

Not sure how to do it in a DBIC-like fashion, but these few links show you how to do it in SQL for PostgreSQL and MySQL. Oracle and DB2 have hierarchical functionality built-in. http://www.postgresql.org/docs/8.4/static/queries-with.html http://dev.mysql.com/tech-resources/articles/hierarchica

[Catalyst] Suggestions on how to handle 12 page form

Hi. I'm working on the project request section of our new project tracking system. The request form is broken up into 12 pages-yes, lots and lots of data to be submitted. Anyone have any experience / advice on how to handle that many fields? Should I use a single subroutine to handle it all