XML / XSL

1-Nov-02 12:10

Do you know what would cause the construction of a Xerxes DOM parser to die? It seems like this should be valid, but I'm obviously missing something.

// DOM newbie test
DOMParser*  pDomParser = new DOMParser();  // crashes
ASSERT (pDomParser != NULL);
delete pDomParser;

Are we required to derive from DOMParser and override certain methods? Btw, I'm using a prebuilt binary of the XML4C 4.0.0 implementation. A ptr to the API docs would also be much appreciated. Thanks!

/ravi

Let's put "civil" back in "civilization"
http://www.ravib.com
ravib@ravib.com

Michael A. Barnhart2-Nov-02 2:11

Michael A. Barnhart

2-Nov-02 2:11

Are you calling the Initialize routine?
XMLPlatformUtils::Initialize();

What version are you using if not?

"We are what we repeatedly do. excellence, then, is not an act, but a habit." Aristotle

Ravi Bhavnani3-Nov-02 9:13

3-Nov-02 9:13

Thanks Michael, that did the trick!

I ended up with a purported memory leak, but the Xerxes docs say the diagnostic overagressive and can be ignored. I then switched from XML4C V4 to V5 and encountered a new problem:

When I build my (simple) Xerces test project, VC++ complains that DOMDocument (present in several Xerces header files) is an ambiguous symbol. The clash seems to occur as a result of the Platform SDK (Aug 2002) being installed on my system. Do you know how I get around this problem?

Thanks,

/ravi

Let's put "civil" back in "civilization"
http://www.ravib.com
ravib@ravib.com

Michael A. Barnhart3-Nov-02 9:34

Michael A. Barnhart

3-Nov-02 9:34

I actually have not used the Xerces C since last Jan, so I am afraid no.
Have you downloaded the current release. There was an update the end of August so maybe it was addressed with that revision.

"We are what we repeatedly do. excellence, then, is not an act, but a habit." Aristotle

Ravi Bhavnani3-Nov-02 9:42

XML Database on Client w/C#

3-Nov-02 9:42

Yes, I'm using the latest release. I've switched back to version 4 to get around the symbol clash. Thanks for your help!

/ravi

Let's put "civil" back in "civilization"
http://www.ravib.com
ravib@ravib.com

GregGacura31-Oct-02 12:37

GregGacura

31-Oct-02 12:37

Hi I am making a database that will be roughly 6 tiers. I have no problem constructing the first item that will go into the database but the second item gives me an exception error because i am unsure how to check too see if there already is an element in the database matching my new item.

Ex. I can construct this using the XmlDocument class
tier1/tier2/tier3/tier4/tier5/tier6/Bob/salary

When i try to add another person say Jane the first thing i do is attempt to reconstruct tier1 again. This gives me an exception because tier1 is already there. I require quite a few tiers to adequately group things, say tier2a, tier2b, ect.

How do i make it so if tier1 already exists then i don't try to recreate tier1, but instead set the tier1 element to an element in my program so that if i need to make a tier2c then i can have an element to make tier2c a child of?

calling all XML/XSL XPath gurus

Marc Clifton31-Oct-02 9:37

31-Oct-02 9:37

This is a follow up on my "how do I do a join" question. I think I'm about to be screwed by .NET, because this is beginning to hurt so much.

Here's the problem. I created a database schema and data using .NET's DataSet:

dataSet.WriteXml(fn, XmlWriteMode.WriteSchema);

And it dutifully creates an XML document, with the data looking like this (as an example):

