🚀 go-pugleaf

In Doctor Dobs Journal (approx. January 2000 issue) is prity article and
good alghorithm on making card-shuffling. (Random order the array).

You can do in in the stored procedure or in the ASP client by JavaScript.
Tomas T.



Shawn M. Hooper <shawn@smh.on.ca> p�e v diskusn�m
p��sp�vku:e_xr4.5037$c7.232905@news1.rdc1.on.wave.home.com...
> The only way I can think of doing this off the top of my head is to read
> that data from the recordset into an array (does ASP support arrays??) and
> then get random numbers from the array to show the data.
>
> However, this could take up significant amounts of resources depending on
> the size of the recordset.
>
> Just my $.02
>
>
>
>
> "Anthony Gatlin" <gatlina@yahoo.com> wrote in message
> news:KJqr4.12655$8S2.373870@news1.rdc1.tn.home.com...
> > Oh wise ones,
> >
> > I am writing a web based application that needs to retrieve the records
> from
> > a query in a random order.  Then once the records are "jumbled" the
> > application can simply use the vbscript/ADO .movenext and .moveprevious
> > methods. I have looked at several options but have found none that work.
> The
> > Order By Clause appears to only return records in ascending or
descending
> > order. It would be an absolute last resort to return a recordset and
then
> > try to randomly jump back and forth within the record set. The recordset
> > really needs to be randomized once per session and then remain in the
same
> > order through multiple passes.
> >
> > Any advice or hints would be GREATLY appreciated!
> >
> > Thank you in advance.
> >
> > Anthony
> >
> >
>
>