How to sort an ADO recordset

[jfield817]

I need to sort a recordset in an ASP/ADO app........

Creating a second record set by setting a Sort property
and then applying the OpenRecordset method doesnt seem to be supported anymore or else my syntax isnt right.

RsOldset.Sort = "[Name]"
Set NewSet = RsOldset.OpenRecordset()

Any ideas ?

Thanks
John

 

[culshaja]

Have you tried the refresh method after issuing the sort?

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[culshaja]

As a further note, you must be using a client-side recordset to use the sort property..

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[jfield817]

Culshaja
I am getting an ASP error msg that the OpenRecordset
Object isn't supported.

Thanks
John

 

[culshaja]

It isn't, its just

Open

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305