just thinking out loud here.
since the resultset is so low, the overhead here would be minimal.
You could have a function that takes the number in the resultset and
then returns a randomly generated list of those numbers. Loop
through that list at presentation using the number as the queryrow.
function randomNumbers('1,2,3,4,5,6,7,8,9,10')
pull a random location for the list, append the number from that list
location to the list to be returned. Keep doing this until you have
all the numbers accounted for.
display.
Loop list item=x
#queryname].column[x]#
William
On Mar 14, 2008, at 10:19 AM, Jeff F wrote:
> I need to query an Access Database for a few records (10 to 15)
> that meet a criteria, then display the results randomly. There's
> many ways to query randomly, but once I have my 10 records, I need
> a way to display them randomly.
>
> I've got a few ugly ideas about having a number of queries each
> with a different ORDER BY, then randomly running one query.
>
> Is there a nifty way to do this at the output?? I can't think of
> anything.
>
> -jeff
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301286
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
