recordset loses sort when passed to asp
when I call a method in a dll that returns a sorted recordset, the sort is lost
when called from asp but is still sorted when called from vb.
I created a method that opens a recordset (adOpenDynamic, adLockBatchOptimistic)
and CursorLocation = adUseClient. The recordset only has one column. I then
disconnect the recordset. Then I add more records to this recordset (.AddNew)
from other queries against different databases. When my recordset has all the
data I call the Sort method before returning the disconnected recordset.
when I call this method from a vb app, the recordset is returned sort.
when I call this method from an asp app, the recordset is returned unsort (the
order that the records were added)
Any Ideas? (besides maybe creating a sorted string array)
Or maybe there is a better way to create a recordset that combines data from
multiple queries against multiple databases?