Seed being cached when using Rnd from asp

[Bill Morrison]

Soloution:

1. Pass random number in querystring to results page.
2. On results page pass this random number in the string to the Access query
3. In the Access query Order By like this:

ORDER BY Rnd((Table.ID-[@varRandomNumber]));

[Ray at]

What?

Ray at work

"Bill Morrison" <bmorrison@whiteimage.com> wrote in message
news:dadd3bb8.0402110731.17741d2a@posting.google.c om...

> Soloution:
>
> 1. Pass random number in querystring to results page.
> 2. On results page pass this random number in the string to the Access

query

> 3. In the Access query Order By like this:
>
> ORDER BY Rnd((Table.ID-[@varRandomNumber]));

[Bob Barrows [MVP]]

Bill Morrison wrote:

> Soloution:
>
> 1. Pass random number in querystring to results page.
> 2. On results page pass this random number in the string to the
> Access query
> 3. In the Access query Order By like this:
>
> ORDER BY Rnd((Table.ID-[@varRandomNumber]));

Uuuummm ... thanks .... I guess ...

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ken Schaefer]

You are talking about the seed being cached by Jet, not by ASP. Nothing to
do with ASP.

Cheers
Ken

"Bill Morrison" <bmorrison@whiteimage.com> wrote in message
news:dadd3bb8.0402110731.17741d2a@posting.google.c om...
: Soloution:
:
: 1. Pass random number in querystring to results page.
: 2. On results page pass this random number in the string to the Access
query
: 3. In the Access query Order By like this:
:
: ORDER BY Rnd((Table.ID-[@varRandomNumber]));