Recordset sorting.

[mgid]

I'm trying to sort a recordset and I keep getting the following error:

"Current provider does not support the necessary interfaces for sorting or filtering."

I've tried it several different ways and the same error keeps coming up.

Thanks.

 

[lobstah]

can you post your code?

 

[mgid]

I'm returning the recordset from a component. Data is retrieved and writes to the page fine except when the sort method is called. Here's my code abbreviated:

Dim objCalls, objRS
Set objCalls Server.CreateObject("helpdesk.Calls&quot
Set objRS = Server.CreateObject("ADODB.Recordset&quot
objCalls.OpenCalls boolOpen, strSort, objRS, date_start, date_end

If blah, blah
objRS.Sort = "mystring"
End if

 

[lobstah]

do you have this:

The CursorLocation property will need to be set to adUseClient.

see for

http://www.devguru.com/technologies/ado/quickref/recordset_sort.html

more info.

 

[mgid]

Thanks, that worked.

I think I tried to set that property in the asp page earlier, but it didn't work. It did work when I set the property in the component that returns the recordset.