XML / XSL

MS le Roux13-Apr-02 9:36

MS le Roux

13-Apr-02 9:36

One of the cool things about XML is the fact that it is just a string, making it very generic. This makes it very simple to send from one application to another, (or even one business to another) without having to worry about special software requirements.
Another advantage is that it is completely disconnected from a database. You could have a COM component which gets information from the database and returns it as XML. This makes it easier to split the layers of an application.
Then there's also XSLT (which is pretty cool once you understand it). And don't forget about .Net, which is very XML-happy.

Mazdak13-Apr-02 10:07

Mazdak

13-Apr-02 10:07

Thank you MarSCoZa Smile | :)

Mazy

"The path you tread is narrow and the drop is shear and very high,
The ravens all are watching from a vantage point near by,
Apprehension creeping like a choo-train uo your spine,
Will the tightrope reach the end;will the final cuplet rhyme?"Cymbaline-Pink Floyd

Michael A. Barnhart16-Apr-02 11:38

16-Apr-02 11:38

First I would not compare it to a database. There are XML databases but an XML file and a database are not the same thing.

XML is a method to package data to then send in whatever protocal or format you choose. By using this method you can use standard tools to parse and extract (or create) the data. Also once in this form you have many tools to reformat the data as needed (XSLT...)

To be conscious that you are ignorant of the facts is a great step towards Knowledge. Benjamin Disraeli

Mazdak16-Apr-02 20:29

Mazdak

16-Apr-02 20:29

Thank you Michael. Smile | :)

jkgh20-Jun-02 7:20

jkgh

20-Jun-02 7:20

HI Mazy,

Log onto the MSDN site MSDN.microsoft.com and read the "extreme XML" column postings.

Alice thought that running very fast for a long time would get you to somewhere else. " A very slow kind of country!" said the queen. "Now, here , you see, it takes all the running you can do, to keep in the same place".

Mazdak21-Jun-02 8:31

Mazdak

21-Jun-02 8:31

Hi Alex

Thank you for reply.I'll do it. Smile | :)

Mazy

"If I go crazy then will you still
Call me Superman
If I’m alive and well, will you be
There holding my hand
I’ll keep you by my side with
My superhuman might
Kryptonite"Kryptonite-3 Doors Down

SOAP Newbie

Tom Archer12-Apr-02 8:24

Tom Archer

12-Apr-02 8:24

Being extremely comfortable with XML, I'm finally learning some SOAP.

I know the following is a SOAP request, but can someone shed some
light on what each part represents?

POST /StockQuote HTTP/1.1
Host: www.stockquoteserver.com
Content-Type: text/xml; charset="utf-8"
Content-Length: 323
SOAPAction: Some-Namespace-URI#GetLastTradePrice
<SQ:Envelope
    xmlns:SQ="http://schemas.xmlsoap.org/soap/envelope/"
    SQ:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <SQ:Body>
    <m:GetLastTradePrice xmlns:m="Some-Namespace-URI">
      <symbol>DIS</symbol>
    </m:GetLastTradePrice>
  </SQ:Body>
</SQ:Envelope>

Here again with the response package, I could really use some help
deciphering it:

HTTP/1.1 200 OK
Content-Type: text/xml; charset="utf-8"
Content-Length: nnnn
<SP:Envelope
xmlns:SP="http://schemas.xmlsoap.org/soap/envelope/"
    SP:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <SP:Body>
    <m:GetLastTradePriceResponse
    xmlns:m="Some-Namespace-URI">
      <Price>34.5</Price>
    </m:GetLastTradePriceResponse>
  </SP:Body>
</SP:Envelope>

Thanks!!

Cheers,
Tom Archer
Author, Inside C#

Please note that the opinions expressed in this correspondence do not necessarily reflect the views of the author.

Re: SOAP Newbie

Michael A. Barnhart16-Apr-02 11:52

XML,Oracle+sqlserver integration

16-Apr-02 11:52

First your soap request and responce is packaged as a standard HTTP request and responce that is the first set of data in both of your samples.
Then internal to that you have a "data" section that is that meaningful part.

