Trying to learn XML

[TRACEYMARYLAND]

I have been using ASP for 3 years and i thought i better learn XML..

Now i looked at Configure SQL for XML and tried that and was quite amazed i go data on page without using ADO ...

What would be the best way to go to make the page display nicely.

XML pages...XDR etc...getting lost with all the new terminology.

Should i stick with XML on IIS server or the SQL server

I be using stored procedures

Any direction would be greatly received

 

[chiph]

You can have your SQL Server return XML to you by using the FOR XML AUTO clause. But you need to look at what load your database server is under -- if it's already near what it can handle (CPU load), then you'd be better off returning a recordset as usual, and translating it to XML manually on the application server side.

If you want more info on how to use XML, the "Partners" box on the left has some good sites.

Some basics:
.XML are files that contain XML content (duh)
.XSD are files that describe the format of an XML document -- structure, as well as content allowed. Use one to verify that your XML document is valid.
.XSL are files that contain rules that translate one XML document into another. Often used to convert XML to HTML.
.XDR files were Microsoft's attempt at XSDs. Don't use unless you're using an old version of BizTalk.
XPATH is like regular expressions, but for XML documents. It's a query language that allows you to navigate an XML document as if it were a directory tree.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first