Re: XMLTOCURSOR

Tech-Archive recommends: Speed Up your PC by fixing your registry

its badly formed.
<Summary> is not delineated properly as a column specifier, although there
is a </Summary> end tag.
It's missing a '>' in its starting section.

I would suggest Process/Success/Reject are also datapoints without proper
delineation for corresponding columns.

You can parse it low level and match up the tags and see where its failing.

good luck.
regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Scott" <Scott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C71D6926-170B-404E-A45D-AE525A6D9474@xxxxxxxxxxxxxxxx
We recieve files offsite. Here is one such file:

<?xml version="1.0" encoding="UTF-8"?>
<Report>
<ReportMessage>Successful without rejections - Succès sans
rejets</ReportMessage>
<Summary Process="3" Success="3" Reject="0">
</Summary>
</Report>

To the average joe, is can be confusing so, of course, I want to pull it
into a cursor so I can present it better.
When I use XMLTOCURSOR on this, I get "unable to infer xml schema". I
can't
seem to find the problem. Help?


.

Relevant Pages

  • Re: XMLTOCURSOR
    ... swdev2 wrote: ... is not delineated properly as a column specifier, ... there is a end tag. ... It's missing a '>' in its starting section. ...
    (microsoft.public.fox.helpwanted)
  • Re: XMLTOCURSOR
    ... Villi Bernaroli wrote: ... is not delineated properly as a column specifier, ... there is a end tag. ... It's missing a '>' in its starting section. ...
    (microsoft.public.fox.helpwanted)
  • Re: perl grammer help
    ... some of the records are not delimitted end missing, ... and  collect informtion of what ever date,thats  in the record ... Write perl grammer tokenise the records? ... #we can only detect missing BEGIN tags after an END tag ...
    (perl.beginners)
  • Re: Git-commits mailing list feed.
    ... > Because then you have all those special cases with fetching them and with ... grabbing missing commits, and from there fetching any missing tree and ... And any form of validation of a tag is a special operation. ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: Some img tages being stripped out in ASP.NET 2.0
    ... Hi Nick, ... I have the same problem with an Adrotator. ... browser locally but SOMETIMES the tag is completely missing when ...
    (microsoft.public.dotnet.framework)