help with XML/ASP!

Can u give me a little example of how I would take form data and convert it
to xml using the DOM object ?

"Russell Jones" <arj1@nospam.northstate.net> wrote:
>You can create an XML document either via a DOM object, using its methods
to
>create and append elements, or using simple string processing. There are
>also a number of parsers and XML components available that have support
for
>writing XML. You'll get the best performance by using string processing,
but
>the code may be easier for you to debug if you use the DOM methods. If
>you're using ASP.NET, look at the XmlTextWriter class, which simplifies
>writing XML. If you're using classic ASP, and the data is large, you'll
get
>the best performance by writing a COM object that can insert string values
>into a pre-created buffer.
>
>
>
>"Mattus" <LiquidCorn@hotmail.com> wrote in message
>news:3e7f6c7b$1@tnews.web.dev-archive.com...
>>
>> Hi, I have a pretty simple question but haven't the first clue about xml
>used
>> with ASP and SQL Server:
>>
>> I have an onlne job application form (an .asp page) that the user will
>fill
>> out and send to the server for database storage. I figure this is a good
>> use for XML rather than 150 fields in a table in the database. What I
want
>> to do is: once the form has been submitted to the server, I want to create
>> an XML document that represents the application the user just filled out,
>> and then store the XML document in a field in a table in SQL Server. Then
>> I want to be able to pull the xml out of the database and transform it
for
>> reporting, etc...
>>
>> Does anyone know how I would create the xml document on the server and
>store
>> it in SQL ?
>>
>> Thanks in advance!!
>
>

Thanks Russell!

So where does this Dom document come in? You're saying just to build a string
of xml? Then how would I get that into the database?

Thanks again

"Russell Jones" <arj1@nospam.northstate.net> wrote:
>Here's a very small example, untested, but should be close. The example
>would create a small XML document from two form fields named "value1" and
>"value2".
>
>Dim s
>s = "<?xml version=""1.0""?>"
>s = s & "<values>"
>s = s & "<value1"> & Request.Form("value1") & "</value1>"
>s = s & "<value2"> & Request.Form("value2") & "</value2>"
>s = s & "</values>
>
>The variable "s" now contains the XML document.
>"Mattus" <xml.@127.0.0.1> wrote in message
>news:3e7f72c7$1@tnews.web.dev-archive.com...
>>
>> Can u give me a little example of how I would take form data and convert
>it
>> to xml using the DOM object ?
>>
>>
>> "Russell Jones" <arj1@nospam.northstate.net> wrote:
>> >You can create an XML document either via a DOM object, using its methods
>> to
>> >create and append elements, or using simple string processing. There
are
>> >also a number of parsers and XML components available that have support
>> for
>> >writing XML. You'll get the best performance by using string processing,
>> but
>> >the code may be easier for you to debug if you use the DOM methods. If
>> >you're using ASP.NET, look at the XmlTextWriter class, which simplifies
>> >writing XML. If you're using classic ASP, and the data is large, you'll
>> get
>> >the best performance by writing a COM object that can insert string
>values
>> >into a pre-created buffer.
>> >
>> >
>> >
>> >"Mattus" <LiquidCorn@hotmail.com> wrote in message
>> >news:3e7f6c7b$1@tnews.web.dev-archive.com...
>> >>
>> >> Hi, I have a pretty simple question but haven't the first clue about
>xml
>> >used
>> >> with ASP and SQL Server:
>> >>
>> >> I have an onlne job application form (an .asp page) that the user will
>> >fill
>> >> out and send to the server for database storage. I figure this is a
>good
>> >> use for XML rather than 150 fields in a table in the database. What
I
>> want
>> >> to do is: once the form has been submitted to the server, I want to
>create
>> >> an XML document that represents the application the user just filled
>out,
>> >> and then store the XML document in a field in a table in SQL Server.
>Then
>> >> I want to be able to pull the xml out of the database and transform
it
>> for
>> >> reporting, etc...
>> >>
>> >> Does anyone know how I would create the xml document on the server
and
>> >store
>> >> it in SQL ?
>> >>
>> >> Thanks in advance!!
>> >
>> >
>>
>
>

Sorry, that was the string concatenation example. Here's the same example
using a DOM document object.

