Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


XML Simplified


XML Simplified

Author
Message
Jonathan Stokes
Jonathan Stokes
SSC Eights!
SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)SSC Eights! (927 reputation)

Group: General Forum Members
Points: 927 Visits: 1

I know you can put it into the format as shown, but...

If you use the xml template generator in word 2003 you get real problems. Try out this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_wd2003_ta/html/odc_wdxmlresumetemp.asp

The main point here is that you need to create an xslt template to map the document to generate xml. Because it sees the tag <author> once only in the xslt template, it will error.

if you put the author tag in twice then it works. The problem is you do not know how many author tags you require.

It adds a little more weight to my argument that xml is not really a conventional standard at all. The applications to retrieve xml have to be written specifically for each template. I thought the idea of a standard was someting like a text file that you can dts in, open in excel etc.




------------------------------
The Users are always right - when I'm not wrong!
Carlos Urbina
Carlos Urbina
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 1
Thank you for taking the time to help the rest of us.
Stephen Hirsch
Stephen Hirsch
SSC-Enthusiastic
SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)

Group: General Forum Members
Points: 160 Visits: 161

Richard Saul Wurman used to say "Clarify, Don't Simplify". This article proves that point. It is simplified to the point of distortion.

1) XML is nothing in and of itself. It is a metalanguage; i.e., if you want to make a markup language, if you do it this way, then it is XML.

2) Everything depends on your instantiation of XML. In other words, the DTD or Schema that is used is much more critical to the success of your efforts than the various tools mentioned in the article. Designing the DTD/Schema (i.e., the data model) is almost never mentioned, yet that is so much harder to do right than anything else.

3) XML is a lousy data store. It biases towards a hierarchical data structure, which went out of style in the 1980's for a reason. It's incredibly bloated (I remember file sizes 43x the size of the same data stored in a flat file), and the pre-built infrastructure pales in comparison to relational databases.

4) What infrastructure is there is very immature, even after all these years. I was working on the FDA's SPL initiative, which was based on an XML Schema. XML Spy compiled the schema as an XML file, while another tool found errors in the schema as a schema. What good is that?


suresh.patha
suresh.patha
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 8
Hi ....
In this article you have mentioned how to use CDATA..
I am using while CDATA for inserting ..
could you plese tell how to use CDATA for retrieving
ex:INSERT INTO HELLO VALUES( ' ')
but in the table it is stored as &
how to show to user a &

Thanks
suresh.patha
suresh.patha
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 8
Hi ....
In this article you have mentioned how to use CDATA..
I am using while CDATA for inserting ..
could you plese tell how to use CDATA for retrieving
ex:INSERT INTO HELLO VALUES( ' ')
but in the table it is stored as &
how to show to user a " &"

Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search