XML / XSL Discussion Boards

First Prev Next

Re: How to use Amazon Web Services..

Paul Wolfensberger15-May-04 3:06

Paul Wolfensberger

15-May-04 3:06

Don't be rude. If you were interested in helping him you could have posted the URL to the article. If not, you could just told him there was an article on CP.

Re: How to use Amazon Web Services..

Colin Angus Mackay15-May-04 4:47

Colin Angus Mackay

15-May-04 4:47

Paul Wolfensberger wrote:
Don't be rude

Be more positive. How about saying: "Be nice!". Reinforce the behaviour you wish, rather than the behaviour you don't want.

Paul Wolfensberger wrote:
If you were interested in helping him you could have posted the URL to the article

If you give a man a fish, you feed him for a day. If you teach a man to fish, you feed him for a lifetime.

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

problem in generating html through xml

junckjunck7-May-04 19:56

junckjunck

7-May-04 19:56

i was able to generate html doc/code from xml and xsl through c++ using IXMLDOMDocumentPtr , IXSLTemplatePtr , IXSLProcessorPtr .
but when i added/wrote schema for xml , it was skipping tag elements text
in xml file.

how can i get/access tag elements text ?

same scope, elements with the same name, but NOT the same type

Michał Januszczyk7-May-04 6:50

Michał Januszczyk

7-May-04 6:50

Is it possible to define schema for the following element ? :

<processor>
<param>arial</param>
<param>3.5</param>
<param>50</param>
<param>95</param>
<param>some text</param>
</processor>

I want to enforce that exactly five 'param' elements can be specified, and I want
to enforce types for the elements (i.e. first element is xs:string, seconf xs:double,
... etc

I tried to create the following schema, but I get error when checking for validity

<xs:complexType name="processor_type">
<xs:sequence>
<xs:element name="param" type="xs:string"></xs:element>
<xs:element name="param" type="xs:double"></xs:element>
<xs:element name="param" type="xs:decimal"></xs:element>
<xs:element name="param" type="xs:decimal"></xs:element>
<xs:element name="param" type="xs:string"></xs:element>
</xs:sequence>
</xs:complexType>

Error:
In the same scope, elements with the same name have to have the same type.

Is there any workaround for this, but without giving different names for current 'param'
elements

Thanks
Michał Januszczyk

How to print an Organisation Chart (Tree Structure)

BSRK6-May-04 23:51

BSRK

6-May-04 23:51

Hi

I want to print an Organisation Chart which is more like an Inverted Tree Structure.
Smile | :)

Like that with proper Lines. I could find ready tools for Explorer Type of Tree Structure (similar to windows Explorer). But i want an inverted tree structure like above one.
Actually I am doing my work in ASP. But any solution is accepted.
Thanks

Re: How to print an Organisation Chart (Tree Structure)

mauricexy7-May-04 3:43

mauricexy

7-May-04 3:43

Have a look here http://www.15seconds.com/issue/020424.htm or http://www.15seconds.com/focus/XML.htm for more solution.
Goodluck

Re: How to print an Organisation Chart (Tree Structure)

Sameer Kulkarni26-Feb-09 23:27

Sameer Kulkarni

26-Feb-09 23:27

Is there any way that this can be presented in a horizantal way

XSL newbie ?

compbssn20035-May-04 7:48

compbssn2003

5-May-04 7:48

I am trying to write a stylesheet to extract information from an XML Schema. However, I cannot figure out how to handle the namespace in the source XML/XSD document. Do you have to declare the namespace in the XSL stylesheet as well? What about in the XPath expressions in the XSL? Do you have to use the namepsaces there as well?

Thanks

Simple question

bertcox5-May-04 3:17

bertcox

5-May-04 3:17

Hello,

I'm new to xslt and xml. I have a xml-document that looks like this :