set xml = server.CreateObject("MSXML.DOMDocument")
set el = xml.createElement("values")
xml.appendChild(el)
set v1 = xml.createElement("value1")
v1.text = Request.Form("value1")
el.appendChild(v1)
set v2 = xml.createElement("value2")
v2.text = Request.Form("value2")
el.appendChild(v2)
Response.Write(Server.HTMLEncode(xml.xml))

The last line shows you how to get the xml string from the completed
DOMDocument object (the xml property).

"Mattus" <xml.@127.0.0.1> wrote in message
news:3e7f7e72$1@tnews.web.dev-archive.com...
>
> Thanks Russell!
>
> So where does this Dom document come in? You're saying just to build a
string
> of xml? Then how would I get that into the database?
>
> Thanks again
>
> "Russell Jones" <arj1@nospam.northstate.net> wrote:
> >Here's a very small example, untested, but should be close. The example
> >would create a small XML document from two form fields named "value1" and
> >"value2".
> >
> >Dim s
> >s = "<?xml version=""1.0""?>"
> >s = s & "<values>"
> >s = s & "<value1"> & Request.Form("value1") & "</value1>"
> >s = s & "<value2"> & Request.Form("value2") & "</value2>"
> >s = s & "</values>
> >
> >The variable "s" now contains the XML document.
> >"Mattus" <xml.@127.0.0.1> wrote in message
> >news:3e7f72c7$1@tnews.web.dev-archive.com...
> >>
> >> Can u give me a little example of how I would take form data and
convert
> >it
> >> to xml using the DOM object ?
> >>
> >>
> >> "Russell Jones" <arj1@nospam.northstate.net> wrote:
> >> >You can create an XML document either via a DOM object, using its
methods
> >> to
> >> >create and append elements, or using simple string processing. There
> are
> >> >also a number of parsers and XML components available that have
support
> >> for
> >> >writing XML. You'll get the best performance by using string
processing,
> >> but
> >> >the code may be easier for you to debug if you use the DOM methods. If
> >> >you're using ASP.NET, look at the XmlTextWriter class, which
simplifies
> >> >writing XML. If you're using classic ASP, and the data is large,
you'll
> >> get
> >> >the best performance by writing a COM object that can insert string
> >values
> >> >into a pre-created buffer.
> >> >
> >> >
> >> >
> >> >"Mattus" <LiquidCorn@hotmail.com> wrote in message
> >> >news:3e7f6c7b$1@tnews.web.dev-archive.com...
> >> >>
> >> >> Hi, I have a pretty simple question but haven't the first clue about
> >xml
> >> >used
> >> >> with ASP and SQL Server:
> >> >>
> >> >> I have an onlne job application form (an .asp page) that the user
will
> >> >fill
> >> >> out and send to the server for database storage. I figure this is a
> >good
> >> >> use for XML rather than 150 fields in a table in the database. What
> I
> >> want
> >> >> to do is: once the form has been submitted to the server, I want to
> >create
> >> >> an XML document that represents the application the user just filled
> >out,
> >> >> and then store the XML document in a field in a table in SQL Server.
> >Then
> >> >> I want to be able to pull the xml out of the database and transform
> it
> >> for
> >> >> reporting, etc...
> >> >>
> >> >> Does anyone know how I would create the xml document on the server
> and
> >> >store
> >> >> it in SQL ?
> >> >>
> >> >> Thanks in advance!!
> >> >
> >> >
> >>
> >
> >
>

And then I can just select the XML String out of the datbase and use the
DomDocument to extract individual values?

Do you think this would be better to use XML or just regular database fields?
It's a rather long application that the user fills out.

