Re: Maybe it's a bug



Lorry Astra wrote:
Thank u for your answer, Mark.

1.Although Recordset usually don't be used to parse xml, i think the
recordset should not to tell me the result is 1 . it should be 3.

You cannot alter the structure of the xml and expect ADO to handle the
result correctly.

2. The reason why i revise the structure is that: i wanna sort the
xml. And i used XSL to sort my XML. Before i sorted it, the style was
"<z:row .../>", but after i sorted it by using XSL, the style was
changed to "<z:row ....></z:row>"

Why aren't you using the recordset's Sort method?

3. And u know, i use the recordset to fill a grid. so if the
recordcount is 1 , the grid will show only 1 row instead of 3. it
should list 3 rows. that's correct.

Bottom line: you cannot alter the structure of the xml and expect ADO to
handle the result correctly.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.



Relevant Pages

  • Re: problem with XMLHttp refreshing changing data
    ... var list = document.getElementById; ... NOTE: the ASPX files return an XML string in the following format: ... it seems to show cached data or something.. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.jscript)
  • Re: MDAC Converting Dataset to XML
    ... I have a slight confession to make that changes this very slightly. ... I earlier mentioned that taking a valid piece of XML and converting ... newsgroups that deal with XML, ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Maybe its a bug
    ... You cannot alter the structure of the xml and expect ADO to handle the ... the change she describes does not alter the ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Timing Rescordset
    ... I would like to create the tables as I parse the XML, ... array, and then record back to the table every 1000 lines of XML. ... saved parameter query. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Timing Rescordset
    ... The XML may contain many records, ... an array, and then record back to the table every 1000 lines of XML. ... parameters to a saved parameter query. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)