<?xml version="1.0" standalone="yes"?>
<sessions version="1.0">
<session name="Development">
<libraries>
<library name="contxtlib">
<fullname>123</fullname>
<super>true</super>
<loadorder>8</loadorder>
</library>
<library name="xmllib">
<fullname>xmllib.p</fullname>
<super>true</super>
<loadorder>12</loadorder>
</library>
<library name="clientdebuglib">
<fullname>clientdebuglib.p</fullname>
<super>true</super>
<loadorder>3</loadorder>
</library>
</libraries>
</session>
</sessions>

Now i want to sort this xml-file. The loadorder should be 3 then 8 and then 12 and not in this order. So it has to be sorted. I tried writing a xslt file but he doesn't sort my data.
My xslt file looks like this:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="session">
<xsl:copy>
<xsl:apply-templates>
<xsl:sort data-type="number" select="session/libraries/library/loadorder"/>
</xsl:apply-templates>
</xsl:copy>
</xsl:template>

<xsl:template match="*">
<xsl:copy>
<xsl:apply-templates/>
</xsl:copy>
</xsl:template>

</xsl:stylesheet>

Everything could be wrong for me, i found this on the internet and made some changes but now i don't know whether it's good. All i want to to is sort the library's on loadorder.

thx a lot in advance

Re: Simple question

Philip Fitzsimons7-May-04 3:06

Philip Fitzsimons

7-May-04 3:06

your first template match is wrong it should be "sessions" rather than "session"

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

EMBEDDING SQL IN A VC++ DATABASE APPLICATION

Wisdom20043-May-04 21:09

Wisdom2004

3-May-04 21:09

Hai,
I have been able to develop database applications using Recordsets technology. I worry is that this approach is a bit cumbersome for large database applications.

I want to use an approache were I will be able to access a single or set of records directly from a Database without having to search in the resulting recordset.

In short I want to be able to use SQL in my database programs in VC++.

How should I connect to the database. What specific coding and setup is needed.

Lloyd.

ACCESS A DATABASE USING MFC DIALOGUE BOXES

Wisdom20043-May-04 21:03

Wisdom2004

3-May-04 21:03

Hai,
I'am a new VC++ developer, I have been able to develop applications using
MFC Single/Mutiple Doments and manipulating recordsets.

I want to access records in a database using Dialogue Boxes instead of document forms. I do not like the appearance of a Document based database apllication.
What procedures should I follow to be able to access a database using Dialogue Boxes.

Lloyd.(Zambia)

How to use msxml4.dll in project?

Anonymous3-May-04 7:12

Anonymous

3-May-04 7:12

Hello. I have tried to build my project which references msxml4.dll but when I try to build it I get the following error:

Cannot open type library file: 'msxml4.dll'

I can manage to find this on the Internet I think but should I just put it somewhere in my path or is there a proper way of installing it along with maybe an SDK? I have tried installing the Internet SDK but it does not install the file I want. I have tried searchig for it on my hard disk after installing the SDK but it is not there.

Thank you for any help.

Re: How to use msxml4.dll in project?

Andrew Quinn AUS25-May-04 5:46

Andrew Quinn AUS

25-May-04 5:46

Hi,

Here is the link to MS for the msxml4 install.

Are you using it from VC or VB ?

The msxml4.dll should end up in the System32 directory of your system.

Hope this helps,
Andy

XSL Table view

mauricexy3-May-04 4:21

mauricexy

3-May-04 4:21

Re: XSL Table view

mauricexy4-May-04 3:52

mauricexy

4-May-04 3:52

Hi Everyone,

I solve the problem by letting Microsoft's new software InfoPath generate it for me... It looks very complicated but it works.. I think Microsoft has just taken away the fun in writing XSLT scripts... very powerfull tool.. that Infopath...generates the xsd, xsl, xslt, jscript name it.....and saves a lot of time.
Thanks,

problem with xslt!

hassan azizi30-Apr-04 3:37

hassan azizi

30-Apr-04 3:37

problem with xslt!

hassan azizi30-Apr-04 3:26

hassan azizi

30-Apr-04 3:26

