Home › Building Your Website › Web Database Development

Random Display of Records in a Access Database

simon posted this at 12:47 — 12th September 2000.

They have: 12 posts

Joined: Mar 2000

Hi,

I have ten items in my Microsoft Access database, that I display in a ASP web page.

What I would like to do is this, when I go back to this page the display of my images be Random.

I would like that everytime that I see this page, the images are not displayed in the same order.

How can I do that?

Also, what is the best way to display records in columns?

I would like to 4 columns and when I have more items, there is a Loop that do another row.

Simon Baillargeon
Usuall Software
(48) 438-7401

Simon Baillargeon

JamesUS posted this at 16:10 — 13th September 2000.

They have: 11 posts

Joined: Jul 2000

I'm not sure about displaying random records, but here is how I would display a table of records:

Do While rs.eof = 0
response.write("<TR><TD>" & rs("recordname"))
rs.movenext
loop
'

I can't quite remember the syntax for the While loop, but I think thats right.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.