Re: XML to ADO Recordset and Back again

THAT WAS IT! THANK YOU THANK YOU THANK YOU!

This is five year old legacy code. The extra empty elements you mentioned
were added in code to assist with sorting and filtering, something I'm
trying to fix/improve by using ADO instead. They would become redundant and
would be removed anyway were I to get this to work -- and now I can.

I can't thank you enough. You've cleared a month-old bottleneck for me.
Many, many thanks!

Barry



"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
    ... 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
    ... 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
    ... removing them and see if that makes a difference. ... records from being recognized by the recordset object. ... 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)