Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-12-2002, 05:15 AM   #1
juliebme
Junior Member
 
Join Date: Dec 2001
Location: PA USA
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
juliebme
Send a message via ICQ to juliebme
XML Parser

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.

juliebme is offline   Reply With Quote
Old 03-12-2002, 03:14 PM   #2
Alexandre
Senior Member
 
Join Date: Feb 2001
Posts: 794
Thanks: 0
Thanked 5 Times in 5 Posts
Alexandre is on a distinguished road
You cannot attach files to a post.
What code do you have so far? What error message do you get? Where?

Alex
__________________
Alex
Alexandre is offline   Reply With Quote
Old 03-13-2002, 01:57 AM   #3
juliebme
Junior Member
 
Join Date: Dec 2001
Location: PA USA
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
juliebme
Send a message via ICQ to juliebme
Hi Alex. I thought I already emailed this to you, but I will email it to you again. Thanks for your help!

Julie

juliebme is offline   Reply With Quote
Old 03-13-2002, 06:07 AM   #4
Alexandre
Senior Member
 
Join Date: Feb 2001
Posts: 794
Thanks: 0
Thanked 5 Times in 5 Posts
Alexandre is on a distinguished road
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).]
__________________
Alex
Alexandre is offline   Reply With Quote
Old 03-13-2002, 10:16 AM   #5
juliebme
Junior Member
 
Join Date: Dec 2001
Location: PA USA
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
juliebme
Send a message via ICQ to juliebme
Thank you very much! Huge help!

I love these forums!

Have a good day.

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

juliebme is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 12:33 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World