BomberMan2K
Programmer
Hi,
I'm having an issue with randomizing an ACCESS query results.
I have an index of people, which I want to show in random order each time the page loads (the page is written in ASP of course).
I've tried the RND() approach - but it always returns the same result (even if I use a random key. Can't use Randomize() in ASP code so it will affect the query).
Sql Server has NEWID() function - to really randomize things, but that doesn't apply to Access DB.
Tried to construct a VB Script in the DB, but it can't be activate inside the query when being executed from ASP pages (or can it?!)
I would really appreciate any help or ideas...
Thanks guys,
Roman.
I'm having an issue with randomizing an ACCESS query results.
I have an index of people, which I want to show in random order each time the page loads (the page is written in ASP of course).
I've tried the RND() approach - but it always returns the same result (even if I use a random key. Can't use Randomize() in ASP code so it will affect the query).
Sql Server has NEWID() function - to really randomize things, but that doesn't apply to Access DB.
Tried to construct a VB Script in the DB, but it can't be activate inside the query when being executed from ASP pages (or can it?!)
I would really appreciate any help or ideas...
Thanks guys,
Roman.