Actually adLongVarWChar is not sortable, because it belongs to BLOB data
type
--
Val Mazur
Microsoft MVP
> I got it!!! Thanks for your help. My XML file schema was
> just not descriptive enough.
> - Brian
> >-----Original Message-----
> >Good call. It is not an Integer in the RS. It is a
> >adLongVarWChar. I am not familiar with that data type.
> >Is it sortable? Evidently not! :-)
> >Do you know why it is changing?
> >- Brian
> >>-----Original Message-----
> >>Is it same integer in recordset? Check Type property of
> >then field.
> >>--
> >>Val Mazur
> >>Microsoft MVP
> >>> It is defined as an integer in the XML file
> >>> >-----Original Message-----
> >>> >Hi,
> >>> >What is the data type of pre_petition field? In case
> if
> >>> it is BLOB type of
> >>> >field, you cannot use Sort
> >>> >--
> >>> >Val Mazur
> >>> >Microsoft MVP
> >message
> >>> >> I am using the following code (I have also attached
> >my
> >>> XML
> >>> >> file) to try to load a RS from an XML file and sort
> >>> it. I
> >>> >> know I could just sort the XML file, but I have my
> >>> reasons
> >>> >> for wanting to di it via ADO. I keep getting a Sort
> >>> Order
> >>> >> Cannot Be Applied error. Any ideas?
> >>> >> Dim rsXmlData
> >>> >> Dim oStream
> >>> >> Set rsXmlData = Server.CreateObject
> >("ADODB.Recordset")
> >>> >> Set oStream = Server.CreateObject("ADODB.Stream")
> >>> >> oStream.Open
> >>> >> oStream.Charset = "UTF-8"
> >>> >> oStream.LoadFromFile Server.MapPath
> >>> >> ("../xml/ACCT_LIST_SM.xml")
> >>> >> oStream.Position = 0
> >>> >> rsXmlData.CursorLocation = adUseClient
> >>> >> rsXmlData.CursorType = adOpenStatic
> >>> >> rsXmlData.LockType = adLockBatchOptimistic
> >>> >> rsXmlData.Open oStream
> >>> >> rsXmlData.Sort = "pre_petition DESC"
> >>> >.
> >>.
> >.
by