You own parser?
Find in a do while loop with
ATCatc('<section id="production.shipping">',lcXML)
all needet sections and extract them.
lcXML= your_xmlString
Lnstart=atc('<section id="production.shipping">',lcXML)
lni=1
Do While Lnstart#0
...... find end of this section and extract the value
lni=lni+1
Lnstart=atc('<section id="production.shipping">',lcXML,lni)
EndDo
Joerg Arand MD
assistant medical director
Neonatology
Children's Hospital
University Tuebingen
Calwer Str. 7
D-72076 Tuebingen
Tel.+49-(0)7071-2982211
Tel.+49-(0)7071-2980895 (office)
E-mail:Joerg.Arand(AT)med.uni-tuebingen.de
>>> "Stephen Russell" <[EMAIL PROTECTED]> 29.07.2008 16:29 >>>
I have a column in a table that is like a vfp memo.
I have XML data stored there that will pull off and use all over the
place in our apps. I have to identify there is any value in the
production.shipping attribute.
XML data looks like so:
<specialInstruction>
<section id="customerSuppliedShippingAccount"></section>
<section id="customerCare"></section>
<section id="finance"></section>
<section id="production.general"></section>
<section id="production.inventory"></section>
<section id="production.packaging"></section>
<section id="production.prePress"></section>
<section id="production.printJob"></section>
<section id="production.shipping">Package in Non-Mimeo Packaging; Use
appropriate FedEx Packaging</section>
</specialInstruction>
Currently I pull the data into ram, stuff it into the DOM and then do this:
XmlNode packageNode =
Node.SelectSingleNode("/specialInstruction/[EMAIL
PROTECTED]'production.shipping']");
if (packageNode.ChildNodes.Count > 0)
sishipping.ShippingText = packageNode.ChildNodes[0].Value;
I may have 3, or 5 rows of this type of data to iterate through, in
that I can have 5 different Special Instructions attached to a single
order.
I just need the shipping data. This is the same extraction I use for
the top line "customerSuppliedShippingAccount"
Any other ideas?
TIA
--
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN
901.246-0159
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
