asp and xml

[Yobbo]

Hi All

Can I use an XML file like I could a database, ie select, insert, update and
delete from it?

If so, how would one do this via standard ASP calls?

If you can't use SQL-style commands how do you use it for storing info?

The reason I ask is that I need a few params storing on a central site and
then other site pull these params remotely. For example, I have one site
that maintains a list of available web site 'skins'. New skins are added,
existing ones updated and deleted via a standard form on a web page and
these changes need to be stored to an XML file rather than a DB such as
MySQL.

As and when a user goes on one of the form pages on the remote sites, the
remote site will then extract these params from this primary XML file.

Another thing to ask is that I want to provide users with the ability to
backup their web site text content without simply giving them the tables to
my database. My plan was to extract the data into an XML file, but not too
sure how you do it. Would I simply build up the file, eg:

<CODE>IVP</CODE>
<DESC>Invoice Paper</DESC>
etc...

and save it into a text file with the suffix of .xml?

How would I then extract this info back out of the file so that I could
update a 'clean' database with it?

Thanks

[Bob Lehmann]

Re: asp and xml

>>My plan was to extract the data into an XML file, but not too sure how
you do it.

You've made all these design / functionality decisions with no obvious
personal knowledge / background of the technologies you want to use.

It's kind of like deciding you want to fly cross-country without ever having
been in a plane, and asking if it's like driving a car.

doh!!!

Bob Lehmann

"Yobbo" <info@NoSpamIt. comwrote in message
news:uuOntvBZHH A.348@TK2MSFTNG P02.phx.gbl...

Hi All
>
Can I use an XML file like I could a database, ie select, insert, update

and

delete from it?
>
If so, how would one do this via standard ASP calls?
>
If you can't use SQL-style commands how do you use it for storing info?
>
The reason I ask is that I need a few params storing on a central site and
then other site pull these params remotely. For example, I have one site
that maintains a list of available web site 'skins'. New skins are added,
existing ones updated and deleted via a standard form on a web page and
these changes need to be stored to an XML file rather than a DB such as
MySQL.
>
As and when a user goes on one of the form pages on the remote sites, the
remote site will then extract these params from this primary XML file.
>
Another thing to ask is that I want to provide users with the ability to
backup their web site text content without simply giving them the tables

to

my database. My plan was to extract the data into an XML file, but not

too

sure how you do it. Would I simply build up the file, eg:
>
<CODE>IVP</CODE>
<DESC>Invoice Paper</DESC>
etc...
>
and save it into a text file with the suffix of .xml?
>
How would I then extract this info back out of the file so that I could
update a 'clean' database with it?
>
Thanks
>
>
>

[Jon Paal [MSMD]]

Re: asp and xml

google:

asp xml -.net



"Yobbo" <info@NoSpamIt. comwrote in message news:uuOntvBZHH A.348@TK2MSFTNG P02.phx.gbl...

Hi All
>
Can I use an XML file like I could a database, ie select, insert, update and
delete from it?
>
If so, how would one do this via standard ASP calls?
>
If you can't use SQL-style commands how do you use it for storing info?
>
The reason I ask is that I need a few params storing on a central site and
then other site pull these params remotely. For example, I have one site
that maintains a list of available web site 'skins'. New skins are added,
existing ones updated and deleted via a standard form on a web page and
these changes need to be stored to an XML file rather than a DB such as
MySQL.
>
As and when a user goes on one of the form pages on the remote sites, the
remote site will then extract these params from this primary XML file.
>
Another thing to ask is that I want to provide users with the ability to
backup their web site text content without simply giving them the tables to
my database. My plan was to extract the data into an XML file, but not too
sure how you do it. Would I simply build up the file, eg:
>
<CODE>IVP</CODE>
<DESC>Invoice Paper</DESC>
etc...
>
and save it into a text file with the suffix of .xml?
>
How would I then extract this info back out of the file so that I could
update a 'clean' database with it?
>
Thanks
>
>
>