How to display results in 3s then line break it?

Report · Feb 08, 2012

I was on a website and saw that they had their results displaying in a row of 3 then it <br/> to the next row. I have been searching high and low for days on how they did that. I know it can be done manually, but the question is if it can be done dynamically?

For example:

Search results = 37

I would like to display it as follows

Result # 1 :: Result # 2 :: Result # 3 <br/>

Result # 4 :: Result # 5 :: Result # 6 <br/>

Result # 7 :: Result # 8 :: Result # 9 <br/>

and so on.

Hope that all makes sense.

Report · Feb 08, 2012

Yes, you can do this using the MOD operator, which returns the remainder from division. Using this, you can identify numbers that are evenly divisible within other numbers.

</tr><tr>

</cfif>

Dave Watts, CTO, Fig Leaf Software

Dave Watts, Eidolon LLC

Report · Feb 10, 2012

Thanks for the reply Dave.

I tried it in the code, but it didn't seem to work. I used CurrentRow and RecordCount functions where the X is and it doesn't display the first 3 on the same row then break on the 3rd one. Here's the code if it helps.

--------------- Code ----------------

SELECT FirstName, LastName, Party, PersonID, Island

FROM PersonInfo

ORDER BY FirstName

</cfquery>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<tr>

<td>

<a href="../persons/?Person=#PersonID#">#FirstName# #LastName#</a><br />

#Party#

</td>

</tr><tr>

</cfif>

</cfoutput>

</table>

</body>

</html>

------------------- End Code ------------------

I again i tried both functions.

Report · Feb 10, 2012

Problem Number 1:

<tr>

Those two lines should be reversed.

Problem Number 2:

</tr><tr>

</cfif>

</cfoutput>

</table>

This is incomplete. You need to account for the last record or two in your query results. If you leave it unchanged, you will be missing a closing tr tag.

Report · Feb 13, 2012

I found an old string on the forums here with someone having the same issue. The following is exactly what i needed to finish this. I had no clue how to complete this. Dan's reply was right, but i didn't know exactly how to finish it to account for the last part of the record.

</tr>

<tr>

</cfif>

Thanks again to everyone for the replies and help.

How to display results in 3s then line break it?

1 Correct answer