POST /StockQuote HTTP/1.1
This line is a stock HTTP post
Host: www.stockquoteserver.com
Who is it to
Content-Type: text/xml;
what is the type of data text and xml
charset="utf-8"
how is the dataset being used
Content-Length: 323
how much data is to be read from the socket being used.
you have an error in your sample here. The header block should be terminated with a blank line (not a line with blanks ok)

SOAPAction: Some-Namespace-URI#GetLastTradePrice
define namespace to apply to the child data

<SQ:Envelope xmlns:SQ="http://schemas.xmlsoap.org/soap/envelope/" SQ:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
root element of the XML document being sent. it includes the version etc of the request.
<SQ:Body>
start of the body of data to be made available to the soap process
<m:GetLastTradePrice xmlns:m="Some-Namespace-URI">
What routine on the server is being called and the namespace to use
<symbol>DIS
arguments to be made available to the routine processing the request. It will ask for them by name (like an envoriment variable). You only have one and it is not properly terminated.
</m:GetLastTradePrice>
end of info for this process
</SQ:Body>
end of body
</SQ:Envelope>
end of data to make it a well formed document.

Your responce is identical other than the header is that of a valid http responce vs request.

Take Care and when should I start looking for your book a the stores?

To be conscious that you are ignorant of the facts is a great step towards Knowledge. Benjamin Disraeli

Re: SOAP Newbie

Tom Archer16-Apr-02 12:14

Tom Archer

16-Apr-02 12:14

Thanks Michael!

Michael A. Barnhart wrote:
Take Care and when should I start looking for your book a the stores?

Inside C# should be in the stores next week!!

Cheers,
Tom Archer
Author, Inside C#

Please note that the opinions expressed in this correspondence do not necessarily reflect the views of the author.

vins8-Apr-02 3:54

vins

8-Apr-02 3:54

Is there any way SQL server,oracle can talk to each other,perhaps XMl can fit here but how do you pass data generated by oracle in XML to sql server.

Thank you for spending time.

Vineet

HTML Question

[James Pullicino]7-Apr-02 22:34

[James Pullicino]

7-Apr-02 22:34

(I could not find an HTML forum, so I'm posting here.)

I would like to disable the conext menu for my web page. I can handle the onconextmenu event without any problems by adding oncontextmenu="return false" to the BODY tag.

The problem is that if I have an ActiveX object embedded in the webpage (specifically the IThumbCtl control), right clicking on the object invokes the IE context menu. I've tried adding oncontextmenu="return false" to the OBJECT tag, but this does not work.

Can anyone help me disable the context menu completely? I'm using the IWebbrowser2 control.

Thanks!
James.

(2b || !2b)

Is this a bug of Internet explorer?

wilbur7-Apr-02 21:53

wilbur

7-Apr-02 21:53

I have created a web page contains four frames. Three of them are HTML and the other one is XML formatted by a XSL file. I used some anchors in it.
The problem is,
When I use Internet explorer5, the anchors works very well.
But Internet Explorer5.5 and 6, they don't work. And it's really strange that when I display the XML file seperately, it works well again.
Can anybody tell me how to solve this problem.
Thanks,
Wilbur

Re: Is this a bug of Internet explorer?

MS le Roux8-Apr-02 0:01

MS le Roux

8-Apr-02 0:01

Can you provide an example of the XML?
Also, in what way do the anchors not work?

XSL and Netscape

Jon Newman2-Apr-02 7:01

Jon Newman

2-Apr-02 7:01

Does Netscape support XSL stylesheets????
I have a page here (you are lucky to see this):
XML page on website
It is XML linked to an XSL stylesheet that seems to work on IE but netscape just displays the XML tag contents one after the other without formatting. Am I missing something that nescape needs to tell it that what its reading is XML with XSL stylsheets?

Jonny Newman
Liverpool, UK
Sonork: 16257:Jonny Newman
MSN Msngr: jonathann4@hotmail.com
ICQ: 37606329
I'm out there! Feel free to contact me about anything.

Re: XSL and Netscape

Philip Patrick5-Apr-02 4:13

Philip Patrick

5-Apr-02 4:13

They are "trying" to support XSL. But as I saw with no success Smile | :)

Philip Patrick
Web-site: www.saintopatrick.com
"Two beer or not two beer?" Shakesbeer