hi my dear
i use xslt template to transform xml content to html file.
but i have some problem ,that is the inner text of P tag in generated html file(p tag is contained with a cell of an absolute table) don't wrap
automatically!and it cause to resize the container table and when
i open that html file in VS .NET environment and changes any thing likee a tag property the text of p tag becomes true!
even i used nowrap property of p tag to false but it didn't work!
how i can fix this bug in my product?

html sample:
....
<table style=" POSITION: absolute; top:147; left:173" width="398" height="292" bgcolor="#ffffff" border="0" cellspacing="0" cellpadding="0">
<tr width="100%">
<td width="100%" dir="ltr">
<p align="left">
<font face="Tahoma" color="#000000" style="font-size:8pt">aaaaaaaaaaaaaaa aaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaa aaaaaaaaaaaaa ddddddddddd dddddddddd dddddddddddddd dddddddddddddd dddddddddddddd dddddddddd sssssssssss sssssssssssssssssssssssssssssssss </font>
</p>
</td>
</tr>
</table>
.....
problem : the text in p tag don't wrap!

xslt partial template:
....
<font face="{$font}" color="{$color}" style="font-size:{$size}pt">
<xsl:call-template name="InnerText">
<xsl:with-param name="text" select="translate(.,' ',' ')" />
</xsl:call-template>
</font>
.....

thanks a lot
hassan azizi

Newbie XML/XSL question

Anonymous29-Apr-04 16:15

Anonymous

29-Apr-04 16:15

I am doing a simple task where I am trying to create a table of cars with co
lumn headers such as model, make, color etc and then have details of the dif
ferent cars underneath ..... and I have to create a dtd, xml and xls file fo
r them. I have tried entering one set of data for a Mercedes car but the dat
a just all comes out together on one line and doesn't create the table as I
had hoped! My output looks like this:

Cars for Sale
makemodelyearcolorengineradioair conditioningpower windowspower steeringpowe
r brakes1Mercedes BenzE2402003Black8fuel_injected yes yes yes yes yes

Any help MUCH appreciated. Thanks

Here is my code:

cars_for_sale.DTD:

<?xml version="1.0"?>

