|
If you are trying to find 1 record in a list of a million, why not use selectSingleNode() instead of looping through each node yourself?
|
|
|
|
|
Thanks,
I have tried your suggest, and I have the following result with selectSingleNode(.) call :
(ms = milliseconds)
/*
nb records table load duration last record access time
identifier to access
-----------------------------------------------------------------------------------
1000000 75000 ms "999999" ~ 43000 ms
100000 2119 ms "99999" 52 ms
10000 160 ms "9999" 5 ms
*/
My table looks like :
<root>
<general>
<type>Bigtest
<items>
<item>
<identifier>0000000
<profile>Guest
<password>
<name>Guest 0
<phone>06.00.00.00.00
<used>true
<item>
<identifier>0000001
<profile>Guest
<password>
<name>Guest 1
<phone>06.00.00.00.00
<used>true
<item>
<identifier>0000002
<profile>Guest
<password>
<name>Guest 2
<phone>06.00.00.00.00
<used>true
<item>...
|
|
|
|
|
Hi guys
Is it possible in xpath to select all elements that start with a value?
For example, say I have this XML:-
<devices>
<device>
<name>Nokia N73
<device>
<name>Nokia N95
And I want to select all device elements whose name starts with "Nokia".
Is there something like this in XPath: "/devices/device[name like 'Nokia*']"
Thanks in advance
|
|
|
|
|
Sorry, the XML didn't show properly.
See below for example XML:
<devices>
<device>
<name>Nokia N73</name>
</device>
<device>
<name>Nokia N95</name>
</device>
</devices>
|
|
|
|
|
Don't worry guys, I've found the solution:-
XPath: "/devices/device[starts-with(., 'Nokia')]"
|
|
|
|
|
threemp3 wrote: Don't worry guys, I've found the solution:-
whew! What a relief!
led mike
|
|
|
|
|
Hello,
Maybe I want the impossible, i don't know..does anyone? I'm only just starting to learn xsd schema-s.
Is it possible to have an element in an xsd that is dependand of the value of an attribute?
for example: in the below schema, can the name and type of the element where ORDER is located be dependand of the value of the attribute REPORT_TYPE? If the REPORT_TYPE="ORDER_DEFINITION" there should be an ORDER of ORDERType, if the REPORT_TYPE="ORDER_BATCH_CONSUMPTION" there should be a RUN of RUNType, or when the value is something else in the future there should't be an element at all?
<code>
<?xml version="1.0" encoding="utf-8" ?>
<xs:schema blockDefault="" elementFormDefault="qualified" targetNamespace="xdwhml" version="1" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="DATAREPORT">
<xs:complexType>
<xs:sequence>
<xs:element name="REPORT_HEADER">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="1" maxOccurs="1" name="REPORT">
<xs:complexType>
<xs:attribute name="REPORT_ID" type="xs:string" />
<xs:attribute name="DATETIME" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:choice minOccurs="0" maxOccurs="1">
<xs:element xmlns:q1="xdwhml" name="ORDER" type="q1:ORDERType" />
</xs:choice>
</xs:sequence>
<xs:attribute xmlns:q1="xdwhml" name="REPORT_TYPE" type="q1:REPORT_TYPE_ENUM" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:simpleType name="REPORT_TYPE_ENUM">
<xs:restriction base="xs:string">
<xs:enumeration value="ORDER_DEFINITION" />
<xs:enumeration value="ORDER_BATCH_CONSUMPTION" />
</xs:restriction>
</xs:simpleType>
<xs:complexType name="ORDERType">
<xs:attribute name="ORDER_NAME" type="xs:string" use="required" />
<xs:attribute name="LINE_NAME" type="xs:string" use="required" />
<xs:attribute name="DESTINATION_NAME" type="xs:string" use="required" />
<xs:attribute name="RECIPE_NAME" type="xs:string" use="required" />
<xs:attribute name="BATCH_NUMBER" type="xs:string" use="optional" />
</xs:complexType>
</xs:schema>
</code>
|
|
|
|
|
Hello. How can I use XSL to get the most common value of a given attribute in some unsorted XML? For instance, here is some XML:
<fixtures>
<fixture time="1930" date="20080926"></fixture>
<fixture time="0930" date="20080927"></fixture>
<fixture time="0930" date="20080927"></fixture>
<fixture time="1000" date="20080928"></fixture>
<fixture time="1000" date="20080926"></fixture>
<fixture time="0930" date="20080926"></fixture>
<fixture time="1230" date="20080930"></fixture>
</fixtures>
I would like to end up with <xsl:value-of select="$mostCommonTime" xmlns:xsl="#unknown"></xsl:value-of>, therefore producing an output of "0930" - the most common value of the time attribute.
Just to complicate things, I need to do further validation on each fixture (using the date attribute), to see whether it is counted or not. This validation is done using Javascript, since it involves date functions, and we are using (and due to 3rd party restrictions, can only use) XSL 1.0. So, each fixture needs to be examined in a separate template, rather like this: <xsl:value-of select="lxslt:isFixtureValid(string(Fixture/@date))" xmlns:xsl="#unknown"></xsl:value-of>, and is discounted or counted depending on whether this output is 'true' or 'false'.
I've tried a recursive template, but do not see a way of sorting the Fixtures node that has to be passed into it; if I try a for-each loop, there is no way of keeping track of the most common time.
Thanks.
|
|
|
|
|
This does not seem like an appropriate use of XSLT. It is a data transformation mechanism not a data analysis mechanism. Therefore even if you could figure out how to do it, it doesn't mean it's a good idea.
led mike
|
|
|
|
|
This is part of a data transformation. I want to place an element around the fixtures, stating "time is hh:mm unless stated", where hh:mm is the most common value. The purpose of the stylesheet is certainly not analysis.
I think that this is a grouping problem, requiring Muenchian grouping, but I've got no further than that.
|
|
|
|
|
darasd wrote: This is part of a data transformation.
That's the way you are looking and perhaps implementing it but that is not what I am referring to.
darasd wrote: to get the most common value
That is an analysis activity, not a transformation activity. Do you understand my point?
led mike
|
|
|
|
|
I'm afraid I'm not convinced that because it is analysis, then it has no place in XSL. You could argue that any transformation is, when it comes down to it, an analysis activity. Why is any transformation performed? To allow the data to be output and therefore interpreted in a different way, which is simply another way of saying Analysis.
For example, a common activity is to list all the elements with a given attribute value. This in itself is a form of analysis.
|
|
|
|
|
|
How about something like this?
<xsl:variable name="mostCommonTime">
<xsl:for-each select="//fixtures/fixture">
<xsl:sort select="count(time)" order="descending"/>
<xsl:if test="position() = 1">
<xsl:value-of select="count(time)"/>
</xsl:if>
</xsl:for-each>
</xsl:variable>
modified on Wednesday, October 15, 2008 11:31 PM
|
|
|
|
|
Sorry to make my first post something like this, but i'm having one of those 'bang your head against the wall' problems, I usually work with t-sql and only use xml for outputs but today I have to parse a list in c# and output to html. I have had a search but I think as the xml i've been given is badly formed I've had little luck searching.
Anyway....
XML:
<data>
<person>
<name>peter jakes</name>
<path>pj87</path>
<property name="System">Linux</property>
<property name="Distro ID">Redhat</property>
</person>
</emucenter>
</data>
All, I want to do in xsl is display the text 'Linux' and 'Redhat' by using a name reference..
I can get this text if I use an ordinal number like so...
<xsl:value-of select="data/person/property[1]"/>
...this will display 'Linux', great. But I need to use the actual name reference not a number.
|
|
|
|
|
Once you have well formed XML rather than what you posted this XPath statement will return the property node in question
//data/person/property[@name='System']
A good reference for things like XPath is www.w3schools.com
good luck
led mike
|
|
|
|
|
thanks, I actually got there in the end, I did try w3schools first actually but they didn't have an example that fit how I wanted.
|
|
|
|
|
Consider this function:
BOOL GetSingleNodeV(const MSXML2::IXMLDOMDocumentPtr pXMLDoc, const CString &strPath, CString &StrValue)
{
BOOL bRetCode=FALSE;
BSTR bstrQstr = strPath.AllocSysString();
IXMLDOMNodePtr o;
o = pXMLDoc->selectSingleNode( bstrQstr);
if (o!=NULL)
{
HRESULT hr=o->get_text(&bstrQstr);
if (hr==S_OK)
{
StrValue = bstrQstr;
bRetCode = TRUE;
}
else
{
StrValue="";
}
}
//o->Release();
SysFreeString(bstrQstr);
return bRetCode;
}
Call to selectSingleNode() sometimes works as expected but sometimes it throws an exception. How can I extract additional information about this exception?
modified on Tuesday, September 30, 2008 1:52 PM
|
|
|
|
|
#import generated ATL code throws _com_error exceptions
When all else fails, consult the documentation[^]
led mike
|
|
|
|
|
Is possible to create an XmlDataSource that has 50 columns merge an sql database with 14 columns into and force the other 36 columns except and false or any value I want with c# or vb
Learning to Code
|
|
|
|
|
Ok. Pick a forum and stick with it. Posting the same question all over the site is considered rude.
|
|
|
|
|
Sorry, Just looking for help I am new.
Learning to Code
|
|
|
|
|
Hi All,
I have this XML files here:
<?xml version="1.0" encoding="utf-8">
<?xml-stylesheet type="text/xsl" href="TimesheetSQLScript.xsl"???>
<myfields>
<timesheetid>
<companycode>CCCRM</companycode>
<employee>Adrian</employee>
<weekpick>2008-09-15</weekpick>
<startdate>2008-09-15</startdate>
<note></note>
<enddate>2008-09-21</enddate>
<monday>
<mondate>2008-09-15</mondate>
<moncheck>
<moncheckin>14:10:00</moncheckin>
<moncheckout>15:44:00</moncheckout>
</moncheck>
<moncheck>
<moncheckin>16:44:00</moncheckin>
<moncheckout>22:50:00</moncheckout>
</moncheck>
</monday>
</timesheetid>
</myfields>
And I applied this XSL:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text" encoding="utf-8" />
<xsl:template match="/">
Declare @TimeCardID int
<xsl:apply-templates select="myFields/TimesheetID/Monday" />
</xsl:template>
<xsl:template match="Monday">
<xsl:text>set @TimeCardID = exec spCreateTimeCard '</xsl:text>
<xsl:value-of select="MonDate" />
<xsl:text>', '</xsl:text>
<xsl:value-of select="/myFields/TimesheetID/Employee" />
<xsl:text>'</xsl:text>
<xsl:for-each select="MonCheck">
exec spCreateTimeCardSession @TimeCardID, '
<xsl:value-of select="MonCheckIn" />
<xsl:text>', '</xsl:text>
<xsl:value-of select="MonCheckOut" />
<xsl:text>'</xsl:text>
</xsl:for-each>
</xsl:template>
It generate this sql statement:
Declare @TimeCardID int
set @TimeCardID = exec spCreateTimeCard '2008-09-15', 'Adrian'
exec spCreateTimeCardSession @TimeCardID, '
14:10:00', '15:44:00'
exec spCreateTimeCardSession @TimeCardID,
'16:44:00', '22:50:00'
but this is not what i want, is there a way that i can generate this statement like this:
Declare @TimeCardID int
set @TimeCardID = exec spCreateTimeCard '2008-09-15', 'Adrian'
exec spCreateTimeCardSession @TimeCardID, '14:10:00', '15:44:00'
exec spCreateTimeCardSession @TimeCardID, '16:44:00', '22:50:00'
Thanks in advance </xsl:stylesheet>
|
|
|
|
|
don't worry folks, i fixed by myself. just have to put <xsl:text></xsl:text> tags like this:
exec spCreateTimeCardSession @TimeCardID, '<xsl:text></xsl:text>
|
|
|
|
|
How can I create a schema for the following?
<Data>
<Value unit="m/s">10</Value>
<Value unit="ºF">25</Value>
</Data>
I would like to have the following description in the xsd
<xs:complexType name="rootSchema">
<xs:sequence>
<xs:element name="Value" type="valueSchema" maxOccurs="unbounded" />
</xs:sequence>
</xs:complexType>
<xs:element name="Multicalc" type="rootSchema" />
How do I write the definition of valueSchema?
(I hope I didn't make any mistakes in the definitions. I simplified things a bit compared to my own xsd.)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