Need Web-based database administrator? You already have it!

Re: XSL and Netscape

markkuk6-Apr-02 9:51

markkuk

6-Apr-02 9:51

The media type in your XSL reference is wrong. There's no type "text/xsl". The XSLT standard tells to use either "text/xml" or "application/xml". According to RFC 3023 "application/xslt+xml" might be used in future, but it's not yet registered.
Mozilla/Netscape tends to be much stricter about following the letter of published standards than MSIE.

Displaying an excel spreadsheet with xsl

28-Mar-02 6:11

I would like to thank the person who created this thread.

I need to display a spreadsheet- anyone ever done this? I was hoping to treat it like an image, but that didn't work out for me.

Thanks,
Lilian Smile | :)

Re: Displaying an excel spreadsheet with xsl

Michael A. Barnhart28-Mar-02 9:06

Re: Displaying an excel spreadsheet with xsl

28-Mar-02 9:06

I do not think with the information you have provided an answer can be given. What is the the data source? A spreadsheet is a little vague. Even an Excel file is to vague. What form? Tab Delimited? XML?
What do you want to display all the rows and columns cells definitions? or just a selected block. Now if you have saved the Excel file as XML you can transform that into something else, say an HTML table of selected rows. Unless you add a solver, you are not going to get the results.

Good ideas are not adopted automatically.
They must be driven into practice with courageous patients. -Admiral Rickover. ...

Lilian Chan-Grant28-Mar-02 9:29

Lilian Chan-Grant

28-Mar-02 9:29

I guess I should have been more specific. It would be an XY scatter chart from Excel.

Re: Displaying an excel spreadsheet with xsl

Lilian Chan-Grant28-Mar-02 9:58

Lilian Chan-Grant

28-Mar-02 9:58

If I save the chart in a new worksheet, copy the object and paste it into Paint, I get a bitmap which is something I know how to handle. Anyone have a clue as to how to make code do this?

Editable XML from MSXML

David Chamberlain28-Mar-02 4:27

David Chamberlain

28-Mar-02 4:27

Hi all,

I have started working up a set of C++ functions to access the MSXML DOM through the COM interfaces, having scoured the CP articles and other on-line tutorials. Finally, I have some functions that do what I need to load an XML, traverse it, update it, and write it back out.

The problem, though, is that when I use 'save' and then go look at the XML file, I get something with no new-lines. Everything is on a single line. While the file looks just fine in the web browser, I thought one of the attractions of XML was that it was ASCII and could be easily edited.

While this is true, it just doesn't look very good in an editor, as there are no line breaks. It can be edited, but it really needs a lot of reformatting before it can be usable.

Is there another function or something I can call that will give me at least a little formatting?

Thanks,
Dave

"You can say that again." -- Dept. of Redundancy Dept.

28-Mar-02 4:58

I have a very nice answer for you. In the web site from Microsoft XML, there is XML Notepad, just try it, is a fancy tool (still in beta version) .. but it looks good..

E. Sanjuanelo

Michael A. Barnhart28-Mar-02 8:52

28-Mar-02 8:52

Keep in mind that all of that formating is contained in nodes of the parent element(s). If you are not adding those text nodes along with the rest of the element definition you add or working with them with the existing definitions, your process is what is leaving them out. Not the DOM.

Good ideas are not adopted automatically.
They must be driven into practice with courageous patients. -Admiral Rickover. ...

David Chamberlain28-Mar-02 10:37

David Chamberlain

28-Mar-02 10:37

Michael A. Barnhart wrote:
... all of that formating is contained in nodes of the parent element(s).

I'm not sure I understand that. Actual formatting can be done with XSLT to get a revised file, typically an HTML file, but that is only based on several examples. If I want to get something that looks like (with newlines):

[Node1]
[Data2]Here is data[/Data2]
[/Node1]

what I end up with is (no newlines):

[Node1][Data2]Here is data[/Data2][/Node1]

Even if I just type this into an XML file (with appropriate headers, etc) I can physically enter a newline at the end of each line, and that is what I am missing from the DOM.

Are you saying that I can add that "formatting" (the newlines) as additional text nodes, perhaps just containing "\n"?

Dave

"You can say that again." -- Dept. of Redundancy Dept.