cfoutput data into categories

Question

I have a database query that returns a book titile and list it ... however some of the books will have a category to them and I want to list the category and then the books titles under that ... Do I need to create an array or can I do it in a cfloop.

Sample

BookTitle 1

BookTitle 2

Category

BookTitle 1

BookTItle 2

Booktitle 3

Carl Von Stetten · Answer

Depending on how your query recordset is structured, If you are using <cfoutput>, you should be able to use the "group" attribute to group on your category. Just specify the name of the column that holds the categories. I believe that books without categories will get lumped together.

-Carl V.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded