easy question, but the answer?

[woodywyatt]

I've searched high and low for an answer for this..

I'm using ASP - VBScript - Windows 2003 server an access database, with ODBC
connection

I have a recordset result of say 30 records.


I want to display all records randomly each time the page is reloaded.

Is there a way to do this? The only thing of come accrss so far is using
GetRows() which justy confuses me even further..

[Julian Roberts]

It's not viable with Access. Your main hope is to stream the recordset into
an array using getrows() and then randomly sort the array. See

[url]http://www.4guysfromrolla.com/webtech/sqlguru/rriro.shtml[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Julian Roberts]

Specifically

[url]http://www.4guysfromrolla.com/webtech/110800-1.3.shtml[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[woodywyatt]

Thanks Julian
The page loads/connects fine but I've got absolutely no idea how to 'bind'
anything to the page so I can check the results!
Just a blank page is shown
[url]http://www.webewitch.com/classifieds/accommodation_rand.asp[/url]
Any idea?
Gary


"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d3ofj9$5dl$1@forums.macromedia.com...

> Specifically
>
> [url]http://www.4guysfromrolla.com/webtech/110800-1.3.shtml[/url]
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>