Query XML data

"JJ" <jjshea@sysmatrix.net> wrote:
>
>I have created an XML file the contains basic application info, eg. App
name,
>app class, primary contact, secondary, and app sponser. I would now like
>to create a way to query that file via a web interface.
>
>For example enter the app name, click query, and generate results based
on
>the XML file. Anyone have any suggestions/examples on how to accomplish
>this. I have been trying to use XML Spy and man am I confused.
>
>I would also like to create a seperate web interface for adding records.
>
>Thanks!!

The easiest way is to use "selectNodes" with an XPath query on the server
side. This will give you back just the parts of the document that you are
interested in.

Now you have a choice - you can do all of this programmatically, writing
code to parse the DOM nodes and formatting them into HTML, or you can use
parameterized XSLT to get the nodes and produce the HTML.

For adding records, you will do somewhat the opposite. Create your basic
XML form (like a VB form), post the data back to the server, and load and
process the XML document there.

BE SURE TO TAKE INTO ACCOUNT THAT MULTIPLE PEOPLE MIGHT BE EDITING THE DOCUMENT
AT THE SAME TIME. Some sort of Application level variable to indicate checkout
would work, but you'll have to figure out how to determine that a user has
cancelled the check-out.

I'm not really sure how XML Spy would help though. :-)

"Jason" <jason@creative_nospam_corp.com> wrote:
>
>"JJ" <jjshea@sysmatrix.net> wrote:
>>
>>I have created an XML file the contains basic application info, eg. App
>name,
>>app class, primary contact, secondary, and app sponser. I would now like
>>to create a way to query that file via a web interface.
>>
>>For example enter the app name, click query, and generate results based
>on
>>the XML file. Anyone have any suggestions/examples on how to accomplish
>>this. I have been trying to use XML Spy and man am I confused.
>>
>>I would also like to create a seperate web interface for adding records.
>>
>>Thanks!!
>
>The easiest way is to use "selectNodes" with an XPath query on the server
>side. This will give you back just the parts of the document that you are
>interested in.
>
>Now you have a choice - you can do all of this programmatically, writing
>code to parse the DOM nodes and formatting them into HTML, or you can use
>parameterized XSLT to get the nodes and produce the HTML.
>
>For adding records, you will do somewhat the opposite. Create your basic
>XML form (like a VB form), post the data back to the server, and load and
>process the XML document there.
>
>BE SURE TO TAKE INTO ACCOUNT THAT MULTIPLE PEOPLE MIGHT BE EDITING THE DOCUMENT
>AT THE SAME TIME. Some sort of Application level variable to indicate checkout
>would work, but you'll have to figure out how to determine that a user has
>cancelled the check-out.
>
>I'm not really sure how XML Spy would help though. :-)
>
Thanks...looks like I have a lot to learn to do this... :-D

Do you have or know where I can get any examples to hack away at?

Thanks, I really appreciate the response. It all seems so confusing...

Thanks!! I really appreciate the advice...will try MS first and the book
if all else fails. XML is really cool stuff!