"Russell Jones" <arj1@nospam.northstate.net> wrote:
>In SQL Server, you can put it into a "text" field, which can contain long
>text strings.
>
>"Mattus" <xml.@127.0.0.1> wrote in message
>news:3e809374$1@tnews.web.dev-archive.com...
>>
>> Thanks a lot, Russell!
>>
>> Do you know how I would add this to a database field? Does this xml string
>> go into a binary field or what?
>>
>> And how do I insert it?
>>
>>
>> "Russell Jones" <arj1@nospam.northstate.net> wrote:
>> >Sorry, that was the string concatenation example. Here's the same example
>> >using a DOM document object.
>> >
>> > set xml = server.CreateObject("MSXML.DOMDocument")
>> > set el = xml.createElement("values")
>> > xml.appendChild(el)
>> > set v1 = xml.createElement("value1")
>> > v1.text = Request.Form("value1")
>> > el.appendChild(v1)
>> > set v2 = xml.createElement("value2")
>> > v2.text = Request.Form("value2")
>> > el.appendChild(v2)
>> > Response.Write(Server.HTMLEncode(xml.xml))
>> >
>> >The last line shows you how to get the xml string from the completed
>> >DOMDocument object (the xml property).
>> >
>> >
>> >
>> >"Mattus" <xml.@127.0.0.1> wrote in message
>> >news:3e7f7e72$1@tnews.web.dev-archive.com...
>> >>
>> >> Thanks Russell!
>> >>
>> >> So where does this Dom document come in? You're saying just to build
a
>> >string
>> >> of xml? Then how would I get that into the database?
>> >>
>> >> Thanks again
>> >>
>> >> "Russell Jones" <arj1@nospam.northstate.net> wrote:
>> >> >Here's a very small example, untested, but should be close. The
>example
>> >> >would create a small XML document from two form fields named "value1"
>> and
>> >> >"value2".
>> >> >
>> >> >Dim s
>> >> >s = "<?xml version=""1.0""?>"
>> >> >s = s & "<values>"
>> >> >s = s & "<value1"> & Request.Form("value1") & "</value1>"
>> >> >s = s & "<value2"> & Request.Form("value2") & "</value2>"
>> >> >s = s & "</values>
>> >> >
>> >> >The variable "s" now contains the XML document.
>> >> >"Mattus" <xml.@127.0.0.1> wrote in message
>> >> >news:3e7f72c7$1@tnews.web.dev-archive.com...
>> >> >>
>> >> >> Can u give me a little example of how I would take form data and
>> >convert
>> >> >it
>> >> >> to xml using the DOM object ?
>> >> >>
>> >> >>
>> >> >> "Russell Jones" <arj1@nospam.northstate.net> wrote:
>> >> >> >You can create an XML document either via a DOM object, using its
>> >methods
>> >> >> to
>> >> >> >create and append elements, or using simple string processing.
>There
>> >> are
>> >> >> >also a number of parsers and XML components available that have
>> >support
>> >> >> for
>> >> >> >writing XML. You'll get the best performance by using string
>> >processing,
>> >> >> but
>> >> >> >the code may be easier for you to debug if you use the DOM methods.
>> If
>> >> >> >you're using ASP.NET, look at the XmlTextWriter class, which
>> >simplifies
>> >> >> >writing XML. If you're using classic ASP, and the data is large,
>> >you'll
>> >> >> get
>> >> >> >the best performance by writing a COM object that can insert string
>> >> >values
>> >> >> >into a pre-created buffer.
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> >"Mattus" <LiquidCorn@hotmail.com> wrote in message
>> >> >> >news:3e7f6c7b$1@tnews.web.dev-archive.com...
>> >> >> >>
>> >> >> >> Hi, I have a pretty simple question but haven't the first clue
>about
>> >> >xml
>> >> >> >used
>> >> >> >> with ASP and SQL Server:
>> >> >> >>
>> >> >> >> I have an onlne job application form (an .asp page) that the
user
>> >will
>> >> >> >fill
>> >> >> >> out and send to the server for database storage. I figure this
is
>> a
>> >> >good
>> >> >> >> use for XML rather than 150 fields in a table in the database.
>What
>> >> I
>> >> >> want
>> >> >> >> to do is: once the form has been submitted to the server, I want
>> to
>> >> >create
>> >> >> >> an XML document that represents the application the user just
>filled
>> >> >out,
>> >> >> >> and then store the XML document in a field in a table in SQL
>Server.
>> >> >Then
>> >> >> >> I want to be able to pull the xml out of the database and
>transform
>> >> it
>> >> >> for
>> >> >> >> reporting, etc...
>> >> >> >>
>> >> >> >> Does anyone know how I would create the xml document on the
>server
>> >> and
>> >> >> >store
>> >> >> >> it in SQL ?
>> >> >> >>
>> >> >> >> Thanks in advance!!
>> >> >> >
>> >> >> >
>> >> >>
>> >> >
>> >> >
>> >>
>> >
>> >
>>
>
>