XML / XSL Discussion Boards

Paul Watson11-Nov-02 21:13

11-Nov-02 21:13

NRK wrote:
PHP is great imho.

Have you tried ASP.NET? I totally agree that ASP and PHP are on level terms and there is not much in it. But ASP.NET is something totally different and better. I hope PHP keeps up, good to have options and competition Smile | :)

Paul Watson
Bluegrass
Cape Town, South Africa

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

Assign DTD to XML Document

Bash3-Nov-02 2:05

Bash

3-Nov-02 2:05

Hi Gurus!

I'm a XML beginner. I try to save my program settings in XML file using Microsoft Visual C++ 6.0. Here is the sample from my code:

--------------------------------------------------------------
IXMLDOMDocumentPtr XmlDocPtr;
IXMLDOMNodePtr pNode;
IXMLDOMElementPtr XmlRootPtr;

b=XmlDocPtr->loadXML(_bstr_t("<settings>"));
if (!b) return;

XmlDocPtr->get_documentElement(&XmlRootPtr);

if (XmlRootPtr)
{
VARIANT vtTemp2;
vtTemp2.vt=VT_I2;
vtTemp2.iVal = NODE_ELEMENT;
pNode = XmlDocPtr->createNode(vtTemp2, "Program", "");
pNode->put_dataType(L"NODE_TEXT");
pNode->put_text(L"MYCOOLER");
XmlRootPtr->appendChild(pNode);

pNode = XmlDocPtr->createNode(vtTemp2, "Distributor", "");
pNode->put_dataType(L"NODE_TEXT");
pNode->put_text(L"IBM Corp.");
XmlRootPtr->appendChild(pNode);

pNode = XmlDocPtr->createNode(vtTemp2, "Version", "");
pNode->put_dataType(L"NODE_TEXT");
pNode->put_text(L"6.0");
XmlRootPtr->appendChild(pNode);
};

variant_t vDest(L"d:\\settings.xml");
XmlDocPtr->save(vDest);
--------------------------------------------------------------

File d:\system.dtd contains:

--------------------------------------------------------------

--------------------------------------------------------------

But resulted file "settings.xml" is not formatted according system.dtd specification. What's wrong? Help me!

Yours sincerely,
Alex Bash

Re: Assign DTD to XML Document

Stephane Rodriguez.3-Nov-02 2:19

Stephane Rodriguez.

3-Nov-02 2:19

Bash wrote:
But resulted file "settings.xml" is not formatted according system.dtd specification.

The DTD is not a formatter. A DTD is just here to verify the well-formedness and/or validness of an Xml stream.

The formatting is the result of your own code (appendChild, ...).

On top of that, when you open an Xml file in MSIE, MSIE applies a default formatting (using a XSLT stylesheet) : for instance it may show you <k name="kkk"/> although there is <k name="kkk"></k> in the file.

Back to real work : D-27.

Re: Assign DTD to XML Document

Bash3-Nov-02 3:37

Bash

3-Nov-02 3:37

Hi,

Thank you for quick reply to the beginner. Wink | ;)

And another question - how to insert CR/LF symbol after appending a new child. At present, I have "settings.xml" with single line like as:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Settings><Program>MYCOOLER</Program><Distributor>IBM Corp.</Distributor><Version>6.0</Version></Settings>

I want to get this xml (i.e. "formatted") as follows:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Settings>
<Program>MYCOOLER</Program>
<Distributor>IBM Corp.</Distributor>
<Version>6.0</Version>
</Settings>

How to do "formatted" xml?

Yours sincerely,
Alex Bash

Re: Assign DTD to XML Document

Stephane Rodriguez.3-Nov-02 4:09

Stephane Rodriguez.

3-Nov-02 4:09

Unfortunately, there is no way to do so using MSXML. That's probably why this SDK is now legacy and replaced by a much more powerful Xml stuff along with .NET.

You can achieve indentation by creating your own fake text nodes, with code like this :

var dom = new ActiveXObject("Microsoft.XMLDOM");
var root = dom.createElement("toto");
for (i = 0; i < 10; i++) {
    var formatting = dom.createTextNode("\n\t");
    root.appendChild(formatting);
    var child = dom.createElement(child);
    root.appendChild(child);
}
dom.save("output.xml");

Back to real work : D-27.

Re: Assign DTD to XML Document

Bash3-Nov-02 18:52

Bash

3-Nov-02 18:52

Thank you, it works!

Yours sincerely,
Alex Bash

(XML4C) DOMParser constructor crash

Ravi Bhavnani1-Nov-02 12:10

Ravi Bhavnani

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

Re: (XML4C) DOMParser constructor crash

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

Re: (XML4C) DOMParser constructor crash

Ravi Bhavnani3-Nov-02 9:13

Ravi Bhavnani

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

Re: (XML4C) DOMParser constructor crash

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

Re: (XML4C) DOMParser constructor crash

Ravi Bhavnani3-Nov-02 9:42

Ravi Bhavnani

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

XML Database on Client w/C#

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

Marc Clifton

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.

Re: calling all XML/XSL XPath gurus

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

Re: calling all XML/XSL XPath gurus

Marc Clifton31-Oct-02 10:26

Marc Clifton

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.

Re: calling all XML/XSL XPath gurus

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

Re: calling all XML/XSL XPath gurus

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

Ravi Bhavnani

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.

Re: XML & VC++

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/

Re: XML & VC++

Stephane Rodriguez.30-Oct-02 1:53

Stephane Rodriguez.

30-Oct-02 1:53

DOMDocument::save(...)

How low can you go ?
(MS rant)

Re: XML & VC++

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

Re: XML & VC++

Ravi Bhavnani2-Nov-02 4:48

Ravi Bhavnani

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

Marc Clifton

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.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.