XML Parser (1 Viewer)

juliebme · Mar 12, 2002

I am working on an XML parser to pars out and XML string that is stored in the document field of my referral table. The parser will create two new tables: Import and referral. Append all referrals to that table. (referrals are stored in referral table where type = 0) If the Import & Dependent tables already exists it should delete these tables & overwrite them. I keep getting the same error message. What am I doing wrong? How do you attach a file to this post? Anyone who replies, I can email them the completed database.

Thanks.

Alexandre · Mar 12, 2002

You cannot attach files to a post.
What code do you have so far? What error message do you get? Where?

Alex

juliebme · Mar 13, 2002

Hi Alex. I thought I already emailed this to you, but I will email it to you again. Thanks for your help!

Julie

Alexandre · Mar 13, 2002

Julie,

From a first look:

Code:

If iChildren = 1 AND Not node.childNodes(0).nodeName = "#text" Then
    GoTo DumpNext
End If

Will return an error (no object) if there is no element in the ChildNodes collection.
I changed it to:

Code:

If iChildren = 1 Then
    If Not node.childNodes(0).nodeName = "#text" Then
          GoTo DumpNext
    End If
End If

And your parser seemed to work nicely.

I did not check it thoroughly yet, though.

Alex

[This message has been edited by Alexandre (edited 03-13-2002).]

juliebme · Mar 13, 2002

Thank you very much! Huge help!

I love these forums!

Have a good day.

Julie http://members.acsworld.net/bcp/

XML Parser (1 Viewer)

juliebme

New member

Alexandre

Registered User.

juliebme

New member

Alexandre

Registered User.

juliebme

New member

Similar threads

Users who are viewing this thread