<!ELEMENT cars (car+)>
<!ELEMENT car (make, model, year, color, engine, number_of_doors, transmissi
on_type, accessories*)>
<!ELEMENT engine (number_of_cylinders+, fuel_system)>
<!ELEMENT make (#PCDATA)>
<!ELEMENT model (#PCDATA)>
<!ELEMENT year (#PCDATA)>
<!ELEMENT color (#PCDATA)>
<!ELEMENT number_of_doors (#PCDATA)>
<!ELEMENT transmission_type (#PCDATA)>
<!ELEMENT accessories (#PCDATA)>
<!ELEMENT number_of_cylinders (#PCDATA)>
<!ELEMENT fuel_system (#PCDATA)>

<!ATTLIST accessories radio CDATA #REQUIRED>
<!ATTLIST accessories air_conditioning CDATA #REQUIRED>
<!ATTLIST accessories power_windows CDATA #REQUIRED>
<!ATTLIST accessories power_steering CDATA #REQUIRED>
<!ATTLIST accessories power_brakes CDATA #REQUIRED>

<!ENTITY bmw "B M W">
<!ENTITY me "Mercedes Benz">
<!ENTITY fo "Ford">
<!ENTITY v "Volvo">
<!ENTITY mi "Mini">
<!ENTITY j "Jaguar">
<!ENTITY p "Peugeot">
<!ENTITY rr "Rolls Royce">

cars_for_sale.XML:

<?xml version="1.0" encoding="ISO-8859-1" ?>

<!DOCTYPE cars_for_sale SYSTEM "cars_for_sale.dtd">

<?xml-stylesheet type="text/xsl" href="cars_for_sale.xsl"?>

<cars_for_sale>
<car id = "1">
<make>&me;</make>
<model>E240</model>
<year>2003</year>
<color>Black</color>
<engine>
<number_of_cylinders>8</number_of_cylinders>
<fuel_system>fuel_injected</fuel_system>
</engine>
<number_of_doors>5</number_of_doors>
<transmission_type>Diesel</transmission_type>
<accessories>
<radio>yes</radio>
<air_conditioning>yes</air_conditioning>
<power_windows>yes</power_windows>
<power_steering>yes</power_steering>
<power_brakes>yes</power_brakes>
</accessories>
</car>
</cars_for_sale>

cars_for_sale.XSL:

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version = "1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match = "/">

<h1>Cars for Sale</h1>
<car border = "border">
<tr>
<th></th>
<th>make</th>
<th>model</th>
<th>year</th>
<th>color</th>
<th>engine</th>
<th>radio</th>
<th>air conditioning</th>
<th>power windows</th>
<th>power steering</th>
<th>power brakes</th>
</tr>

<xsl:for-each select = "cars_for_sale/car">

<tr>
<th><xsl:value-of select = "@id" /></th>
<td><xsl:value-of select = "make" /></td>
<td><xsl:value-of select = "model" /></td>
<td><xsl:value-of select = "year"/></td>
<td><xsl:value-of select = "color"/></td>
<td><xsl:value-of select = "engine/number_of_cylinders"/></td>
<td><xsl:value-of select = "engine/fuel_system"/></td>
<td><xsl:value-of select = "accessories"/></td>
</tr>

</xsl:for-each>

</car>
</xsl:template>
</xsl:stylesheet>

Re: Newbie XML/XSL question

Member 64272914-May-04 2:46

Member 642729

14-May-04 2:46

I'm assuming that you are trying to write out a html table.

If you are then you need to output a table tag as well as the rows and cells.

Storing XSLT files in SQL Server

Member 116304929-Apr-04 12:29

Member 1163049

29-Apr-04 12:29

I'm building an application, using C# and SQL 2000, where based on the user identity I wish to present different views of data and XSLT is an ideal solution for this application. If when I call the Load method of XslTransform I reference an on-disk file everything works as expected.

XslTransform transform = new XslTransform ();
transform.Load (@"D:\WorkDir\test.xslt");

However, I want to store different XSLT's in the database and retrieve it based upon the user's identity. (Interesting enough I could find no sample code anywhere that did this, although I would think it would be fairly common).

When I try to read back the XSLT from SQL - if I do not put in a FOR XML I cannot load the result into an XmlReader class. I get an exception of:
"Invalid command sent to ExecuteXmlReader. The command must return an Xml result."

Putting in a FOR XML AUTO or RAW allows it to load the reader, but the transform.Load subsequently fails with:

"Missing mandatory attribute 'version'."

although there is a version tag in my XSLT.

sqlConn.Open ();
SqlCommand sqlCommandXSL = new SqlCommand ("sp_GetUserTransform 0", sqlConn);

XmlTextReader xmlReadTransform = (XmlTextReader) sqlCommandXSL.ExecuteXmlReader ();
XPathDocument doc = new XPathDocument(xmlReadTransform, XmlSpace.Preserve);

XPathNavigator xpn = doc.CreateNavigator ();
XslTransform xslTransform = new XslTransform ();
xslTransform.Load (xpn, null, null); <-- throws exception here.

I'd appreciate any insights as to what I'm doing incorrectly and links to samples that show how to do this.

Thanks.

Parsing XML with VBScript

lnong29-Apr-04 12:04

lnong

29-Apr-04 12:04

I am using the classes and methods from the Msxml2.DOMDocument.4.0 namespace to dynamically create an XML file using VBScript. (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/htm/xml_mth_sz_3jol.asp). I was able to successfully create the XML and load it into memory for parsing. However, for some reason, I am not able to use the SelectSingleNode() method of the IXMLDOMNode object. The error I get is: "Object doesnt support this property or method. Error code: 800A01B6".

Any ideas?

send xml

hmdhmd27-Apr-04 0:58

hmdhmd

27-Apr-04 0:58