DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 9 of 9

Thread: help with XML/ASP!!

  1. #1
    Mattus Guest

    help with XML/ASP!!


    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!!

  2. #2
    Mattus Guest

    Re: 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.devx.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!!

    >
    >



  3. #3
    Russell Jones Guest

    Re: help with XML/ASP!!

    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.devx.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!!




  4. #4
    Mattus Guest

    Re: help with XML/ASP!!


    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.devx.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.devx.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!!
    >> >
    >> >

    >>

    >
    >



  5. #5
    Russell Jones Guest

    Re: help with XML/ASP!!

    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.devx.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.devx.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!!

    > >
    > >

    >




  6. #6
    Russell Jones Guest

    Re: help with XML/ASP!!

    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.devx.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.devx.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.devx.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!!
    > >> >
    > >> >
    > >>

    > >
    > >

    >




  7. #7
    Mattus Guest

    Re: help with XML/ASP!!


    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.devx.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.devx.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.devx.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!!
    >> >> >
    >> >> >
    >> >>
    >> >
    >> >

    >>

    >
    >



  8. #8
    Mattus Guest

    Re: help with XML/ASP!!



    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.devx.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.devx.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.devx.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.devx.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!!
    >> >> >> >
    >> >> >> >
    >> >> >>
    >> >> >
    >> >> >
    >> >>
    >> >
    >> >

    >>

    >
    >



  9. #9
    Russell Jones Guest

    Re: help with XML/ASP!!

    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.devx.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.devx.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.devx.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.devx.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!!
    > >> >> >
    > >> >> >
    > >> >>
    > >> >
    > >> >
    > >>

    > >
    > >

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center