Dreamweaver - SQL randomize statement help please

Author

SQL randomize statement help please

Ted Rogers

2004-02-14, 3:28 am

I am trying to display a set of addresses (in a search results page)
randomly by street but have had no luck in finding a suitable piece of code.
Could anyone help please? (I'm using DWMX and Access)

Many thanks

Ted

Julian Roberts

2004-02-14, 7:28 am

Not easy. See

http://www.4guysfromrolla.com/webte...uru/rriro.shtml

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

Ted Rogers

2004-02-15, 5:28 am

"Julian Roberts" <news@charon.co.uk> wrote in message
news:c0l0r0$lqr$1@forums.macromedia.com...
> Not easy. See
>
> http://www.4guysfromrolla.com/webte...uru/rriro.shtml
>
> --
> Jules
> http://www.charon.co.uk/charoncart
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
Thanks Jules

All that seems to relate to SQL server - I'm using a simple Access database.
I am guessing it would be easier to randomize the selection on the record id
number in that case - is that straightforward? There seems little reference
to it anywhere.

Thanks

Ted