all records in random orde?

[woodywyatt]

Ok, this has probably been asked a thousand times, apologies for repeating..
Is there a tutorial or extension to display all records from a recordset in
a random order?
I've tried using various options such as ORDER BY RAND() in the sql
statement but none seem to work.
At present my sql is -

SELECT *
FROM upload
WHERE Date>DateAdd('yyyy',-1,Now());

I also need to display all records in random order
Thanks for any help
Gary

[Drew]

Hopefully you are using SQL Server, if so here is a good start,

[url]http://www.sqlteam.com/item.asp?ItemID=8747[/url]

Drew

"woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
news:d3eed5$gvq$1@forums.macromedia.com...

> Ok, this has probably been asked a thousand times, apologies for
> repeating..
> Is there a tutorial or extension to display all records from a recordset
> in
> a random order?
> I've tried using various options such as ORDER BY RAND() in the sql
> statement but none seem to work.
> At present my sql is -
>
> SELECT *
> FROM upload
> WHERE Date>DateAdd('yyyy',-1,Now());
>
> I also need to display all records in random order
> Thanks for any help
> Gary
>
>

[woodywyatt]

I'm using a Windows 2003 server an access database, with ODBC connection
Is there anywhere I can find info about displaying all records in random
order using this kind of set up?!
Thanks
Gary


"Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:d3eigi$muj$1@forums.macromedia.com...

> Hopefully you are using SQL Server, if so here is a good start,
>
> [url]http://www.sqlteam.com/item.asp?ItemID=8747[/url]
>
> Drew
>
> "woodywyatt" <woodywyatt@fuerteventura.com> wrote in message
> news:d3eed5$gvq$1@forums.macromedia.com...

> > Ok, this has probably been asked a thousand times, apologies for
> > repeating..
> > Is there a tutorial or extension to display all records from a recordset
> > in
> > a random order?
> > I've tried using various options such as ORDER BY RAND() in the sql
> > statement but none seem to work.
> > At present my sql is -
> >
> > SELECT *
> > FROM upload
> > WHERE Date>DateAdd('yyyy',-1,Now());
> >
> > I also need to display all records in random order
> > Thanks for any help
> > Gary
> >
> >

>
>