(BTW, how do you embed XML as source, so it doesn't get parsed, which is why all my example here have the opening '<' MISSING!!!):

PART>
    ID>1001/ID>
    PARTNUMBER>101045/PARTNUMBER>
    DESC>FILTER, FUEL #2010SM RACOR/DESC>
  /PART>
  PART>
    ID>1002/ID>
    PARTNUMBER>101050/PARTNUMBER>
    DESC>FILTER, #2020SM RACOR/DESC>
  /PART>

Now, I've got an XSL translation that looks something like this:

?xml version="1.0" encoding="UTF-8" ?>
xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
xsl:template match="/">
xsl:for-each select="//PART[@*]">
xsl:value-of select="ID"/>
xsl:value-of select="PARTNUMBER"/>
/xsl:for-each>
/xsl:template>
/xsl:stylesheet>

as a test because it appears that fields like ID are not considered to be an attribute. (This select doesn't return any records, but a //PART[not(@*)] does return records. Instead, it seems that ID is an element (I hope I have my XPath terminology right here).

So, when I actually do an XPath query like:

xsl:for-each select="//PART[@ID='1001']">

I get no records back.

Argh! Mad | :mad:

Can I do this on the XML file that DataSet created???

Thanks a million!

Marc

Help! I'm an AI running around in someone's f*cked up universe simulator.

Christian Graus31-Oct-02 10:22

Christian Graus

31-Oct-02 10:22

You're right - you're currently looking for this

<part id="1001">

Try

//part[id='1001']

Christian

No offense, but I don't really want to encourage the creation of another VB developer. - Larry Antram 22 Oct 2002

Hey, at least Logo had, at it's inception, a mechanical turtle. VB has always lacked even that... - Shog9 04-09-2002

During last 10 years, with invention of VB and similar programming environments, every ill-educated moron became able to develop software. - Alex E. - 12-Sept-2002

Marc Clifton31-Oct-02 10:26

31-Oct-02 10:26

IT WORKED! IT WORKED! WOOOHOOO!

Thank you!

Big Grin | :-D

Marc

Help! I'm an AI running around in someone's f*cked up universe simulator.

Christian Graus31-Oct-02 10:49

Christian Graus

31-Oct-02 10:49

You're welcome. As soon as you use the @, you're checking attributes, not nodes. Also, you can use text()= to check the value of the current node.

Christian

No offense, but I don't really want to encourage the creation of another VB developer. - Larry Antram 22 Oct 2002

Hey, at least Logo had, at it's inception, a mechanical turtle. VB has always lacked even that... - Shog9 04-09-2002

During last 10 years, with invention of VB and similar programming environments, every ill-educated moron became able to develop software. - Alex E. - 12-Sept-2002

Michael Dunn31-Oct-02 13:58

Michael Dunn

31-Oct-02 13:58

Marc Clifton wrote:
BTW, how do you embed XML as source, so it doesn't get parsed

Check the "Display this message as-is (no HTML)" checkbox before submitting the post.

--Mike--
"I'd rather you just give me a fish today, because even if you teach me how to fish, I won't do it. I'm lazy." -- Nish
Just released - 1ClickPicGrabber - Grab & organize pictures from your favorite web pages, with 1 click!
My really out-of-date homepage
Sonork-100.19012 Acid_Helm

ForEx Data

shane3931-Oct-02 8:27

shane39

31-Oct-02 8:27

Hi...

Does anyone no where I can get free Foreign Exchange rate data in XML? The ECB site looked good, but i'm having problems with their schema. Also, this data is Euro based and not US$ based. I would prefer US$ based. The US gov only has ascii flat files for download, and no XML Confused | :confused:

Any help would be appreciated!
thanks
-shane

Re: ForEx Data

Ravi Bhavnani2-Nov-02 4:42

2-Nov-02 4:42

Shane, I use this Yahoo link[^]. I'm hoping to turn this into a WRP[^] one of these days.

/ravi

Let's put "civil" back in "civilization"
http://www.ravib.com
ravib@ravib.com

XML & VC++

chepuri_uk29-Oct-02 18:12

chepuri_uk

29-Oct-02 18:12

How can i create a *.xml using msxml.dll in vc++ ? Any help links..

Thank you.

ian mariano30-Oct-02 1:47

ian mariano

30-Oct-02 1:47

Create a new text file named *.xml, and save it;P

Please be more specific.

"The greatest danger to humanity is humanity without an open mind."
- Ian Mariano

http://www.ian-space.com/

Stephane Rodriguez.30-Oct-02 1:53

Stephane Rodriguez.

30-Oct-02 1:53

DOMDocument::save(...)

How low can you go ?
(MS rant)

Christian Graus30-Oct-02 10:38

Christian Graus

30-Oct-02 10:38

http://msdn.microsoft.com[^]

Christian

No offense, but I don't really want to encourage the creation of another VB developer. - Larry Antram 22 Oct 2002

Hey, at least Logo had, at it's inception, a mechanical turtle. VB has always lacked even that... - Shog9 04-09-2002

During last 10 years, with invention of VB and similar programming environments, every ill-educated moron became able to develop software. - Alex E. - 12-Sept-2002

Ravi Bhavnani2-Nov-02 4:48

2-Nov-02 4:48

See this link[^] that explains how to do this, as well as other standard operations using MSXML.

/ravi

Let's put "civil" back in "civilization"
http://www.ravib.com
ravib@ravib.com

table joins--how to???

Marc Clifton29-Oct-02 12:31

29-Oct-02 12:31

Hi, I'm new to all this XML stuff, and I'm trying to figure out how I can code a table join like you can in SQL. Is this even possible with XML? I've got an XML file with 2 tables, and I'd like to perform a query where table1.id = table2.t1_id, for example. I've looked into XPath, and it doesn't seem like it can do the trick.

Thanks!

Marc

Help! I'm an AI running around in someone's f*cked up universe simulator.

Michael A. Barnhart29-Oct-02 13:53

Michael A. Barnhart

29-Oct-02 13:53

Depends on what you are looking for. Using a transformation xslt and using the XPath select in which you match the child element (or attribute) value, in the select statement, can give you the relation. I.E. select table 1 first and then for each child entity run a select of table 2 with the value from table 1 as part of the select statement. If you just want to use some of the values of the initial element (table 1) you can pass those values with the param usage and then only perform the output in the second template.

Paul Watson30-Oct-02 2:53

Paul Watson

30-Oct-02 2:53

Marc Clifton wrote:
and I'd like to perform a query where table1.id = table2

XML Query[^] may be what you are looking for.

Paul Watson
Bluegrass
Cape Town, South Africa

Ray Cassick wrote:
Well I am not female, not gay and I am not Paul Watson

Marc Clifton30-Oct-02 10:36

30-Oct-02 10:36

Yes! Thank you very much. I see that Microsoft has a managed source demo of XQuery. Looks like it might be the makings of an interesting article.

Thanks again!

Marc

Help! I'm an AI running around in someone's f*cked up universe simulator.

Philip Fitzsimons31-Oct-02 3:04

Philip Fitzsimons

31-Oct-02 3:04

<xsl:template match="//table2[table1/@id = @id]"><br />
 ...<br />
</xsl:template>

"When the only tool you have is a hammer, a sore thumb you will have."

Marc Clifton31-Oct-02 3:22