A little help with random records

[Jeff Uchtman]

I have read 10000 opinions on returning random records and I am more
confused now that before I started. I have a small access db that will
contain 20 or so rows with 3 or 4 columns. I like to return a set of 6
distinct rows and display the columns in html. I have seen response.write
and loops but can't I throw the 6 random rows in a array and pull the data
as I need it in the page? Examples?

More confused than ever
Jeff

[Evertjan.]

Jeff Uchtman wrote on 26 okt 2005 in
microsoft.publi c.inetserver.as p.general:

I have read 10000 opinions on returning random records and I am more
confused now that before I started. I have a small access db that
will contain 20 or so rows with 3 or 4 columns. I like to return a
set of 6 distinct rows and display the columns in html. I have seen
response.write and loops but can't I throw the 6 random rows in a
array and pull the data as I need it in the page? Examples?

Why would you do that? It is quite possible with a serverside array with
all records data, but at least tat would be uneducational.

I hope your records have an unique index field.

Simply get an array of the available index numbers and randomly select 6.

Then pull the 6 from the database, using "SELECT ..WHERE id = " & IDnumber

A mdb-database is random access.

If you get stuck in some part of your coding this NG will help you out.

--
Evertjan.
The Netherlands.
(Replace all crosses with dots in my emailaddress)