OK, now I understand.
1. Create an algorithm that randomly orders the integers 1,2,...26 with
each request
2. Re-order your result query according to the order of the integers in
(1). That is, assign records starting with "A" the Order_ID of "1", assign
those starting with "B" the Order_ID of "2", etc. Then output to page in
order of Order_ID (perhaps randomly selecting ascending and descending).
Some tags in the developer exchange might help on this.
best, paul
PS> There are probably some smart folks on CF-TALK who can come up with a
clever way of doing this. I'm a Civil Engineer, which means brute force
always comes to mind first ;-_
At 10:15 AM 12/27/00 -0500, you wrote:
>>I don't understand why you want it random. Multiple pages doesn't
>>explain why to me.
>
>So that each time a person searches the same criteria every group gets an
>equal chance to be shown 'up front'.
>
>>
>>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.
>
>Yes I do, but not every group shows up in every search...whichever groups
>result I want to show randomly placed. The site I'm working on is
>Guitarlist.com is you'd like to take a look.
>
>If a person searches for Fender Stratocaster the results are the same but
>I want to mix up the groupings each time to give each dealer more visibility.
>
>>
>>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.
>
>--
>**This signature sponsored by GuitarList.com - the most powerful musical
>instrument search engine on the net!**
>
>"I've gotten so out of shape sittin' at the computer all day that I get
>out of breath when I have to reach for the percent key!" - Zeitman
~~~~~~~~~~~~~ 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
