|
In my current application, I am using SQLXML to access my data (including JPEG images) within SQL Server 2000. By using a mapping-schema to explicitly map the datatypes (from "image" to "base64binary"), the image is automatically encoded and decoded for me.
|
|
|
|
|
Hello everybody:
I wanna know what exatcly XML is.I find out that I can store some information in XML file and use it during runtime,but what is advantage or disadvantage of this method than using database?When should I use XML and when should I use Acees/SQLServer ? Is XML something more than storing some piece of inforamtion?Any suggestion would be appreciated.  Thanks
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
|
|
|
|
|
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.
|
|
|
|
|
Thank you MarSCoZa
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
|
|
|
|
|
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
|
|
|
|
|
Thank you Michael.
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
|
|
|
|
|
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".
|
|
|
|
|
Hi Alex
Thank you for reply.I'll do it.
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
(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)
|
|
|
|
|
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
|
|
|
|
|
Can you provide an example of the XML?
Also, in what way do the anchors not work?
|
|
|
|
|
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.
|
|
|
|
|
They are "trying" to support XSL. But as I saw with no success 
Philip Patrick
Web-site: www.saintopatrick.com
"Two beer or not two beer?" Shakesbeer
Need Web-based database administrator? You already have it!
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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. ...
|
|
|
|
|
I guess I should have been more specific. It would be an XY scatter chart from Excel.
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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. ...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
