Re: XML to ADO Recordset and Back again



An excellent catch. I am in fact adding them after the fact. I'll try
removing them and see if that makes a difference.

Sorry about the attachment - I don't post often to newsgroups and sometimes
the relevant netiquette escapes me. Thanks for your flexibility.

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:%23Y60chfqIHA.672@xxxxxxxxxxxxxxxxxxxxxxx
OK, I couldn't help taking a quick look. What struck me was that there
were extra, non-standard tags (<Future /> <No_Est /> <Open />
<xSale />). Were they added by your code? My theory at the moment is
that they are confusing the parser and preventing the rest of the
records from being recognized by the recordset object. Please try
removing them before opening the recordset on the xml document and let
us know it that solves the issue.

Barry Seymour wrote:
Attached.

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:OP88wVYqIHA.672@xxxxxxxxxxxxxxxxxxxxxxx
Yes, let's see the saved xml so we can repro it ourselves.

Barry Seymour wrote:
Sorry, didn't help. I still get only one row.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.



.



Relevant Pages

  • Re: XML to ADO Recordset and Back again
    ... Barry Seymour wrote: ... records from being recognized by the recordset object. ... Please reply to the newsgroup. ... quicker response by posting to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: XML to ADO Recordset and Back again
    ... records from being recognized by the recordset object. ... removing them before opening the recordset on the xml document and let ... Barry Seymour wrote: ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: XML to ADO Recordset and Back again
    ... records from being recognized by the recordset object. ... removing them before opening the recordset on the xml document and let ... Barry Seymour wrote: ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Median calculation
    ... Already answered in another newsgroup to which you posted the same question. ... Dim rs As DAO.Recordset ... 'Open a recordset on the table. ... DMedian = rs ...
    (microsoft.public.access.queries)
  • Re: Access sending data to Word VBA Userform
    ... To get assistance on that, it would be best to ask in an Access newsgroup, ... Doug Robbins - Word MVP ... Dim rs As DAO.Recordset ... ' Set the number of Columns = number of Fields in recordset ...
    (microsoft.public.word.vba.userforms)