I don't understand why you want it random. Multiple pages doesn't explain
why to me.
If you just want next and previous GROUPS instead of next and previous
records (even in the case of a differing number of records in each group)
this just takes arithmetic as in the news items grouped by day on my wife's
website at www.bike70th.com
OTOH, if you want to give different Groups "top billing" then a rotation
scheme might be simpler.
best, paul
At 08:22 AM 12/27/00 -0500, you wrote:
>I want the CFQUERY to randomize the groups, A, B, C; B C A, etc...
>so I can get:
>row1: Group B
>row2: b-1
>row3: b-2
>row4: b-3
>row5: Group C
>row6: c-1
>row7: c-2
>row8: c-3
>row9:Group A
>row10: a-1
>row11: a-2
>row12: a-3
>
>I want it like this because this information is displayed over
>multiple pages and I pass the row number between the pages with a
>Next and Previous button.
>
>I hope this is clearer.
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup
from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit
SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
