Re: Witango-Talk: Need help with XML parsing probably simple

Dan Stein Fri, 16 Jun 2006 15:17:55 -0700

Title: Re: Witango-Talk: Need help with XML parsing probably simple

Steve yes that is similar to what Bev and I worked out. I am in the processing of fixing this up so that it will get a little more info and also I am going to do it in x Path also and will send the taf back to the list.

Thanks everyone for the prompt response and help.

on 6/16/06 17:39, Fogelson, Steve at [EMAIL PROTECTED] wrote:

Dan,

I’m not real good at this, but I will take a stab at it.

I tested this and I think it gives you what you are looking for.

<@ASSIGN request$Total_Array value=<@ARRAY rows=10 cols=2>>
<@FOR start=1 stop=10>
<@ASSIGN request$Total_Array[<@CURROW>,1] <@ELEMENTVALUE object='request$resultSet' element='root().child(1).child(1,Service,ID,<@calc "<@CURROW>-1">).child(5)'>>
<@ASSIGN request$Total_Array[<@CURROW>,2] <@ELEMENTVALUE object='request$resultSet' element='root().child(1).child(1,Service,ID,<@calc "<@CURROW>-1">).child(7)'>>
</@FOR>

Steve Fogelson
Internet Commerce Solutions

From: Dan Stein [mailto:[EMAIL PROTECTED]
Sent: Friday, June 16, 2006 1:30 PM
To: [email protected]
Subject: Witango-Talk: Need help with XML parsing probably simple

Sorry here is the attachment
This attached is the XML returned from USPS after I send a rate request.

I just need one of two things

At least to get in a one column array the postage. It always comes back in the same order so I can easily grab what I want from even the one column array.
An added bonus would be to have a two column array one with the method svcDescription

I think all I have messed up is the child declarations

I am trying

<@ASSIGN request$Total_Array value=<@ARRAY rows=10 cols=1>>

        <@FOR start=1 stop=10>


               <@ASSIGN request$Total_Array[<@CURROW>,1] <@ELEMENTVALUE object=request$result element=root().child(1).child(2).child(<@CALC <@CURROW>>).Child(5) type=text>>



        </@FOR>

Boy is this easier in FileMaker I just need the element name Postage and the occurrence to get the value.

Anyway any help would be much appreciated.

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com

"It's very hard to grow, because it's difficult to let go of models of ourselves in which we've invested so heavily."

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Need help with XML parsing probably simple

Reply via email to