ASP.NET C# - Randomize Recordset

[Christopher Hayes]

Using DMX 2004, WinXP Pro, MS SQL Server 2000, ASP.NET C#.

I'm using the standard Dreamweaver Recordset behavior and want to randomize
the record returned. I know it can be done, just not sure how to do it.

Any help is appreciated.

Thanks,

Chris

[Grant Berkeley]

Stick the following at the end of your sql statement

Order by NEWID()

Hopefully that should do the trick

HTH

Grant

"Christopher Hayes" <cbhayes@sseinc.com> wrote in message
news:d02h4g$c1p$1@forums.macromedia.com...

> Using DMX 2004, WinXP Pro, MS SQL Server 2000, ASP.NET C#.
>
> I'm using the standard Dreamweaver Recordset behavior and want to
> randomize the record returned. I know it can be done, just not sure how
> to do it.
>
> Any help is appreciated.
>
> Thanks,
>
> Chris
>

[Christopher Hayes]

Thanks Grant,

Worked great.

- Chris