|
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?
|
|
|
|
|
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!  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.
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 
Any help would be appreciated!
thanks
-shane
|
|
|
|
|
|
How can i create a *.xml using msxml.dll in vc++ ? Any help links..
Thank you.
|
|
|
|
|
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/
|
|
|
|
|
DOMDocument::save(...)
How low can you go ?
(MS rant)
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
|
<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."
|
|
|
|
|
|
hello
i need help on how to convert xsl:fo or xml document to pdf using c sharp
i BADLY need that.
Asim
|
|
|
|
|
|
|
some good software is at http://www.antennahouse.com[^]
you will have to use interop, or shell the exe - but its a nice product and pretty conformant to the standard.
"When the only tool you have is a hammer, a sore thumb you will have."
|
|
|
|
|
Hello,
this is a very basic problem, i think. How can I define an url in the XML file and format/output it with a XSL file?
This is my XML file:
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE archive SYSTEM "archive.dtd">
<?xml-stylesheet href="archive.xsl" type="text/xsl"?>
<archive>
<entry>
<name>Download 1</name>
<webcode>DWL1</webcode>
<link>link</link>
</entry>
<entry>
<name>Download 2</name>
<webcode>DWL2</webcode>
<link>link2</link>
</entry>
</archive>
This is my XSL file:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl">
<xsl:template>
<link rel="stylesheet" type="text/css" href="default.css"/>
<h1>Archive</h1>
<table>
<tr><td>
<img src="images/menulinks.gif"/>
Downloads</td></tr></table><br/><br/>
<table>
<tr>
<td width="33%">Name</td>
<td width="33%">Webcode</td>
<td>Goto</td>
</tr>
<xsl:for-each select="archive/entry">
<tr>
<td><xsl:value-of select="name"/></td>
<td><xsl:value-of select="webcode"/></td>
<td><a href=" WHAT HERE??? "><xsl:value-of select='link'/></a></td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
What do i have to put in the 8. line above? ("WHAT HERE???")
This mustn't be a fixed string, it must be loadable from the .xml file. How do i encode the link in the XML file?
-Dominik
|
|
|
|
|
you need to use xsl:attribute to create the href= part of the anchor tag. Something like:
<a>
<xsl:attribute name="href">
<xsl:value-of select="href"/>
</xsl:attribute>
</a>
That's off the top of my head, but it's basically correct.
Christian
<i>No offense, but I don't really want to encourage the creation of another VB developer.</i> - <b>Larry Antram 22 Oct 2002</b>
<i>Hey, at least Logo had, at it's inception, a mechanical turtle. VB has always lacked even that...</i> - <b>Shog9 04-09-2002</b>
<i>During last 10 years, with invention of VB and similar programming environments, every ill-educated moron became able to develop software. </i> - <B>Alex E. - 12-Sept-2002</B>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
